Viewing 15 posts - 211 through 225 (of 345 total)
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.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 15, 2011 at 7:25 am
Jeff Moden (6/13/2011)
sql_jr (6/13/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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?...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...?
😀
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 9, 2011 at 9:11 am
Mike01 (6/9/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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,...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
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...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 7, 2011 at 2:44 pm
mtillman-921105 (6/6/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 6, 2011 at 10:27 am
Richard Warr (6/6/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
June 6, 2011 at 10:00 am
Viewing 15 posts - 211 through 225 (of 345 total)