nice and easy question to grab +2 points 😛

good question...

day of week for qq was just a threat 😛

+2 🙂

I used 0-9 range in script for procedure that dont have alphabets in the last like- 8680,0625 etc...

for code like '0625A', '0635B' i used the A-Z in where clause

good discussion as the explanation is not correct properly...

good basic question for the beginners..

good question....

Hi Jason,

Update

pc

Set

pc.ParentProcedureID=p.procedureid

from

ProcedureMaster pc

JOIN ProcedureMaster p on Left(pc.procedurecode,4)=P.procedurecode

Where

Right(pc.procedurecode,1) like '[0-9]'

This will also works..

your code is also working..

thnks a lot!!!:-)

but jason I alsio need to updateed parentprocedureID of procedureId 86 as 86 only----

here is the table structure with some sample data:

create table proceduremaster

( procedureid int primary key ,

procedurecode varchar(10),

ParentProcedureID int)

Insert into proceduremaster(procedureid, procedurecode)

select 86, '0062'

union all

select 87,'0062A'

union all

select 88,'0062B'

union all

select 93,8680

union

select...

oops sorry.....

that table is of proceduremaster only...

i have already posted the script of table creation with some sample data...

I think this question is more about guessing rather than tricky one...

select STR(4.65,10,1) -- it will gives 4.7

select STR(3.65,10,1) -- it will gives 3.6

GOOD QUESTION WITH +1 AS MOVING TOWARDS END OF THE WEEK :-):-)

Its not a question that worth of 21 points...