"Mike Rogers" <mbrogers@comcast.net> wrote in message
news:5c7daa60.0309120834.669e9fd9@posting.google.com...
> 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