MS SQL query help RRS feed

  • Question


    I have a column that has a bunch of random comment data in it. i need to parse out some specific things that are in this field. here as an example of one of the rows. 

    Effective: 07/01/2020 Seller Type: Dealer 9 Month Premium | Inventory = 220 Promo Intro Rate = $5.00 Budget Cap = $15.00 (Fixed $5.00 + Variable $10.00) Months 1-3 = $1,100.00 (inventory X intro) Months 4-9 (varies) = $1,100.00 fixed - $3,300.00 budget cap Additional Fulfillment Details TBD: See BB/KB for questions!

    One other thing to note is that each comment row is different and don't have all this information, or it might not be in the same order. 

    i need to parses out the Budget cap rate and the base rate which is $1,100 in this case into 2 extra columns. Any ideas on how to do this would be very appreciated. 

    Sunday, December 13, 2020 2:58 AM

All replies

  • Hi

    Here is a link for round function details: msdn link

    Best Regards.

    Please click the Mark as answer button and vote as helpful if this reply solves your problem.

    • Proposed as answer by KHURRAM RAHIM Sunday, December 13, 2020 2:21 PM
    Sunday, December 13, 2020 6:41 AM