Viewing 15 posts - 211 through 225 (of 346 total)
If you want to switch on null, use this
WHERE
(COALESCE(Database_Status,Instance_Status) = N'deployed')
June 15, 2011 at 8:35 am
Sounds like this is what you are trying to accomplish
CASE WHEN ISNULL(Database_Status,'') = 'deployed' THEN Database_Status ELSE Instance_Status END
but I can't be sure without seeing the whole query.
June 15, 2011 at 7:25 am
Jeff Moden (6/13/2011)
sql_jr (6/13/2011)
June 13, 2011 at 4:29 pm
I think I have a solution I can live with. I removed the extra table to hold the ID's that have been tried already and instead I'm putting a datetime...
June 10, 2011 at 9:08 am
I play racquetball which keeps me in shape but also keeps my joints in constant pain. Other evenings I shoot pool (billiards).
What kind of computer games do you guys play?...
June 10, 2011 at 7:33 am
Steve Jones - SSC Editor (6/8/2011)
This whole thread has a lot of nonsense in it :hehe:
Don't dodge the question, Steve Jones, does 1=0.999...?
😀
June 9, 2011 at 3:32 pm
Science declares everything nonsense until it can be explained by science, then it's "well of course!"
Science is a process for discovery, a methodology for explaining phenomenon, not a organizational...
June 9, 2011 at 3:30 pm
drew.allen (6/9/2011)
If it requires user interaction, it really belongs in the front end. Triggers are about as far from the front end as you can get.
I agree, and I'm...
June 9, 2011 at 9:11 am
Mike01 (6/9/2011)
June 9, 2011 at 8:46 am
Oh wow, I didn't notice the same table is being updated in the trigger. I assumed he was updating a second table because the first option doesn't make sense! :w00t:
4R4,...
June 9, 2011 at 7:58 am
It's taking a long time because you are running 200 subselects (which it looks like this trigger will break if more than one row is inserted.) Change the statement to...
June 9, 2011 at 7:23 am
CELKO (6/3/2011)
Now, download the Rick Snodgrass book on Temporal Queries in SQL from the University of Arizona website (it is free).
Dr. Snodgrass has a ton of books and...
June 8, 2011 at 10:34 am
GSquared (6/8/2011)
toddasd (6/7/2011)
Richard Warr (6/6/2011)
toddasd (6/6/2011)
Answer this: do you consider this to be true: 1/3 = 0.333...?No, however that is the only way you can represent 1/3 as a decimal.
That's...
June 8, 2011 at 6:59 am
Richard Warr (6/6/2011)
toddasd (6/6/2011)
Answer this: do you consider this to be true: 1/3 = 0.333...?No, however that is the only way you can represent 1/3 as a decimal.
That's a great...
June 7, 2011 at 2:44 pm
mtillman-921105 (6/6/2011)
June 6, 2011 at 10:27 am
Viewing 15 posts - 211 through 225 (of 346 total)