Viewing 15 posts - 7,096 through 7,110 (of 7,483 total)
river1 (4/7/2010)
because i asked with count(*) instead of exists
That's right, your question was about the syntax of dynamic SQL involving an"if", so I wanted to keep it as close as...
Tom
April 7, 2010 at 4:59 pm
CirquedeSQLeil (4/7/2010)
crookj (4/7/2010)
The Weather has been funny down here in the Springs. Snow for 30 mins the sunshine for 30 - Been back an forth all morning thus far.Joe
Clear...
Tom
April 7, 2010 at 2:01 pm
RBarryYoung (4/7/2010)
Paul:Now I'm curious to know how you did on mine...? (here: http://www.sqlservercentral.com/questions/T-SQL/63632/) Its still got one of the lowest correct percentages that I know of.
It's not surprising...
Tom
April 7, 2010 at 1:46 pm
Kit G (4/7/2010)
Tom
April 7, 2010 at 1:23 pm
Steve Jones - Editor (4/7/2010)
"Oracle sucks, you should use a real database like SQL Server and be sure that you research, test, and document all your code solutions.
And...
Tom
April 7, 2010 at 10:30 am
Kit G (4/1/2010)
Any chance of getting a translation of that Latin in that last paragraph?
OK, but bear in mind that it's 49 years since I last translated a Latin passage...
Tom
April 7, 2010 at 10:29 am
Richard M. (4/1/2010)
Kit G (4/1/2010)
Any chance of getting a translation of that Latin in that last paragraph?One transaltion I got was this
(unbelievable rubbish translation skipped)
Oh God that's awful! If...
Tom
April 7, 2010 at 8:49 am
Splendid!
(or should I say "optime plurimusque eximius"?)
Tom
April 7, 2010 at 8:48 am
Chris Morris-439714 (4/7/2010)
Tom.Thomson (4/7/2010)
Chris Morris-439714 (4/7/2010)
Quiver(Janey from accounts just swished past)
Oh dear, your sig is a little suggestive after that message. I hope she doesn't get to see it:-D.
You...
Tom
April 7, 2010 at 3:49 am
Nice clear question, correct answer, nice clear explanation.
The success rate is amazing. When I read the question I thought there would be a large majority getting it right -...
Tom
April 7, 2010 at 3:09 am
Paul White NZ (4/7/2010)
Toreador (4/7/2010)
Is there any situation where setting ansi_nulls off is a good idea?
I have never come across one. Apart from the bizarre rules illustrated by the...
Tom
April 7, 2010 at 3:05 am
Paul White NZ (4/7/2010)
Any Threadizens going to help push it over 50%?
It will be interesting to see how the success rate...
Tom
April 7, 2010 at 2:58 am
Chris Morris-439714 (4/7/2010)
Quiver(Janey from accounts just swished past)
Oh dear, your sig is a little suggestive after that message. I hope she doesn't get to see it:-D.
Tom
April 7, 2010 at 2:33 am
I interviewed a sysadmin once who said that the action he would take if he detected strange behaviour on the intranet would be to note it in his next monthly...
Tom
April 7, 2010 at 2:17 am
Paul White NZ (4/1/2010)
Hugo Kornelis (3/31/2010)
Tom
April 7, 2010 at 1:29 am
Viewing 15 posts - 7,096 through 7,110 (of 7,483 total)