http://www.sqlservercentral.com/Articles tagged T-SQL, Dynamic SQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?http://www.sqlservercentral.com/redirect/articles/62575/2008/03/20http://www.sqlservercentral.com/redirect/articles/62575/How you use dynamic SQL, when you should - and when you should not. http://www.sqlservercentral.com/redirect/articles/62310/2008/03/18http://www.sqlservercentral.com/redirect/articles/62310/