Viewing 15 posts - 33,346 through 33,360 (of 59,102 total)
David Burrows (7/6/2011)
Jeff Moden (7/5/2011)
This turned into a "watercooler" thread a long time ago and anyone with a minor dose of manners and a sense of humor is invited.
Damn! Counts...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 5:48 am
opc.three (7/6/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 5:44 am
ken_wenze (7/6/2011)
Jeff - This looks pretty good but how would i modify this to loop through every sub directory in a folder such as C:\MyFolder
Hi Ken,
Are you allowed to use...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 5:29 am
Deee -Daah! (7/6/2011)
1) create a batch file with the following code to list files in folders and subfolders:
@echo off
cd c:\MyFolder
FOR...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 7, 2011 at 5:22 am
Chris,
Do you know of a way to use the rCTE to do a running total without the ID's being perfectly sequential?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2011 at 7:40 pm
To go along with Bruce's post, I can't stress enough that a whole lot more CAN be done using set-based code than a lot of folks think. There are...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2011 at 4:56 pm
itwhiz (7/6/2011)
So I've had a go with the routine that you suggested, but it's doesn't quite do what I want.
I may not of explained myself very well in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2011 at 4:46 pm
Elliott Whitlow (7/6/2011)
Coming back in a little late to the discussion..Jeff, business users won't take ownership unless you make them.
That's just not true, Elliott. Maybe not for...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 6, 2011 at 4:41 pm
There're a few optimizations I might make for performance but it looks real good, Greg.
If you notice, the final entry didn't really get as close to zero as bankers and...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 7:31 pm
It may make a difference...
Where will the result set of this query be used? In a reporting tool? In a GUI? or ???
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 7:05 pm
Sure... take a look at the following article. And, no... not limited to 10 items. 😉
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 6:57 pm
Tom Rippetoe (7/5/2011)
- populate a cursor with each combination of segment id, begin location, and end location
- for each record in the cursor,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 6:52 pm
Koen Verbeeck (7/3/2011)
Jeff Moden (7/2/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.
Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected again....
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 6:10 pm
Gianluca Sartori (7/4/2011)
Looks like I missed a lot of things during the weekend...Congratulations to Gail, Jeff and everyone else who got renewed!!!
Thanks, Gianluca.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 6:09 pm
SwayneBell (7/4/2011)
Jeff Moden (7/2/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected again. 🙂
I...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 5, 2011 at 6:05 pm
Viewing 15 posts - 33,346 through 33,360 (of 59,102 total)