You can go to the FILTERS section in SSRS and add additional filters for your report. (And add parameters etc). So the "raw" dataset could pull say 100 records, and...

This is a bit of an odd question. Normally, if you have a date dimension table, you're working in a data warehouse, which means you're usually using either DAX or...

Balance is basically a running total of deposits minus a running total of withdrawals. (Well, maybe starting with a monthly balance, because recalculating that all the time from the first...

SELECT code, description, code + ' ' + description AS RandomColumn
FROM MyDB1.dbo.Table1
UNION
SELECT code, description, code + ' ' + description AS RandomColumn
FROM MyDB2.dbo.Table3
UNION
SELECT code, description, code +...

• This reply was modified 3 years, 2 months ago by pietlinden.

looks okay if you're talking about the basic design. What did you intend to do with it?

Why not a separate table for each?

use REPLACE()

that's what I realized a little bit ago.

I need all the patient ids returned but no duplicates, only the record that has the highest ProcedureCodeId.

SELECT PatientID, MAX(ProcedureCodeID) AS MaxCodeID

FROM t

GROUP BY PatientID

If you need other columns too,...

Use CROSS APPLY to return the first record

SELECT p.PatientID...

ca.ProcedureCodeID

FROM Patient p

CROSS APPLY (SELECT TOP 1 ProcedureCodeID

FROM SomeTable t

WHERE t.PatientID = p.PatientID

ORDER BY <some column>) ca

Okay, since you don't want to provide data, we can't help you.

Case closed.

Good luck!

What's the [EndDate] that matches with [Created Date] so we know how long a duration is?

If you want useful help, please read and follow the instructions in this article:

Can't you just use OR in your WHERE clause and then do the aggregation? I'm not convinced you need a CTE at all.

Maybe start here - Cathrine Wilhelmsen's tutorial

#GotData?

Without a table with some data, it's hard to help.