Okay... let's rethink this in terms of SQL functionality. You are wanting to do month/year comparisons ignoring the date and time. There is no need...

You're very welcome, Dizzy.

Here you go. Cast/Convert the float data to dataype money

then the outer CONVERT will insert the commas for you.

declare @test-2 float

set @test-2 = 7265342.12

select @test-2, convert(varchar(20),cast(@test as...

I wouldn't worry about PIVOT. A little "crosstab" application will handle this and run very quickly for you. Please let me know if you have any questions.

select...

Absolutely. I've read pretty much all of his stuff, from Zodiac to Anathem.

That's fascinating, Steve. 🙂 The closing reference to Internet services makes me wonder if any of them read Neal Stevenson's Cryptonomicron.

You're a cruel man, Jeff. I'm also on pins and needles. Is he going to post it in the tally thread, or do we have...

Yeah, but I want all the business for myself 😉

You're very welcome.

Besides the link to the article Jeff Moden wrote, there is another article out there by Lynn Pettis which concerns running totals over partitioned tables....

This just looks like a variation of a running totals problem.

Take a look at this; I believe it can be adapted to your purposes.

If running total equals...

I see where you're headed. One thing you should be aware of is that SQL does not dynamically create pivot tables for X number of values like Excel....

Can I declare my independence and be a country?

If the code is going to have to run under SQL 2000, then FOR XML isn't an option. At least you have a solution which is satisfactory for...

The while loop (for only 10-20 tables on average) serves to serialize the processing. In our case, the processing is identical, which is why we used a loop...

There must be a typo somewhere. That query is valid for 2005. Could you cut and paste your code back here, along with the error?

Putting the comma...