Viewing 15 posts - 10,741 through 10,755 (of 26,489 total)
dwilliscp (7/13/2012)
SELECT CASE WHEN data1 = NULL OR data2 = NULL THEN NULL
...
July 13, 2012 at 8:49 am
Although I got it correct, I think the true correct answer should have been Operating System Maximium. This would have taken the version of the OS out of the...
July 12, 2012 at 11:29 pm
I'm guessing that I would need the DDL for your tables, some sample data (10 to 20 rows covering about 3 months time frame), and expected results based on the...
July 12, 2012 at 11:22 pm
capn.hector (7/12/2012)
SQLRNNR (7/12/2012)
And since the old style cannot be easily deprecated, it's best just to teach the new ways imho.
untill you run into a production system using sql 7 because...
July 12, 2012 at 3:52 pm
GilaMonster (7/12/2012)
SELECT <stuff>
FROM t1 CROSS JOIN t2
WHERE t1.ID = t2.OtherID
The point is that joins in the where cannot be deprecated without a substantial...
July 12, 2012 at 2:43 pm
dkschill (7/12/2012)
Just to try a new way to get the end of a day for a date comparison.Didn't want to do the boring old string concatenation...
Date range comparisions should use...
July 12, 2012 at 2:36 pm
Just curious why you are subtracting 1 millisecond.
July 12, 2012 at 2:27 pm
GilaMonster (7/12/2012)
Jan Van der Eecken (7/12/2012)
July 12, 2012 at 1:59 pm
SQLRNNR (7/12/2012)
Never heard of them and would not put too much trust into sites that promote "real answers to real questions"
Don't we offer real answers to real questions? :w00t:
July 12, 2012 at 12:58 pm
Many years ago when I was writing COBOL programs to generate ad hoc reports for users I had one user whose requests were less than useful. I usually spent...
July 12, 2012 at 12:52 pm
Looks good to me. The real test is does the query return what you expect?
July 12, 2012 at 12:09 pm
To add to the code clarity, when you have queries that use both INNER and OUTER joins, it makes the FROM clause much more readable and concise when all the...
July 12, 2012 at 11:42 am
Duplicate post. Please post any responses here.
July 12, 2012 at 10:57 am
Saga... (7/12/2012)
July 12, 2012 at 10:55 am
Jan Van der Eecken (7/12/2012)
I like this reply to JC
Your link does work because of the " around the URL.
July 12, 2012 at 10:41 am
Viewing 15 posts - 10,741 through 10,755 (of 26,489 total)