One option for your first question is this:

select person_id, MAX(appt_date)

from appointments

where person_id is not null

and appt_date > GETDATE()

group by person_id

order by person_id, appt_date desc

By grouping only...

If you just want to explore the cube yourself you can connect to Analysis Services via SQL Server Management Studio (SSMS) and Browse the cube. Otherwise Excel is very...

You should be able to add an OR to account for the NULL in the stored proc parameter

WHERE ((c.status IN ('PAID','PAY') OR @ClaimStatus IS NULL)

I worked for Cizer several years ago and the Quick Query tool was designed to do what the poster was asking. There's nothing in it for me, I was...

Here's an option that may work, it's a little weird, but give it a try:

The basic premise is take your original query that selects your three columns and add a...

Here is a possibility:

Select the first series in the chart (report count), right click and go to 'Series Properties'

Select the 'Fill' tab

Select the Expression Editor button under 'Fill Color'

Paste the...

There is another reporting tool I had worked with in the past called Cizer .Net Reporting that sounds like it would meet your needs as well. It also has...

I think you are on the right track. The most direct way to extract data from a flat file into SQL Server 2005 using SSIS is to add a...

It might be easier and more straight forward to use the URL Access Parameters. You can then just call the report you want from any web part that you...