>Can you
>DECLARE @NumOrders
>
>Select count(order_id)
> into @NumOrders
>From Orders
>Group by order_id
>
>Thanks
>Jim
I am not sure, but is this works (I can't test it right now)
DECLARE @NumOrders as int
Select @NumOrders = count(order_id) From Orders Group by order_id
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.