471,082 Members | 765 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,082 software developers and data experts.

MSSQL query

I have a table with the fields name : item, description, invdate, qntyinvoiced
I need to retrieve records like as i mean in a single line:

for each item :
jan feb mar apr....
year 2006 100 250 300 500 qnty
2007 300 900 100 390 .......
How can i get it using select, i need it for reporting..

If anybody can help me please.
Apr 26 '07 #1
0 853

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Lars Nielsen | last post: by
14 posts views Thread by Andre | last post: by
14 posts views Thread by Kukurydz | last post: by
4 posts views Thread by kenneth.osenbroch | last post: by
14 posts views Thread by guswebb | last post: by
reply views Thread by exclaim | last post: by
reply views Thread by Gosth in the shell | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.