Post reply

PARSENAME

  • October 24, 2012 at 8:47 pm

    #270188

    Comments posted to this topic are about the item PARSENAME

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 24, 2012 at 10:26 pm

    #1552501

    Thanks for Good question..

    "Eid Mubarak" to all my SQL Friends.. 🙂

  • October 24, 2012 at 11:52 pm

    #1552509

    Jamsheer (10/24/2012)

    Thanks for Good question..

    "Eid Mubarak" to all my SQL Friends.. 🙂

    Eid mubara Jamsheer..

    I knew of the PARSENAME ..there is a wonderful use of this for taking out the dot separated values, although with limits..

    good question..

    thanks

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • October 25, 2012 at 12:22 am

    #1552515

    Great question about a function I didn't even know it existed 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 25, 2012 at 12:32 am

    #1552518

    new for me..Leant n got +1:)

  • October 25, 2012 at 12:36 am

    #1552519

    Thanks for this question Ron. I was little confused when I saw this phrase "USING SQL SERVER 2012" 🙂

    I think PARSENAME result will remain same for SS2005, SS2008, SS2008 R2 and SS2012!

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • October 25, 2012 at 12:37 am

    #1552520

    Jamsheer (10/24/2012)

    Thanks for Good question..

    "Eid Mubarak" to all my SQL Friends.. 🙂

    "Eid Mubarak" Jamsheer 🙂

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • October 25, 2012 at 1:10 am

    #1552525

    Nice question, new function for me 🙂 It might be very useful. Thx

  • October 25, 2012 at 1:17 am

    #1552527

    Thanks for the question. I did not knew it exist.

    Iulian

  • October 25, 2012 at 1:20 am

    #1552528

    Lokesh Vij (10/25/2012)

    I think PARSENAME result will remain same for SS2005, SS2008, SS2008 R2 and SS2012!

    Indeed it does.

    Steve Hall
    Linkedin
    Blog Site

  • October 25, 2012 at 1:22 am

    #1552530

    Thanks for the question ... also didn't know it existed

  • October 25, 2012 at 2:31 am

    #1552553

    Another great question to learn from - thanks. I had heard of the function, but never knew what it did.

  • October 25, 2012 at 2:54 am

    #1552563

    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

  • October 25, 2012 at 4:09 am

    #1552597

    Learned something new today, not sure I'll ever need to use it, but you never know.

    Thanks for the good question. 😀

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • October 25, 2012 at 4:32 am

    This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 32 total)

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