This can be done using a cursor, but cursors are generally avoided because of performance, resources, etc.  Below is a script that will work with your data sets.  Instead of...

Do a search on this site for Pivot Table.  Each listed applies to your question but are written to accept input that include three columns of data not 2.

Browse through the...

Since DTS may or may not be something you are familiar with (couldn't tell in your posting) I'll give an ugly crash course.

Use DTS (Data Transformation...

To add some samples that you can choose from.

This is a user defined function that I use to return a table of parameters passed in a parameter string.  Lets say...

this may be what you are looking for:

Copied from BOL:

June 7, 2006 at 1:02 pm #642375 RE: Exporting to CSV with Leading Zeros My two cents...  The easiest way to solve this is to set your destination connection's data source to "Microsoft Excel 97-2000". (if you used the wizard to create your DTS... June 7, 2006 at 12:43 pm #642371 RE: Error while running BULK INSERT I don't know if you are having the exact error described in this link (http://support.microsoft.com/?kbid=825197) but take a look.  It states the obvious, install... June 7, 2006 at 12:06 pm #642364 Viewing 7 posts - 121 through 127 (of 127 total)