I'll give it a try... did an initial search for "stored procedure" + db2, and came up empty.... so I searched for just "DB2"... also empty. =(

Maybe IBM doesn't like...

• This reply was modified 4 years, 11 months ago by pietlinden.
• This reply was modified 4 years, 11 months ago by pietlinden.

What if you just create a new query (like CTRL-N) and then CTRL-Shift-Q to design in query designer... then just join the tables that way?

You don't mean that all 13...

Read up on windowing functions. This:

,rsPaid = SUM(Paid) OVER (ORDER BY FixedDateROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

does a running sum.

like this? Really I should learn how to convert normal dates to silly US date format (or vice versa), but anyway... this should work... (create running totals for Invoiced and...

• This reply was modified 4 years, 12 months ago by pietlinden.

The link David Edwards provided works. Now to import and play.

Thanks!

Not sure... something like this?

SELECT YEAR(t.Date) AS yr
, MONTH(t.Date) AS mo
, d.Site
, d.Dept
, d.Cat
, SUM(d.Num) AS Total
FROM #date_dim t 
LEFT JOIN #Data d
ON t.Date = d.Date
GROUP BY...

Please explain why you are shrinking your database.  About the only time you need to shrink your database is when something happens in it to cause file size bloat that...

The error "Operand type clash: text is incompatible with datetime2" sounds like the date columns in Oracle are being interpreted as text, so you might have to use an expression...

For a minute there, I thought I worked for the boss Thomas describes in scenario #1.  My boss used to tell me "Document, document, document!" And he was the only...

Most folks here won't touch an Excel file. Make life easy on everyone and post the setup script for your question... something like this:

use tempdb;
go

CREATE TABLE SalesTable...

Did someone restore a bunch of databases recently? Sounds like someone replaced the reports database with an old version, because it would cause your SSRS instance to suddenly look like...

Why do you feel you need views of all the tables? Are you trying to return a fixed subset of the rows in the table? If it's for reporting, then...

You have to split the values first, so you have a normalized structure so you can do the aggregation.  I used Jeff Moden's DelimitedSplit8K function

SELECT Lang2,...

Looking at the 4394 records which have some value for SupplierID in PharmInventoryIn I've seen up to 5 trades back and forth between us and different distributors. And that's not...

NTILE(n) will divide the set into n nearly evenly sized chunks. Not sure how you would force full groups into a single "chunk" though