Hi Guys,

I need to parse the following SQl statement, to get an out temporary table
mentioned below. Can anybody help me out in this please.


/* SQL Statement */

update Organisation set IssueRID = 93,
Destination = 'London',
HQOfficeID = 10050
where Organisation = 1498


/* Output required as a temp table */

Column Name Value
----------- ------
IssueRID 93
Destination London
HQOfficeID 10050



Thanks in advance.

Sushant


Disclaimer: Any views or opinions expressed in this e-mail and its attachments are solely those of the author and do not necessarily represent those of PIMS UK Limited.
Confidentiality: This e-mail and its attachments are solely intended for the ordinary user of the e-mail address to which it was addressed and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show all or any of them to anyone. If you receive this e-mail in error, we should be obliged if you would e-mail our postmaster at [Email Address Removed] and highlight the error. Thank you.
Security Warning: Please note that this e-mail has been created in the knowledge that internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us.
Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free.
MS Sql Server LazyDBA home page