triphen
asked on
SQL Syntax Parsing one record into multiple
Hello Experts,
I am using SyBase SQL Anywhere 10 and VS 2015 C#
This is what I have
ID Employee SecurityLevel Stores
100 John Smith 100 ,S1,S3,S12,
This is what I want the result to be
ID Employee SecurityLevel Stores
100 John Smith 100 1
100 John Smith 100 3
100 John Smith 100 12
Essentially I want to Parse 1 record into 3 individual based on the Stores column
I am using SyBase SQL Anywhere 10 and VS 2015 C#
This is what I have
ID Employee SecurityLevel Stores
100 John Smith 100 ,S1,S3,S12,
This is what I want the result to be
ID Employee SecurityLevel Stores
100 John Smith 100 1
100 John Smith 100 3
100 John Smith 100 12
Essentially I want to Parse 1 record into 3 individual based on the Stores column
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER