easy one for NULL 🙂

Very good question to start of the week with joins 🙂

nice question for the week..

+1 🙂

learn about STUFF today

sp_rename 'tablename.[columnname],'column_name'

it will works 🙂

how to post query in this format?

I create this one and it works- :-):-)

update PC

set pc.account =p.patientID

from PatientLocDtl pc

join patientlocdtl p on left(p.ChartNo,len(SUBSTRING(p.ChartNo,PATINDEX('%-%',''),len(p.ChartNo))))=left(pc.ChartNo,len(SUBSTRING(pc.ChartNo,PATINDEX('%-%',''),len(pc.ChartNo))))

where right(p.chartno,1) like '[0-9]'

hey, I am done with this....

this is not the the question of the standard of SQl Server central

i dont think this type of question should be asked in this forums..

nice question and nice explanation by Hardcoder 🙂

:-):-D:-P

easy one..

Hey I am able to create sp_who to a schema specific.. and it result whatever i wrote in stored procedre no other information is showing as it shows when run...

i tried to created a stored procedure schema specific for sp_who but am not able to create that...

can you plz tell me how to create procedure specific to a schema...

easy one for the day...