Home Forums SQL Server 2012 SQL Server 2012 - T-SQL querry get data in double codes in string RE: querry get data in double codes in string

  • February 9, 2014 at 7:06 pm

    #1687412

    mpradeep23 (2/9/2014)

    Hi all

    i have data like this

    "entitlementwrapper" : [ {

    "Type" : "Factory Warranty",

    "Date_Type" : "Ship date",

    "Status" : "Active",

    "Start_Date" : "2012-12-21",

    "End_Date" : "2014-01-19",

    "Days_Left" : "116",

    "Term" : "13",

    "Description" : "Wty: HP HW Replacement Support",

    "IsTrusted" : "Y",

    "Transaction_ID" : "4644780453"

    }

    i want to get only data in double codes in using sql querry

    thanks,

    Pradeep

    If given the data above, precisely what do you want for an output?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)