How about doing the UPDATE on matched data, then doing an INSERT. Just do the whole table at once. (So it would have to be imported into a table...

Sounds like an UPSERT...

No, all you need are ProductKey, and maybe an alternate key.

The rest of the columns in a Dimension table are just for grouping when you do your analysis.

Just googling around found this discussion on StackOverflow showing how to do what you are asking in PowerShell.

DelimitedSplit8K maybe? Read the article, which is here[/url].

Welcome to SSC,

Since we're not at your computer, you'll have to meet us halfway and provide CREATE TABLE and INSERT scripts to populate them. Please read this article "Forum...

SSC is becoming SPAMalot??? Hmm... Anybody have coconuts (or am I mixing up Camelot and Holy Grail?)

It's one of those "features" they don't tell you about... Maybe check out Jessica Moss's articles on SSRS to see if there's anything there that's helpful.

one way is to not use the totals query as the base for your report and to use a Matrix instead of a tablix. You could create a variable to...

Did you check the "Allow Multiple values" in the Parameter properties? If not, it will default to single-select instead of Multi-select. (And then you under FILTERS, have to change [Field]=...

Right here...

) T1

WHERE <filters>

GROUP BY

It goes after the FROM clause and before the GROUP BY clause

Okay... Could you post what the solution looks like given the data you originally posted? (Or did you do that already?)

So you would apply the new payment to the oldest...

Awesome... now I know what the question is! <g>

You're doing FIFO (a queue), but with money. So the oldest debt gets paid first, and if there's any money...

I think I get it... you want to apply amounts to the oldest debt first, and then carry forward any remaining money and apply it to the next oldest debt....

Oh wait... I think I get it. You're kind of looking for patterns in when each debt gets paid off... so older debts (which are theoretically accruing interest) are...