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 ««1234»»»

PARSENAME Expand / Collapse
Author
Message
Posted Thursday, October 25, 2012 1:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 12:17 PM
Points: 1,095, Visits: 3,182
Thanks for the question ... also didn't know it existed
Post #1376811
Posted Thursday, October 25, 2012 2:31 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 15, 2014 8:05 AM
Points: 1,877, Visits: 518
Another great question to learn from - thanks. I had heard of the function, but never knew what it did.
Post #1376835
Posted Thursday, October 25, 2012 2:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:12 AM
Points: 800, Visits: 260
A new one on me too, I would probably have ended up with really messy instr and substr or perhaps xpath functions to achieve the same.

There is an interesting example of use of PARSENAME with IP addresses which shows a practical application: http://www.sql-server-helper.com/tips/sort-ip-address.aspx
Post #1376846
Posted Thursday, October 25, 2012 4:09 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Learned something new today, not sure I'll ever need to use it, but you never know.

Thanks for the good question.


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1376883
Posted Thursday, October 25, 2012 4:32 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:51 AM
Points: 4,158, Visits: 5,556
Interesting question, thanks Ron

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1376893
Posted Thursday, October 25, 2012 4:57 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, June 12, 2014 4:19 AM
Points: 701, Visits: 1,145
Thank you for the great question. Enjoyed an easy one.
Post #1376911
Posted Thursday, October 25, 2012 6:31 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 1,991, Visits: 1,496
Thank you for the great question. I learned something new today and I already can think of a few applications I can use it with.



Everything is awesome!
Post #1376951
Posted Thursday, October 25, 2012 7:24 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:23 AM
Points: 1,422, Visits: 2,444
Interesting question. I did run into this function once before when looking for a simple way to parse a short delimited string. Unfortunately my string had five elements.
Post #1376978
Posted Thursday, October 25, 2012 8:00 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: Tuesday, September 30, 2014 7:42 AM
Points: 3,688, Visits: 72,435
Koen Verbeeck (10/25/2012)
Great question about a function I didn't even know it existed


I knew it existed, but never had much use for it. A guy who I help with SQL problems on occasion was using it to split a manager heirarchy string I had built.

Still personally don't have much use for it. And one day I'll get him to use Jeff's Delimited8k split function I have available instead, but at least I knew what this was.




--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 #1377002
Posted Thursday, October 25, 2012 10:44 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Thanks for a nice question. BTW, reversal of the order is a frequent pitfall for people who are parsing IPs and do not read the doc carefully enough.
Post #1377128
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse