Here is the output:

start of month w/ no transactions:

Fund | Daily Sales | Monthly Sales

--

start of month w/ 1 transaction

Fund | Daily Sales | Monthly Sales

Fund1 0.00 54840.00

Desired output would...

My query returns nothing at the start of the month:

Fund | Daily Sales | Monthly Sales

I think what I'm after is a row based sort solution, where I'm sorting on by the total row.

Hi Flo, good point and that's exactly where I want to go w/ this query is to Reporting Services report.

I guess how in MS Reporting Services do I order the...

Hello Flo, I'm not sure if I understand. I put the order by in

ORDER BY sort, Central, Northeast, Middlewest, Northwest, Southeast, Southwest

and still the same order of...

Hi Florian, thanks for the response. So now that I have the total, how to I order the columns according to highest total first, etc. for example

...

Hello GS, I'm not sure how to join two select. Can you provide an example.

thanks

here are the table defs and sample data:

---------

CREATE TABLE [dbo].[tblfunds](

[numeric](18, 0) NULL,

[description] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[isOpen] [int] NULL

) ON [PRIMARY]

INSERT INTO tblfunds

...