Split string and display below other column data using SQL Server

Asked Aug 12 '17 at 06:27

Active Aug 12 '17 at 06:57

Viewed 21 times

I am using SQL Server 2014.

I am having following table data.

SRNO    ITEM      DESCRIPTION
----------------------------------------
1       SHOES     BLACK,SPORTS,ADIDAS
2       PEN       RED,STATIONARY,WILLIAM

I want the result as below

SRNO    ITEM                             
------------------------------------------------------------------------
1       SHOES
            BLACK
            SPORTS
            ADIDAS

2       PEN
            RED
            STATIONARY
            WILLIAM

edited Aug 12 '17 at 06:57

marc_s

732,580
175
1,330
1,459

asked Aug 12 '17 at 06:27

Hemal

3,682
1
23
54

How do I show null values in SRNO for description? – Hemal Aug 12 '17 at 06:35
I think this question is not duplicate as you marked it. – Hemal Aug 12 '17 at 06:46

Split string and display below other column data using SQL Server

0 Answers0