Would something along the following lines do the job?

Side note: the basic concept is to use a calendar based on month and cross join the users table to that calendar....

I think all that's needed so far are 14 sample rows (one for each transactionCode value). If there are more than those 14 values mentioned so far you should include...

What I'd basically do is to move the decision whether to use securityID1 or securityID2 into a CASE statement instead of a UNION to avoid running a table scan/seek more...

Would that be an easy baseline?

SELECT

Acct_ID,

SUM( CASE WHEN Category IN ( 'a', 'bdq', 'rr') THEN Value1

...

Try to write a query to select all rows from PeoplesCalender that should be deleted (use an inner join on PersonID and a WHERE clause to limit PeoplesCalender.date>Leavers.DateLeft).

Once you verified...

Maybe a stupid question:

Would it help to detach the other DB's (assuming that option is available) and move the related mdf and ldf files to a different drive/server to free...

... and here's the version to include the total amount right after the last month, based on the sample posted before.

;

WITH cte AS

(

SELECT

ID,

N+1 AS Pos,

STUFF(CONVERT(CHAR(11),DATEADD(mm,N,start_date),0),4,6,'''') AS col1,

total_amt/total_month...

Jeff Moden (9/15/2010)

---

I absolutely agree with what you say but consider the following... what if there is no "front end" for this task?? 😉 Remember... to a nail,...

The requested output is not really something you should expect from a SQL statement:

a) It seems like you want to have "flexible column names" for each row which is totally...

Craig Farrell (9/15/2010)

---

CirquedeSQLeil (9/15/2010)

---

Steve Jones - Editor (9/15/2010)

---

Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he...

Gianluca Sartori (9/15/2010)

---

I had to stop it after 2...

I think the best I can recommend at this point is to get someone in to help those 3rd party folks improving their software asap. If there is such a...

Based...

You should still get the inserted message when successful.

The square bracket issue is weird. Possible any "non-standard" column names? (e.g. including space, comma or any other fancy stuff?)

Brandie Tarvin (9/14/2010)

---

Oh, I'm going to have to look into both of those. Glad I read this post.

EDIT: Do either of these have some sort of alarm or notification broadcast...