need help with producing data on one live

[Mike Rogers]

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

[John Bell]

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