Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Split function with store procedure Expand / Collapse
Author
Message
Posted Monday, July 28, 2008 10:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 21, 2013 10:59 AM
Points: 22, Visits: 75
Comments posted to this topic are about the item Split function with store procedure
Post #542027
Posted Monday, September 29, 2008 6:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 11:47 PM
Points: 10, Visits: 35
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
Post #577650
Posted Monday, September 29, 2008 7:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:01 AM
Points: 2,693, Visits: 1,173
Ughhh .... try a re-write without a loop and you might get some performance.

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





Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club
Post #577684
Posted Monday, September 29, 2008 8:55 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:05 PM
Points: 3,566, Visits: 72,411
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
For tips on how to post your problems
Post #577767
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse