You can't test your SQL properly, because your table doesn't contain the right records. I added a new record to the table so that both CID and MID are both...

Proper punctuation is a beautiful thing. Why no semi-colons at the end of your statements?

This worked for me:

--Create Test Table

CREATE TABLE [dbo].[Null_Table](

[CID] [int] NULL,

[MID] [int] NULL

) ON [PRIMARY];

GO ...

I have both editions of that book. That was the first really good book I found on DAX.

Somewhere here I have F&R's book, which is a bit mind-blowing, but they're...

You mean destroy the RBAR side, the side that's good at writing cursors and such?

Martin,

That's what I was afraid of... My brain might explode.

you know you're in for a rough ride when Ferrari & Russo freely admit that "DAX is hard"... uh oh.

I think that will work... Gotta re-read that part of the book. A few times. and then try it, and then read a few more times. And then maybe read...

If the reason for your loop is to implement a running total, why not just use a Window function and do something like

SUM( <column to be summed> ) OVER...

Since your UDF returns a table, you could probably use CROSS APPLY to pass values from the other table (the source for the two parameters) and then return the whole...

Oh okay. Thanks for the clarification. I guess I should learn a little MDX eventually... just so much to cover and so little time! (and not enough brain cells to...

Oh, so from a user's perspective, it's effectively the same... thanks!

Why not use a For Each file loop and then use an Excel connector and insert that way?

You probably need some serious normalization of the data you're importing. 255 columns...

Okay, let me approach this from a different angle, and maybe I can think this out.

The sale would always be associated with a given customer and the salesperson at the...

You could use something like this.. I would recommend commenting out the EXEC statement and just printing the SQL to make sure the SQL statement is correct.

USE [mydatabase]; ...

You're not specifying a way of telling which records are already in the destination table. Without that, you're going to insert the same records over and over.maybe you could use...

For Each [file] Loop?