Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to retrive data  inrow/column view

Posted on 2009-05-07
4
Medium Priority
?
179 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:robert_a_jenkin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 24326488
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
 

Author Comment

by:robert_a_jenkin
ID: 24326524
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
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 24329733
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
 

Author Closing Comment

by:robert_a_jenkin
ID: 31579022
I went with a stored procedure approach
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

715 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