T-SQL: Split numbers into a table

1142555 pts.
Tags:
SQL Server
T-SQL
For T-SQL, I have to split 1,2,3,4,5,6,7,8,9,10 9 into a table (also comma delimited). How can I do that? Is there some sort of function that I can return each one in a row? Thank you so much.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    The Split strings the right way – or the next best way page shows a few of the good methods of doing this. It compares the methods for performance and includes a couple variations on environment. Depending on what you have available, one or another method might work best for you.

    If you have a problem making a method work that seems best, post back with your actual test code and a description of the problem.
    35,060 pointsBadges:
    report
  • ToddN2000
    Give it a try. It's the best way to learn. If you read Raven's link you should be all set. If not post back and we can help clear up any issues may still have.
    132,660 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: