Solved

SQL Syntax Parsing one record into multiple

Posted on 2016-07-15
2
31 Views
Last Modified: 2016-07-15
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
0
Comment
Question by:triphen
2 Comments
 
LVL 6

Accepted Solution

by:
bcnagel earned 500 total points
ID: 41713628
It looks like you have access to the sa_split_list() system procedure in SQL Anywhere 10:
http://dcx.sybase.com/index.html#1001/en/dbrfen10/rf-sa-set-http-option.html

With this one, you can do something like:
0
 

Author Comment

by:triphen
ID: 41713631
Thank you. I actually found another table in the database that already has it split that I was unaware of. Thank you!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now