Viewing 15 posts - 10,366 through 10,380 (of 26,489 total)
Just thought of a change in the code. Be back in a few.
July 31, 2012 at 4:15 pm
Here is what I came up with based on what you provided. Feel free to modify as needed (and you will as I used the DelimitedSplit routine I have...
July 31, 2012 at 4:14 pm
Charlottecb (7/31/2012)
July 31, 2012 at 2:58 pm
One thing I think the article leaves out (I haven't read it in a long time) may be expected results. Based on your sample data, what do you expect...
July 31, 2012 at 2:17 pm
CELKO (7/31/2012)
The main advantages of the long parameter lists are:
1) The code is highly portable to any Standard SQL. One product bigots need to get over the idea that they...
July 31, 2012 at 2:05 pm
Well, there are better DelimitedSplit routines out there (http://www.sqlservercentral.com/articles/Tally+Table/72993/, for a highly optimized 8K splitter (read the article and the discussion)).
Unfortunately, there is nothing else in your post for us...
July 31, 2012 at 1:42 pm
Let me take this a bit further. Where I am working now, people in the office will "telecommute" to local meetings. Since we do have geographically dispersed work...
July 31, 2012 at 1:21 pm
sku370870 (7/31/2012)
I've been plodding away all afternoon and ended up with this (don't claim to have come up with it, had some...
July 31, 2012 at 12:49 pm
ahperez (7/31/2012)
Have you tried these articles?Restore and Recovery of Backups
http://msdn.microsoft.com/en-us/library/ms191455(v=SQL.105).aspx
Controlling Creation of Added Files During Roll Forward
http://msdn.microsoft.com/en-us/library/ms190208(v=sql.105).aspx
Makingit easier for others:
Restore and Recovery of Backups
http://msdn.microsoft.com/en-us/library/ms191455(v=SQL.105).aspx
Controlling Creation...
July 31, 2012 at 12:17 pm
SQLRNNR (7/31/2012)
Lynn Pettis (7/30/2012)
July 31, 2012 at 12:02 pm
Decided to try this myself since I haven't used recursive CTE's. It was a good exercise.
CREATE TABLE #tblItems
(
...
July 31, 2012 at 11:45 am
You need to use a delimited splitter like the one developed by Jeff Moden and the ssc community. Start by reading this article and the discussion that goes with...
July 31, 2012 at 1:45 am
Also, think about this, do you really need someone on-site 5 days a week? My past experience working with SQL Server has actually shown me that I can do...
July 30, 2012 at 10:53 pm
All I said was it could be done without dynamic sql.
Also, based on what you need it can be done dynamically without using the system tables you used in the...
July 30, 2012 at 7:54 pm
Viewing 15 posts - 10,366 through 10,380 (of 26,489 total)