Viewing 15 posts - 31 through 45 (of 55 total)
Didn't notice it was a table variable! Gah! 🙂
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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,...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
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...
-------------------------------Oh no!
November 25, 2009 at 10:07 am
Tom.Thomson (10/27/2009)
Kevin Gill (8/14/2009)
-------------------------------Oh no!
October 28, 2009 at 3:54 am
Viewing 15 posts - 31 through 45 (of 55 total)