What if you use the crosstab in a CTE, then do a final sum(case...) in the select statement. Here's a start without all of the logic, but I think...

Look at this article http://www.sqlteam.com/article/using-cross-apply-in-sql-server-2005

Let me know if this helps 🙂

Thanks,

Jared

Well... I think the best way may be to create a table based function that looks at the raw data and use CROSS APPLY to bring your counts.

Thanks,

Jared

Try this for now. I would leave the data in a raw form, and then group on things in the report itself if you are making a SSRS report....

Here's where I am at... I will keep going as I love this kind of stuff! 🙂

SELECT InvoiceNumber, YEAR(InvoiceDate) AS InvoiceYear, MONTH(InvoiceDate) AS InvoiceMonth, InvoiceDate, PaidDate,

DATEADD(D,45, InvoiceDate) Date45Days, IsPaid,

CASE IsPaid...

Can you please give me a sample of what you want your aging report to look like? In terms of relevant data points for your purpose.

EDIT: Also, are you just...

I created invoices for my last company where we were a net 30 and some people had paid a %age POS, some had balances at 30, 60, 90, and 120+...

However, the "simplest" way with your current SP is to put the 2 sets into temp tables, then insert the data from the 2 temp tables into your 2 physical...

It would help if we could see the stored procedure.

Thanks,

Jared

Restore without "Preserve the Replication Settings" being checked and you should be fine.

Thanks,

Jared

Try making your 100 100.0

EDIT: You are working with integers, meaning the result will be an integer. If you make one of the numbers a decimal, it will implicitly convert...

Paul Bradshaw (10/4/2011)

---

I don't know if this will help, but this is the script I coded to shrink stubborn log files... this can recover a lot of space:

DECLARE @file sysname

SELECT...

Just a thought... You mentioned taking it offline and detaching, etc. Do you have the opportunity to restart SQL Server? Not sure if it will help, but I have seen...

GilaMonster (10/5/2011)

---

For anyone who wants a deep (and I do mean Deep) dive into Windows memory internals from one of the Windows Kernel team, see these videos.

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/WCL405

http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/WCL406

They probably need watching...

Sqlchicken (10/5/2011)

---

jared-709193 (10/5/2011)

---

mendesm (10/5/2011)

---

I still have not found convincing arguments as to why anyone would run a sql server in a way that swap/page file use would be of any...