Viewing 15 posts - 43,876 through 43,890 (of 59,063 total)
Jeff Moden (5/4/2009)
psteja2000 (5/4/2009)
I ended up hacking what I wanted from here:http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/
Not bad... just be advised that there is absolutely no need to resort to the likes of xp_CmdShell or...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 3:57 pm
Jack Corbett (5/4/2009)
Jeff Moden (5/4/2009)
Ramesh (5/4/2009)
I would go with SSIS and the following link should get to startedhttp://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
Not a bad recommendation... I just do it all from T-SQL. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 3:53 pm
psteja2000 (5/4/2009)
I ended up hacking what I wanted from here:http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-text-files/
Not bad... just be advised that there is absolutely no need to resort to the likes of xp_CmdShell or the horribly...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 3:51 pm
Manie Verster (5/4/2009)
gserdijn (5/1/2009)
Manie Verster (4/30/2009) Here is a cursor that I would like you to convert to set for me please. If you can do this I will accept...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 2:37 pm
Sheng (5/3/2009)
Jeff Moden (5/3/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:56 am
Ramesh (5/4/2009)
I would go with SSIS and the following link should get to startedhttp://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx
Not a bad recommendation... I just do it all from T-SQL. I hope to never learn...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:53 am
New uses of something "old" is never a bore. Thank you for the feedback even on old threads.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:40 am
JohnG (5/4/2009)
peter (5/4/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:27 am
Heh... on the other hand, if the worst cursor someone writes is to pass individual records to an email routine, then there also wouldn't be a need for this series...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:24 am
Indianrock (5/4/2009)
But again, the ones that report on stored procedures do almost nothing in our environment since procs are hardly used.
That's why I start performance monitoring at the "Batch Completion"...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:18 am
Steve Jones - Editor (5/4/2009)
Hint taken, it's on the list.
Thanks, Steve. Just an FYI... I've upgraded to the other "sin"... IE8. No changes to report. Everything previously...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:14 am
Lynn Pettis (2/19/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:11 am
James A. Lawrence (5/4/2009)
Just tried this out....good job!Or in SoCal parlance: "Dude, you rock!":cool:
Great to hear, James. Thanks for taking the time to post a reply. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 11:10 am
I missed that, Peter. Thanks for pointing it out.
I agree... there is no need to fill a temp table in SQL Server to read a result set. Of...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 4, 2009 at 5:34 am
In that case, I'd recommend that you remove the index hint and add the proper index as a covering index instead of what you currently have as IX_0. By...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 3, 2009 at 8:43 pm
Viewing 15 posts - 43,876 through 43,890 (of 59,063 total)