;with testcte (ID, PatientID, Drug, DatePrescribed, rnum)

as

(

select *,

row_number () over(partition by convert(varchar,DatePrescribed,101) order by DatePrescribed) as rnum

from #Prescriptions

)

select f.*,

case when coalesce(s.rnum, t.rnum) is not null then 'PossibleDrugSeeker' else...

bnordberg (5/21/2010)

---

I do similiar stuff all the time - I look at prescription drug history and lab values and look for changes that would indicate adverse drug events, drug seeking...

Something else to do...

marin-231997 (5/21/2010)

---

Hello bnordberg,

well, I'd really like to see how your queries look like after you've had your cup of coffee 🙂 , but this one just hits the nail on...

Yep, if...

marin-231997 (5/21/2010)

---

Hello Chris,

thanks for your input.

Unfortunately it is not what I'd like to achieve. I need a way to "flag" the rows having identical values in column _VAL3 (kind of...

marin-231997 (5/21/2010)

---

Hello all,

I wonder if following is somehow possible:

I'd like to add an extra column to my existing query which would indicate the rows with identical values in certain column.

Sample...

Have you looked into Jeff's suggestion yet?

NULLIF(MyDodgyColumn, '')

Robb, can you please confirm that you are running on SQL Server 7 or 2k?

And if it is correct, then this should do the trick:

SELECT

p.packageID,

p.ClientID,

p.StartDate,

p.EndDate,

DATEPART(MONTH, GETDATE()) AS currMonth

FROM p

WHERE

(p.StartDate <= CONVERT(datetime, CONVERT(varchar,DATEPART(year,GETDATE()) +

CASE WHEN DATEPART(MONTH, GETDATE()) >...

Oh don't worry about that, getting the conditional to work properly is the easy bit. Getting the logic engraved in stone first is essential - and the hard bit. Now,...

karthikeyan-444867 (5/20/2010)

---

Step1 : User will pass delimited values.

Step2 : I used 'Tally' table to split the delimited values

Step3 : Splittled values will be stored in a table as rows.

...

What have you tried so far?

Hi David

Could you please review the attached pseudocode and confirm that it's logically what you're looking for?

DECLARE @NextMarch DATETIME, @ThisMarch DATETIME, @ThisApril DATETIME, @LastApril DATETIME

SET @NextMarch = convert(datetime, convert(varchar,datepart(year,getdate())+1) +...

I reckon we should all club together and buy John a telly.