Dynamic query in SQL

[siva455]

Hi, Please let me know what is dynamic query in SQL server with example...

[Simon_Whale]

This is a great article on the subject with examples too Dynamic SQL[^]

As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.

[Dalek Dave]

This may help.[^]

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]