Viewing 15 posts - 46,996 through 47,010 (of 59,064 total)
CheeseMan316 (11/24/2008)
Thanks for all the responses and thanks yuvalpe for identifying the original source of that query.
Actually, you need to look at the post just above yuvalpe's... 😉
November 24, 2008 at 6:44 pm
jeffery.baynard (11/24/2008)
Itzik uses RECURSION, even faster.With nums as
(
Select 1 as n
Union all
Select n+1 from nums where n < 10
)
Select n
From nums
As...
November 24, 2008 at 6:40 pm
jacroberts (11/24/2008)
November 24, 2008 at 6:49 am
Or the worst, depending on how you look at it.
Is it me, or is it just the "language barrier"? Have these people no clue as to what a little...
November 24, 2008 at 6:45 am
sqlizer (11/24/2008)
Why do you guys even reply, just delete his/her post.
Heh... part of his training to be a DBA. 😉
November 24, 2008 at 6:41 am
Heh... never mind... not enough coffee... this is a matrix they want and they want to be able to address the data by the individual elements using j,k coorinates. ...
November 24, 2008 at 6:32 am
Then you don't need to do the formatting in the file you send because the spreadsheet is gonna format it the way it want's. In fact, you adding commas...
November 24, 2008 at 6:25 am
If it's on the GUI side that you want to do this, then I'm not sure.
If it's on the SQL Server side of the house, a trip to Books Online...
November 24, 2008 at 6:22 am
Again... Lookup SQL Server Certification on the Microsoft Website...
November 24, 2008 at 6:20 am
I'm getting ready to go to work, so I can't solve it all right this instant.
I do have a question, though... are all of these values for a single column...
November 24, 2008 at 6:18 am
Peso (11/24/2008)
Jeff's simplified.SELECT DATEADD(wk,DATEDIFF(wk, 0, getdate()), 6)
However when run on a sunday, the code returns following sunday.
My suggestion returns same sunday if run on a sunday.
Heh.. yeah... I did...
November 24, 2008 at 6:11 am
yuvalpe (11/24/2008)
This topic was cover complitly by Itzik Ben-Gan years ago
So? There's lot's of folks that don't even know who he is, never mind what a Numbers or Tally...
November 24, 2008 at 6:06 am
jacroberts (11/24/2008)
e.g.:
CREATE FUNCTION [dbo].[Nums]
(
@StartNum int,
@EndNum int
)
RETURNS...
November 24, 2008 at 6:04 am
It was very difficult to maintain any semblance of professionalism on that one. Some of these folks need to clean the pipe they're smoking. 😛
November 24, 2008 at 6:00 am
Just an FYI... the source of the CTE in your article is by a fellow called Itzik Ben-Gan and can be found at the bottom of page 255 in a...
November 24, 2008 at 2:20 am
Viewing 15 posts - 46,996 through 47,010 (of 59,064 total)