Split function with store procedure

Question

Split function with store procedure

Atd

SSC Enthusiast

Points: 182
More actions
July 28, 2008 at 10:25 am

#188802

Comments posted to this topic are about the item Split function with store procedure

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chris Harris-622214 Old Hand Points: 386 More actions · Answer 1

It still boggles my mind that tSQL doesn't have a built in function for this, but thank you very much for providing it. I've needed one several times in the past but hadn't found one that worked well for me.

Thank you,

Chris

philcart SSC-Forever Points: 47794 More actions · Answer 2

Ughhh .... try a re-write without a loop and you might get some performance.

http://philcart.blogspot.com/2007/06/split-function.html

--------------------
Colt 45 - the original point and click interface

mtassin SSC-Insane Points: 23099 More actions · Answer 3

Yah I was going to jump all over this RBAR stuff... but Phil beat me to it.

I forsee Jeff M coming along and bopping you on your head too 🙂

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]