Home Forums SQL Server 2008 SQL Server Newbies read multiple fields with common delimited data into either a temp table or table variable without using cursors RE: read multiple fields with common delimited data into either a temp table or table variable without using cursors

  • September 25, 2012 at 3:54 am

    #1541733

    Using function u can get desired result without cursors.I created split function above use that.

    Declare @asd nvarchar(100)

    select @asd=Field1 from Test where create_dt='24/Sep/2012'

    Select Data as Field1 from Split(@asd,'|')