UPDATE [analysis] set [Templ_ID] = @1 

SET NO_BROWSETABLE OFF
go
Insert into analysis (P_ID,Vrach_ID,Lab_ID,Zabor,Postanovka, Klinik_ID,Templ_ID) values(58317,2,6,'11.12.2015','11.12.2015',3,0)

go
SET NO_BROWSETABLE ON
go
select max(id) from analysis

go
SET NO_BROWSETABLE ON
go
select p.ID as PID,p.*, a.id as AID,a.*,th.T_Name
from  pacienty p, analysis a,Templ_headers th
where  a.P_ID=p.ID and th.id=a.Templ_ID


go
SET NO_BROWSETABLE OFF
go
Insert into Analiz_result (tsid,aResult, Norma, EdIzm, IsSubstr, StrID,Pokazatel, Analiz_ID)select id,'',Norma,EdIzm,IsSubstring,StrID,Pokazatel,96533 from Analiz_template where header_id=9

go
SET NO_BROWSETABLE ON
go
SET NO_BROWSETABLE OFF
go
Update analysis set Templ_ID=9

go
SET NO_BROWSETABLE ON
go
select p.ID as PID,p.*, a.id as AID,a.*,th.T_Name
from  pacienty p, analysis a,Templ_headers th
where  a.P_ID=p.ID and th.id=a.Templ_ID

go