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:

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

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

See later post.

"Mike Rogers" <mbrogers@comcast.net> wrote in message
news:5c7daa60.0309101854.70c590e9@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:
>
> 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
>
> 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