Yes, PL.ChartNo is numeric...

LocationId+'-'+Chart_no will comes as 1-1 not ASD-12

Also,

how can I update as a Select and dropping the where clause adding in (L.locationID+'-'+P.Faccount+'-'+P.Fpatient) and (PL.LocationID+'-'+PL.Chart_No) as...

Jason,

I replace line with your lines as :

inner join PatientLocDtl PL ON PL.PatientID = PP.PatientID

AND L.LocationId=PL.LocationId

Where

(P.Faccount+'-'+P.Fpatient)=PL.Chart_No

But I am getting error as I was getting before-

Msg 245, Level 16, State 1,...

Arthur,

where(L.locationID+'-'+P.Faccount+'-'+P.Fpatient)=(PL.LocationID+'-'+PL.Chart_No)

is not working.

ohhhh I am clear with that now... 😛

Thanks Bri,

can u plz explain why you put -1 in query?

nice discussion 🙂

I think main conceron of slyvain was about to tell about the error :

"The maximum limit for index or statistics key column list is 16"

Nice Question in the start of the week 🙂

Thanks Koen and Lokesh 🙂

One question, I am confused on this...

select ID, name name from person

select ID ID, name name from person

Both these statements dont give any error message and run successfully...

wht is it...

god start with a coffee +2 🙂

how can we restricted a view to a particular user only?

thanks Lowell...

intresting thing to know

Execute this code and you will get duplicate values in Identity values--

CREATE TABLE IdentTest

( Ident INT NOT NULL IDENTITY (1,1)

, varfield varchar(100)

)

INSERT INTO IdentTest VALUES ('xyz') -- <==...

Hi lokesh,

as you TRUNCATE the table then identity will be reset to 1 and now the ident value after a insert statement will be 1..