How to Get Value from Exec(Sql) in SQL Server 2005 if possible...? help me....

Manish_Kumar_Nayak

thatraja

You can use executesql with Output parameter. sp_executesql (Transact-SQL)[^]

thatraja |Chennai|India|

Brainbench certifications
Down-votes are like kid's kisses don't reject it :-)
Do what you want quickly because the Doomsday on 2012 :-)

Hiren solanki

Use Print(sql) to have a full customized query.

Regards, Hiren. "We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made." - Einstein Microsoft Dynamics CRM