Thanks Nigel for confirming this.

Actually, when I posted my question I didn't have access to SSRS so I thought I'd just post the question.

Now that I'm back in the office,...

Jeff:

Great article. I'm looking forward to your next article that includes the solutions to avoiding triangular joins and RBAR!

--Pete

About the only thing that goes right when it comes to time is when I heat something in the microwave: 2.41 minutes and the popcorn is ready. i know it,...

A.J.:

Thanks for your willingness to help. Unfortunately, our linked server to Sybase is configured as described in the microsoft forum link you provided; works most of the time, but not...

The "Select Top 0... into #Results From..." merely builds a table structure without data -- a lazy way, but effective, to build a table without using a formal Create Table...

OK -- here's the code i used to test my proposed solution of using a user-defined function to concantenate the cpt codes:

-- CREATE A TABLE TO...

Frances -- what kind of hardware is your sql server on? Pentium II?

I just populated a test table with 190,000 records of sample cptcode data, and then ran the query...

Frances:

Leveraging the power of a user-defined function can really help in this situation. Below is what I wrote to derive a solution that should work for you.

--Pete

-- CREATE A TABLE...

We're in the same boat. Gotta make SQL2005 talk to Sybase -- arrgh!

Hi:

If you need info on MDX for analysis services, I highly recommend MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase (by George Spofford et al.)

Spofford...

Hi -- Although you mention you have Windows NT, it's not clear to me if your client machine that has Analysis Services manager installed is running the same OS.

In my...

Hi Julie:

You won't like my answer, but Microsoft says it can't be done with native pivottables. Here's a link to their article (KB231052).

Here are a couple of suggestions:

1) Create...

Hi David:

I've been studying your "where" clause and I thought I'd add a comment or two for you just in case you hadn't noticed these things:

First, I like how you've grouped...

Hi Steve:

Have you had any experience yet using these two new products?

I downloaded the Excel addin this morning and am beginning to test it.

If you or someone you know has...

Say Rockmoose, tell me about ProClarity. Good, bad? I know this inquiry is outside the realm of my initial post, but I'm also in charge of investing useable OLAP reporting...