Viewing 15 posts - 2,101 through 2,115 (of 4,080 total)
This could be done in one statement, or with a function, but the CTEs make it a little easier to read. The first CTE uses the STUFF() function to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 8:12 pm
I'm late to the party on this one, but got it right from reading the Inside SQL Server 2005 books. Kalen Delaney stressed that it was balanced. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 7:11 pm
Yowch, really sorry to hear that, Barry. I will shift to you all the good vibes I can pour into the Force.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 5:28 pm
Jack, the last time I swapped emails with Flo, they were getting ready to launch a big project at his place of work. He told me it might...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 4:26 pm
Lynn, with all that vacation I would have expected you to be more patient.
Did you leave your halo at the beach? 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 3:01 pm
If it's any help, I always think of him as "Crawfish" (yes, I know it's Crawford). 😉
Good to see you back posting in the main forums, Jack. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 2:31 pm
Is this what you're looking for?
-- the ctes get you the date
;with cte1 (DateColumn) as (select distinct dateadd(day,datediff(day,0,DateColumn,0) from dbo.MyTable)
,cte2 (DateColumn,rowID) as (select DateColumn,row_number() over(order by DateColumn) from...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 10:56 am
Do you have a calendar table of some sort that designates holidays and/or weekends?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 10:34 am
Psssst Trudye.
"Champion" is Jeff's title. His name is just above it.
Or shall we start referring to you simply as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 26, 2009 at 6:44 am
Good question and interesting result. I'm surprised that it accepted mixed dots and dashes as separators in the date. I thought it would break if I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 25, 2009 at 9:04 pm
Good to hear, Jack 🙂 🙂 🙂
Barry, congratulations on getting my question right on the first try. I predict it will be very profitable for you. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 25, 2009 at 8:53 pm
The "cannibalism" episode from the last season of Gilligan's Island was banned by the sensors.
It was a kindler, gentler time.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 25, 2009 at 8:51 pm
There is no need to save your spreadsheet as a text file. From the Import Data task, you should be able to select a datasource called "Microsoft Excel"...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 25, 2009 at 8:13 pm
Thank you very much for taking the time to set up the problem so nicely. While I am having to guess at your expected output from the sample data...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 25, 2009 at 8:09 pm
They are old school, which I can appreciate, but you are just wasting CPU cycles.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 25, 2009 at 4:37 pm
Viewing 15 posts - 2,101 through 2,115 (of 4,080 total)