Jasona.work,

Thanks very much - I think you found my problem. I am not using the correct install. There is no "ADV" in the name so I think I...

Thanks for the reply, but a few things to note...

When I include Tools am I, or am I not supposed to be seeing Management Studio - because it has never...

Hi Cadavre,

Hey, this looks pretty good! Runs well too! Now I want to start refining it - so before I start screwing up the whole thing, let me...

Lynn / Cadavre,

No problem - if you can look stuff over in a couple days, that is just fine - this is not any emergency issue.

Thanks for the heads up...

Cadavre...

Just sent you a private msg. Pick it up when you can and let me know if there are problems.

Thanks!

Cadavre / Lynn,

Please check your private message - link and info are in there. BAK file is < 50MB, let me know if you have any trouble getting it.

As...

A couple things...

Cadavre, the code produces no errors, but it also produces no results. Or better said, all the counts are NULL. Running the same data through the...

Hi Cadavre,

SUCCESS! Your first block of code works - no errors.

Do I need to try the second block if the first one works? (For now, I wont -...

Lynn,

I read the link below your signature with Jeff's recommendations - thats not going to work. First, we are not talking about 1 table - I would have many....

Lynn's doesnt work either...

Here's the error...

Msg 147, Level 15, State 1, Procedure usp_rpt_AgingProfile_Test, Line 82

An aggregate may not appear in the WHERE clause unless it is in a subquery contained...

Nope, doesnt work...

This is the error I get...

Msg 8120, Level 16, State 1, Procedure usp_rpt_AgingProfile_Test, Line 37

Column 'c.modDate' is invalid in the select list because it is not contained in...

Hi Lynn...

Yes, I already thought about that - switching the "n" to "a.n" - still produces an error, same error.

I have also scanned through for unbalanced parenthesis - but they...

PADL, PADR and PADC are three functions to .NET / XBase developers that are very common and go back a long way.

I cant address the original history in our SQL...

...PS...

The Boss knows that we need a major overhaul on the Main Database - I just have to get him to think beyond just the tables, keys and triggers......

Sorry - back at the desk for a short while...

If you look at the LEFT OUT JOIN, its the DATEADD four lines down from that.

PADL is a custom implementation of...