i find i like...

i count 3 distinct queries with changes on the where clauses and SSRS to make it all nice and pretty.

one for the partner level (changing the date range for...

roryp 96873 (4/2/2012)

---

capn.hector (4/2/2012)

---

roryp 96873 (4/2/2012)

---

capn.hector (4/2/2012)

---

roryp 96873 (4/2/2012)

---

Something like this?

declare @myDate date

set @myDate = '2012-04-02'

select @myDate as myDate

Obviously this is really simple, but you can use the @myDate in...

roryp 96873 (4/2/2012)

---

capn.hector (4/2/2012)

---

roryp 96873 (4/2/2012)

---

Something like this?

declare @myDate date

set @myDate = '2012-04-02'

select @myDate as myDate

Obviously this is really simple, but you can use the @myDate in calculations or comparisions...

using common table expressions you can get the aggergated data but with out the DDL and sample data code is hard to do. there are also cross tabs that...

roryp 96873 (4/2/2012)

---

Something like this?

declare @myDate date

set @myDate = '2012-04-02'

select @myDate as myDate

Obviously this is really simple, but you can use the @myDate in calculations or comparisions like you would...

aaron.reese (4/2/2012)

---

yes, that is probably a better syntax (personally I think it is a little harder to read) but it will work for multi-part primary keys whereas the IN (SELECT...)...

SQLRNNR (4/2/2012)

---

jcrawf02 (4/2/2012)

---

Brandie Tarvin (3/29/2012)

---

Greg Edwards-268690 (3/29/2012)

---

Brandie Tarvin (3/29/2012)

---

Just spent time in a meeting being reminded that people using the same terms do not always mean the same thing. Interesting...

Sean Lange (4/2/2012)

---

Koen Verbeeck (4/2/2012)

---

Hi-la-rious!

I do admire your patience.

I would probably already stopped looking at that thread after 3 or...

i agree. of course this could also be inside of a cursor all ready (Similar...

SQLKnowItAll (4/2/2012)

---

capn.hector (4/2/2012)

---

i was wrong, here it is with the join and only pulling authid's in the trans table

;WITH row AS (SELECT ROW_NUMBER() OVER (Partition by auth_id ORDER BY key_id)...

i was wrong, here it is with the join and only pulling authid's in the trans table

;WITH row AS (SELECT ROW_NUMBER() OVER (Partition by auth_id ORDER BY key_id) AS rownum,...

;WITH row AS (SELECT ROW_NUMBER() OVER (Partition by auth_id ORDER BY key_id) AS rownum, cpt4_id, auth_id FROM #outpatient_service)

SELECT UPPER(cpt4_id), auth_id FROM row where rownum = 1

GO

no inner join to the...

i find scripting the database out is better for me than using any tool to do it for me from visio (or the such) from an ERD. the first...

question where in the query is the...