Viewing 15 posts - 1,216 through 1,230 (of 3,544 total)
sangeethu (9/9/2010)
Thanks for the reply. I have gone through Cross Tab and Dynamic Cross tab and found that it involves aggregation of a column. But in my case every...
Far away is close at hand in the images of elsewhere.
Anon.
September 9, 2010 at 6:40 am
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! 😛
Far away is close at hand in the images of elsewhere.
Anon.
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...'...
Far away is close at hand in the images of elsewhere.
Anon.
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 🙂
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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 😛
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
August 31, 2010 at 3:28 am
WayneS (8/27/2010)
Sigh. (Bang head on desk).
PBKAC 😀
Far away is close at hand in the images of elsewhere.
Anon.
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,...
Far away is close at hand in the images of elsewhere.
Anon.
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 😛
Far away is close at hand in the images of elsewhere.
Anon.
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,...
Far away is close at hand in the images of elsewhere.
Anon.
August 24, 2010 at 10:08 am
INSERT INTO #output(Amount) SELECT Amount FROM #tempd ORDER BY NEWID() ASC
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
August 16, 2010 at 1:56 am
Viewing 15 posts - 1,216 through 1,230 (of 3,544 total)