i also need to get in a newbie question while i am at it

when you use the char(8) that is because the '========' is...

Server: Msg 170, Level 15, State 1, Line 8

Line 8: Incorrect syntax near '.'.

---------------------------\\

SELECT o.Customerid as MyCustomersid,

 CASE GROUPING (od.Orderid)WHEN 0 THEN od.Orderid ELSE 99999 END AS  MyfROG,

  CASE WHEN GROUPING...

I  am curious ,, can you post sample code for your solutions?

Thanks,

Erik....

I see it better now with the vb demo..

thanks,

erik.

Now that i am looking at this again, i do not see an INNER JOIN in the querry.

Question: Does the grouping function take the place of the inner join, (in...

o ok..

i look their and was not fruitful in my search

Whats a BOL?

Thanks for the help!

I am using the roll up function to compute totals and seperate inforamtion .

Example:

In my code i can use the roll up fucntion to return prestructured totals..

On...

The mystery here is that i need to know why some statement blocks are delimited with the ()

Just another mystery

There was not problem on this one after i removed the (    and the    ) where they did not belong

Do it like this.

Here is the one that i am learning...

Thank you very much!

Very helpfull!

Eriik....

I am getting an error when i try to go to that page

I DID DECLARE

I got it..

declare @IDProduct int

set @IDProduct = 77

SELECT  Product.ProductName,

                             Product.ProductID,Product.ProductImage,

                                  Product.ProductDescription, SprocsTable.*

FROM              Product

                        INNER JOIN

                          SprocsTable ON Product.ProductID =...