Viewing 15 posts - 571 through 585 (of 3,232 total)
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...
March 29, 2010 at 3:06 pm
Brandie Tarvin (3/29/2010)
John Rowan (3/23/2010)
I was born just outside of Rapid City, at Elsworth AFB, but have lived in Omaha most of my life.
Really? Funny how small the world is....
March 29, 2010 at 2:41 pm
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...
March 29, 2010 at 2:10 pm
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...
March 25, 2010 at 4:04 pm
Do you have a specific question? How is your loop not meeting your needs? Are you getting errors?
March 25, 2010 at 3:29 pm
meena.patel (3/25/2010)
John, for your query, I would have to list out all the accounts, correct? Is there a way to avoid that?
No, I listed out the accounts so that I...
March 25, 2010 at 3:02 pm
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...
March 25, 2010 at 3:00 pm
meena.patel (3/25/2010)
March 25, 2010 at 2:56 pm
The alias declaration must come after the END....
....END AS CaseType
March 25, 2010 at 2:53 pm
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...
March 25, 2010 at 2:45 pm
Lynn Pettis (3/25/2010)
Here is the solution using an existing tally table. John just happened to be faster than me this time.
.....doesn't happen often 🙂
March 25, 2010 at 1:55 pm
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...
March 25, 2010 at 1:14 pm
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...
March 25, 2010 at 1:12 pm
Viewing 15 posts - 571 through 585 (of 3,232 total)