Viewing 15 posts - 1,216 through 1,230 (of 3,543 total)
Jeff Moden (9/8/2010)
Heh... and HELLLLLL NOOOO!!!! There's no way I'm setting up a Twitter account.
What!! You mean you're not a twit already heh! 😛
September 9, 2010 at 1:40 am
Steve Jones - Editor (9/3/2010)
I'd implement the FK, document my issues, and pull it back out when he complained about performance.
And don't forget the satisfaction of 'I told you so...'...
September 3, 2010 at 8:28 am
WayneS (9/2/2010)
Bezan,David's solution rocks. Just use that.
Thanks Wayne :blush:
Not sure that it rocks, might need a bit of fine tuning 🙂
September 2, 2010 at 9:26 am
Here's my attempt at a solution
SET @sql = 'SELECT CASE ClassificationNo WHEN 1 THEN ''Partner Debit'' WHEN 2 THEN ''Partner Credit'' WHEN 3 THEN ''Account Debit'' WHEN 4 THEN ''Account...
September 2, 2010 at 7:47 am
Jeff Moden (8/31/2010)
... (they had to call me something) ...
Do you want us to suggest something 😛
August 31, 2010 at 8:38 am
Jeff Moden (8/28/2010)
Heh... glad I'm not the only one behind on my posts. 🙂Thanks again, Barry and good to "see" you again... you've been "hiding".
I think he's been lurking behind...
August 31, 2010 at 3:28 am
WayneS (8/27/2010)
Sigh. (Bang head on desk).
PBKAC 😀
August 27, 2010 at 10:49 am
Alvin Ramard (8/27/2010)
Ok, I'll get this started.Hello everyone. I'm Alvin Ramard and I am NOT a DBA. 🙂
Hi, I'm DEFINATELY NOT a DBA
Nor want or will be one,...
August 27, 2010 at 7:41 am
Brandie Tarvin (8/27/2010)
ACK! We've been invaded! There's one of those non-DBA types on this thread.
Shush!
He's not the only one 😛
August 27, 2010 at 7:25 am
John Mitchell-245523 (8/24/2010)
David Burrows (8/24/2010)
INSERT INTO #output(Amount) SELECT Amount FROM #tempd ORDER BY NEWID() ASC
David
I thought of that, and it would certainly work for the sample data provided. However,...
August 24, 2010 at 10:08 am
INSERT INTO #output(Amount) SELECT Amount FROM #tempd ORDER BY NEWID() ASC
August 24, 2010 at 7:07 am
Hugo Kornelis (8/20/2010)
(Steps aside and makes room for the angry comments by those who picked the other option and now "want their point back")
Nope. No angry comment 🙂
It is how...
August 20, 2010 at 9:56 am
LutzM (8/18/2010)
You don't have a "source" defined to apply the WHERE clause to.
Does not have to, this is valid
IF EXISTS (SELECT 1 WHERE MONTH(GETDATE()) IN (1,3,5,7,8,10,12))
PRINT 'yes'
ELSE...
August 18, 2010 at 7:00 am
Lynn Pettis (8/13/2010)
Guess where I'll be on August 29th? At my first Bronco game! Family gave me an early birthday present!
GO Broncos!
Nice! 😀
I got tickets for the...
August 16, 2010 at 1:56 am
If the first proc is truly retruning only one row then make ID an output param and capture it in a variable then execute the second proc using that variable.
e.g.
DECLARE...
August 12, 2010 at 6:58 am
Viewing 15 posts - 1,216 through 1,230 (of 3,543 total)