Like this?

SELECT ct.[NAME]
, SUM(ct.c_Imaging) AS Imaging
, SUM(ct.c_Long_Term) AS Long_Term
, SUM(ct.c_Factory) AS Factory
, SUM(ct.c_Central_Office) AS Central_Office
, SUM(ct.c_Pizza) AS Pizza
FROM
(SELECT ID
, [Name]
, CASE WHEN [Type] = 'Imaging' THEN [Count]...

I think you can grab the creation date of the file if you use a folder object and iterate over the files in PowerQuery. Then you could just remove the...

• This reply was modified 5 years, 2 months ago by pietlinden.

Did you read this yet?

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns – SQLServerCentral

You can insert the results of a stored procedure into a temporary table pretty easily

SELECT *
INTO #TempResult
FROM
(SELECT store, [week], xCount
FROM yt) AS sourceTable
PIVOT 
(
SUM(xCount)
FOR [week] in ([1],[2],[3],[4],[5],[6])
)...

Because order is not guaranteed without using an ORDER BY clause? This is SQL 101!

Wait... something's not right. Your test cases are imcomplete.

Looks like you want to group by PartID, CompanyID... then get a count

Something like

SELECT *
FROM #PartsData pd
WHERE partID IN...

• This reply was modified 5 years, 2 months ago by pietlinden. Reason: retested queries

If you're using full recovery mode, restore up to just before you ran that query?

Show us your attempt. =)

SELECT BusinessKey
       .name
       ,attribute
       ,MIN(ValidFrom)
...

Jeff,

Yes, I did that... Found a bunch of stuff from IBM's website. Not much of it is terribly helpful, though. That's why I was asking here. There's a little on...

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 5 years, 3 months ago by pietlinden.
• This reply was modified 5 years, 3 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 5 years, 3 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...