How to retrive data inrow/column view

My question is this

I have a database table that contains 1m's of rows. Each row has a product, queue and column value. I need to obtain data from this in a spreadsheet type of view order by product

               column   column  column
queue
queue
queue

What is the best way to obtain this data in a format simular to the above
robert_a_jenkinAsked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
for CR :
you can
 or
get Tables : and in place and run select statement\design report from the table fields, etc
or
 as you said
the better solution (if it is good for your report requirements)
Stored procedure..
0
 
Eugene ZCommented:
use Export\import utility
from SSMS->right click your  DB-> tasks-> Export data->.... select Write query to specify the data to transfer...

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm


or use bcp

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/31a15a51-f557-499c-96a9-df7faccde98d
0
 
robert_a_jenkinAuthor Commented:
My question was not clear I am looking to have this data returned to crystal reports for a report reflecting the data in a grid design.

I am guessing that the crystal report would have to call a stored procedure that would return the results to the report like so

product, queue, column 1, column 2, column 3.... column 8
0
 
robert_a_jenkinAuthor Commented:
I went with a stored procedure approach
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.