Thanks that was it.....

Thanks... That seems to work except I get a conversion error.

TOTAL_AMOUNTdecimal(15, 2)

Conversion failed when converting the varchar value '$2847.00' to data type int.

How would I get the results as MONEY? I've tried.

then '$' + CONVERT(money, total_amount)

But the $ does not show up for some reason.

current results 10495.00

Need $10,495.00

Any ideas on how...

Awesome... Thank you very much... More arsenal for growing bag of SQL knowledge.

lol.. Yup there is a quantity... Duhhh sorry..

Wow! Much cleaner.

I just added this to my new SQL utility belt.

Thanks...

Thanks for the reply.

I Thought if I changed SUM to COUNT I would get the number of items(counts) for each month instead of the totals. but It just gave...

How would I change this from SUM to COUNT? I changed it but it gives me total count on every month.

Works good with SUM:

62 IN X 8 LProfile Dump 5K...

Any luck with the query? I read the page of the link you sent. Not sure how to implement this in my project.

SUCKS being a noooob at SQL. But...

Awesome! thanks.. Going to read the article tonight.

sorry. yes TOTAL_AMOUNT from the TABLE RECEIVABLE.

I was using the stored procedure below but I cannot use pivot tables because our ERP system requires 2000 compatibility (80).

@CustomerID ...

The results I'm looking for are the totals for each month of each year.

Jan Feb ...

Please forgive my newbee SQL status.. :w00t:

I have the following database structure and data:

CREATE TABLE CUSTOMER_ORDER

(

ROWID INT ,

ID varchar(15) ,

CUSTOMER_ID varchar(15),

STATUS char(1),

USER_1 varchar(80),

USER_2 varchar(80)

)

CREATE TABLE DEMAND_SUPPLY_LINK

(

ROWID INT ,

SUPPLY_BASE_ID varchar(30),

DEMAND_BASE_ID varchar(30)

)

CREATE...

Thank you very much.. That's exactly what i was looking for.