Viewing 15 posts - 11,401 through 11,415 (of 15,376 total)
Well your first case condition is wrapped with double quotes. If that doesn't fix it you need to provide ddl and sample data that is readily consumable (meaning I can...
July 6, 2012 at 12:15 pm
KWymore (7/6/2012)
Points back, Steve?
I think you just figured how to get them back yourself. 😉
July 6, 2012 at 8:41 am
isuckatsql (7/6/2012)
Sean,Thanks for you help!
A case of 'you can't see the woods, for the trees!'
Ian
You're welcome. Glad that worked for you.
July 6, 2012 at 7:28 am
If a users enters @Degree data, that mean that they want all the candidates with a specific degree.
The problem is that since people may have up to three degrees, i...
July 5, 2012 at 8:10 pm
zxxz (7/5/2012)
I have updated the top post to add some sample data. Thanks guys.
That is better but...nobody can run that. We are all volunteers around here and nobody wants to...
July 5, 2012 at 3:42 pm
isuckatsql (7/5/2012)
if (@Degree <> 0)
Begin
if (' p.Degree1id ' > ' p.Degree2id ' and ' p.Degree1id ' > ' p.Degree3id ')...
July 5, 2012 at 3:06 pm
And FWIW from the description and the cursor you posted I don't think there is any need at all for a cursor. Cursors are notoriously slow and should be avoided...
July 5, 2012 at 1:47 pm
It isn't just the links but making them a bit more clear helps. From what you posted nobody can run anything. It is impossible to test sql when there are...
July 5, 2012 at 1:42 pm
Bobby Glover (7/5/2012)
The data types on the tables are not in...
July 5, 2012 at 12:22 pm
Rich Weissler (7/5/2012)
Sean Lange (7/5/2012)
You have to answer it correct according to BOL AND read the authors mind at the same time.
It's worse than that. The author said...
July 5, 2012 at 12:16 pm
pnpsql (7/5/2012)
July 5, 2012 at 12:07 pm
freida1973 (7/5/2012)
Thanks Sean, I will be sure to follow the etiquette when posting in questions in the future.Sorry about that.
No worries at all. It just helps when you put...
July 5, 2012 at 11:56 am
SQLRNNR (7/5/2012)
July 5, 2012 at 10:30 am
Wow this is truly is the worst type of question. You have to answer it correct according to BOL AND read the authors mind at the same time. Then come...
July 5, 2012 at 10:22 am
Hi and welcome to SSC. It seems that you still have an unanswered question or two? It will greatly increase your chances of getting help from people if you post...
July 5, 2012 at 10:09 am
Viewing 15 posts - 11,401 through 11,415 (of 15,376 total)