Viewing 15 posts - 616 through 630 (of 667 total)
GSquared (4/29/2009)
You're looking at the right columns. They've been Int all along. It's a pain.
Sorry G, I must have misunderstood. Thought you meant earlier that the MS guys...
April 29, 2009 at 4:19 pm
David Webb (4/29/2009)
April 29, 2009 at 4:15 pm
Jan Van der Eecken (4/29/2009)
Jeff Moden (4/28/2009)
Sergiy (4/28/2009)
Jeff Moden (4/27/2009)
I don't allow such garbage into my db's to begin with. 😛
I believe this is the method that doesn't suck so...
April 29, 2009 at 7:47 am
Jeff Moden (4/28/2009)
Sergiy (4/28/2009)
Jeff Moden (4/27/2009)
I don't allow such garbage into my db's to begin with. 😛I believe this is the method that doesn't suck so much.
:hehe:
Heh... I just knew...
April 29, 2009 at 7:32 am
The QoTD did not mention which version of SQL it was referring to. That's why further up I said that the link given in the explanation mentions SQL2000, and that...
April 21, 2009 at 1:31 am
Piyush,
I beg to differ. Try this:
CREATE FUNCTION [dbo].[usfn_GetDateTime] ( )
RETURNS datetime
AS
BEGIN
RETURN GETDATE ( )
END
GO
SELECT [dbo].[usfn_GetDateTime]()
Although GETDATE() is clearly non-deterministic this compiles properly and the SELECT statement returns...
April 21, 2009 at 1:10 am
Douglas Duncan (4/11/2009)
April 15, 2009 at 5:06 am
... My dad taught at a university and was given by someone (I never knew who) a 4-foot section of a four-by-four with one end shaped into the handle of...
April 2, 2009 at 4:53 pm
Looking at the original sample the OP posted Chris may be right when he says
Horizontally you do not need to do anything anymore since the tuples are already sorted.
But then,...
April 2, 2009 at 4:34 pm
I agree with Chris. But now, in the presence of NULLs in any of the columns, how can simultaneous horizontal and vertical comparisons work without introducing some artificial replacement values...
April 2, 2009 at 4:23 pm
And by the way, since this seems to be just a sample of data to be sorted with 3 columns and five rows, have you considered what would happen to...
April 2, 2009 at 4:02 pm
Jsanborn, why don't you go back to the basics and try to come up with a MANUAL algorithm that comes up with the desired result in ALL cases? And then...
April 2, 2009 at 3:50 pm
Steve Jones - Editor (4/1/2009)
Not sure I want to joke about us taking over SQL Server development, they might buy us and make us help! :hehe::-P:w00t:
You must be careful with...
April 1, 2009 at 4:10 pm
Another thing you should definitely do is download a copy of SQL Server Express as well as SQL Server Books Online (highly commended, the most valuable resource of information on...
April 1, 2009 at 3:56 pm
Then again, why not? Windows NT was built with a Hardware Abstraction Layer underneath it, so all you need is a HAL that runs on Solaris machines or whatever plus...
April 1, 2009 at 3:22 pm
Viewing 15 posts - 616 through 630 (of 667 total)