move is null

[Guest]

hey all,
i have a query that i bind to my dataset/datagrid that uses the WITH ROLLUP
keyword, so the totals show up at the top of the table. does someone know of
a clever way to move that 1st row to the bottom of the grid?

thanks,
rodchar

 

[Jacek Stawicki]

hey all,
i have a query that i bind to my dataset/datagrid that uses the WITH
ROLLUP
keyword, so the totals show up at the top of the table. does someone know
of
a clever way to move that 1st row to the bottom of the grid?

Try to sort the query:

SELECT ProductID, SUM(UnitPrice) AS UnitPrice
FROM Sales.SalesOrderDetail
GROUP BY ProductID WITH ROLLUP
ORDER BY ProductID

 

[Guest]

thank you.

Try to sort the query:

SELECT ProductID, SUM(UnitPrice) AS UnitPrice
FROM Sales.SalesOrderDetail
GROUP BY ProductID WITH ROLLUP
ORDER BY ProductID