Viewing 15 posts - 31 through 45 (of 54 total)
Didn't notice it was a table variable! Gah! 🙂
October 8, 2010 at 3:20 am
Kenneth J. Moore (5/24/2010)
I really just guessed after about 30 seconds of trying to follow the logic. Only off by 1.0000!
Yeah that was me too. I looked at the date...
May 25, 2010 at 2:38 am
It should be added at this point that ColdCoffee's solutions produce the set you wish to exclude (i.e. those that ARE in one of those tables) whereas mine is intended...
May 12, 2010 at 5:15 am
sachinrshetty (5/12/2010)
LEFT JOIN EIS_COMPANY ECM ON EP.EMPLOYEE_ID = ECM.EMPLOYEE_ID
LEFT JOIN MASTER_BUSINESSUNIT MB ON ECM.BUSINESSUNIT_ID = MB.BUSINESSUNIT_ID
RIGHT JOIN...
May 12, 2010 at 4:55 am
I do find it quite funny that though the question asks 'which edition of SQL Server 2008...' at least 30 people think the correct edition of SQL2008 is 'Sql Server...
May 12, 2010 at 2:31 am
Lynn Pettis (1/15/2010)
When taking a test, particularly a multiple choice (multiple guess, if you prefer) don't you read the entire question and the answers before actually answering the question?
I do,...
January 15, 2010 at 10:57 am
Lynn Pettis (1/15/2010)
declare @TestTab table (TableID int, TableData varchar(32));
set @TestTab = null;
Result:
Msg 137, Level 15, State 1, Line 2
Must declare the scalar variable "@TestTab".
Cheers - I could have just tested...
January 15, 2010 at 10:23 am
In fact, I'll go further (and you can't stop me ;o))
Whenever I miss the intended point of one of these questions, it's usually because I've not paid attention to the...
January 15, 2010 at 10:21 am
To my mind, this question could/should have been moderated and edited to make it clearer.
Even though I would have got it wrong had it actually been asking what I...
January 15, 2010 at 10:12 am
When ANSI_DEFAULTS is enabled (ON), this option enables the following ISO settings:...SET IMPLICIT_TRANSACTIONS. Msg 3903 The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
The explanation doesn't quite make sense...
January 13, 2010 at 2:10 am
Carlo Romagnano (11/27/2009)
Rob Goddard (11/27/2009)
does the optimizer spot this and skip all the variable assignments and just do the last one?All the variable assignments are done.
I spose this makes sense...
November 27, 2009 at 10:20 am
dun (11/26/2009)
This was a great instructional puzzle. I appreciate the corporate knowledge this forum represents. Thanks.
Glad you enjoyed it 🙂 This example actually came to mind because of the amount...
November 26, 2009 at 7:30 am
You say that salary * 115 / 100 and (salary * 115) / 100 return different results due to operator precedence - I can't see how operator precedence makes any...
November 26, 2009 at 2:51 am
cengland0 (11/25/2009)
Wouldn't you always get a row returned with the COUNT(*) aggregate? It might return 0 as the result but that still returns a row.
Indeed - if you slot...
November 25, 2009 at 10:07 am
Tom.Thomson (10/27/2009)
Kevin Gill (8/14/2009)
October 28, 2009 at 3:54 am
Viewing 15 posts - 31 through 45 (of 54 total)