469,591 Members | 1,793 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,591 developers. It's quick & easy.

need help with producing data on one live

trying to make a script to view data in a excell spreadsheet.

I can get all the data I need except one.

select ordernumber, itemcode, quantity, rate, total

from dbo.charges

where ordernumber = '45676'
the problem is there are more than one itemcode

example: run results

ordernumber, itemcode, quantity, rate, total
45676 fuel 123 .10 12.30
45676 stops 3 50 150

how do I get this data on one line?

to look more like this: run results

ordernumber, itemcode, quantity, rate, total itemcode, quantity, rate, total
45676 fuel 123 .10 12.30 stops 3 50 150
now just one ordernumber appears and its all on one line.
hope you can help, thanks for your time...
Mike
Jul 20 '05 #1
1 1268
Hi

Check out the previous post: http://tinyurl.com/n8ps

John

"Mike Rogers" <mb******@comcast.net> wrote in message
news:5c**************************@posting.google.c om...
trying to make a script to view data in a excell spreadsheet.

I can get all the data I need except one.

select ordernumber, itemcode, quantity, rate, total

from dbo.charges

where ordernumber = '45676'
the problem is there are more than one itemcode

example: run results

ordernumber, itemcode, quantity, rate, total
45676 fuel 123 .10 12.30
45676 stops 3 50 150

how do I get this data on one line?

to look more like this: run results

ordernumber, itemcode, quantity, rate, total itemcode, quantity, rate, total 45676 fuel 123 .10 12.30 stops 3 50 150

now just one ordernumber appears and its all on one line.
hope you can help, thanks for your time...
Mike

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by robinsand | last post: by
2 posts views Thread by Trevor Hennion | last post: by
1 post views Thread by pwong | last post: by
5 posts views Thread by alck1234 | last post: by
6 posts views Thread by smk17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.