November 13, 2009 at 1:18 pm
Hi I've been using the following example for dynamic SQL:
http://www.databasejournal.com/features/mssql/article.php/3830981/T-SQL-Best-Practices--Part-2.htm
But all I am able to get for my where clause is the last where clause item sent in as a parameter. It seems to be overwriting the where clause from the previous parameters sent in. Any help is appreciated.
November 13, 2009 at 1:30 pm
What is the script you have?
Post it here.
Without that we have to do guess work on your script...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 16, 2009 at 6:36 am
Bru is correct. We can't really help unless you post your code.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply