SELECT a String

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  December 1, 2014 at 11:41 am

  #299008

  Hi I have string as below:

  InvoiceTemplateId= SOURCE.InvoiceTemplateId

  ,Name= SOURCE.Name

  ,DetailTotalUnitsQty= SOURCE.DetailTotalUnitsQty

  ,InsertedDate= SOURCE.InsertedDate

  ,UpdatedDate= SOURCE.UpdatedDate

  ,Distributor_Id= SOURCE.Distributor_Id

  ,InsertedBy= SOURCE.InsertedBy

  ,UpdatedBy= SOURCE.UpdatedBy

  I need a string Like below:

  Name= SOURCE.Name

  ,DetailTotalUnitsQty= SOURCE.DetailTotalUnitsQty

  ,InsertedDate= SOURCE.InsertedDate

  ,UpdatedDate= SOURCE.UpdatedDate

  ,Distributor_Id= SOURCE.Distributor_Id

  ,InsertedBy= SOURCE.InsertedBy

  ,UpdatedBy= SOURCE.UpdatedBy

  So I need every thing except the First value before first comma . So could some one help in TSQL .. Thanks in Advance

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  December 1, 2014 at 11:55 am

  #1761830

  I'm leaving 3 possible options. Please don't cross post as it will only fragment the answers.

  SELECT String,

  STUFF( String, 1, CHARINDEX( ',', String), ''),

  SUBSTRING( String, CHARINDEX( ',', String) + 1, 8000),

  RIGHT( String, LEN(String) - CHARINDEX( ',', String))

  FROM ( VALUES(

  'InvoiceTemplateId= SOURCE.InvoiceTemplateId

  ,Name= SOURCE.Name

  ,DetailTotalUnitsQty= SOURCE.DetailTotalUnitsQty

  ,InsertedDate= SOURCE.InsertedDate

  ,UpdatedDate= SOURCE.UpdatedDate

  ,Distributor_Id= SOURCE.Distributor_Id

  ,InsertedBy= SOURCE.InsertedBy

  ,UpdatedBy= SOURCE.UpdatedBy'))x(String)

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2