Ah, MDX. Well, I'm a novice with MDX at best. I would recommend creating a new thread in the Analysis Services forum. Make sure you have MDX...

No problem, glad to help.

Brandie Tarvin (3/29/2010)

---

Really? Funny how small the world is....

be

Ah, yes. I should have mentioned it! I assign default values any time I am working with dynamic expressions so I don't have to set everything to delayed...

In addition to agreeing with the others, I thought that I'd offer some suggestions for your SSIS design since you've stated that you have never used it before.

I would recommend...

Do you have a specific question? How is your loop not meeting your needs? Are you getting errors?

No, I listed out the accounts so that I...

Keep in mind that with SQL Server 2005/2008 table partitioning, you do not need to define views to limit your partitions. The partitioning functions/schemes do that for you as...

meena.patel (3/25/2010)

---

But what happens when a new account is added, then I have go and tweak the formula, too much work. Is there a way the system can look at...

The alias declaration must come after the END....

....END AS CaseType

Something like this should work:

DECLARE @Table TABLE (GLnum int)

INSERT INTO @Table

SELECT 50420 UNION ALL

SELECT 55030 UNION ALL

SELECT 56640 UNION ALL

SELECT 51010 UNION ALL

SELECT 53010 UNION ALL

SELECT 54410

SELECT *

FROM @Table

WHERE...

.....doesn't happen often 🙂

By the way, if you have a tally or numbers table, you could easily replace the derived table (t2) with the tally/numbers table and use WHERE N BETWEEN 1 AND...

Try this out:

DECLARE @Table TABLE (ID int IDENTITY(1,1) PRIMARY KEY, Q1 int, Q2 int, Q3 int)

INSERT INTO @Table(Q1, Q2, Q3)

SELECT 1, 5, 2 UNION ALL

SELECT 4, 1, 3 UNION ALL

SELECT...