Viewing 15 posts - 796 through 810 (of 1,048 total)
Very good question to start of the week with joins 🙂
November 26, 2012 at 2:45 am
sp_rename 'tablename.[columnname],'column_name'
it will works 🙂
November 23, 2012 at 9:40 am
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]'
November 23, 2012 at 6:24 am
this is not the the question of the standard of SQl Server central
November 22, 2012 at 11:59 pm
i dont think this type of question should be asked in this forums..
November 22, 2012 at 11:58 pm
nice question and nice explanation by Hardcoder 🙂
November 22, 2012 at 11:56 pm
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...
November 22, 2012 at 4:17 am
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...
November 22, 2012 at 4:07 am
Viewing 15 posts - 796 through 810 (of 1,048 total)