cool

good job.

i am happy with the reply

Are you sure ? I am confused on the following

DELETE

FROM DEDUPE

WHERE RID > 1;

Should it be --->

DELETE

FROM AbC

WHERE ???

Forgot to tell u but there can be many patients. So I had t modify as follows:

cross apply (select top 1 case_num from #cases c where convert(char(8),c.case_date,112) <= convert(char(8),r.exam_date,112) ...

Cool!

I like it that worked!

Great JOB!

Lets close the case. It is is 5PM time to set home.

Lets close the case folks!

TO begin with there were duplicate entries in one of the tables.

THE SQL syntax was fine!

Sorry for your time.

CREATE TYPE BP_Data_ACRC_427_B

as table

(

AIMS_VALUE_NUMERIC numeric(19,2),

bp_type VARCHAR(4),

Dt datetime ,

ID int IDENTITY(1,1),

MBP numeric(19,2),

MPOG_PHYSIOLOGIC_CONCEPT_ID VARCHAR(10)

UNIQUE CLUSTERED (MPOG_PHYSIOLOGIC_CONCEPT_ID,Dt)

)

IT works in SQL Sevrer 2012

Just pick any 2 columns you wish. I am only interested in the syntax.

I don't want a primary key, I need an index to make things faster

Folks,

This is resolved. No further assistance needed.

Thanks

Also it has an index on the column case_id

901

Thank you

THat worked!

GOOD JOB

🙂

Thanks

You were close..

It should be REPLACE( EGFR_value, CHAR(39) , '''''' )

A total of 6 quote are in the expression

Works fine except for one little thing,

The first item will not start with the "["

That's about all. No big deal.

Thanks

It worked...

You deserve a beer!

This works, but I need to add one more item to the inner where clause. As soon as I do that I get that above error

SELECT

preop.MPOG_Case_ID,

...