sql - Adding table in the stored procedure code -
i new sql. have stored procedure need add 2 columns of table "dbo.additionprojectdetails". here projectid primary key. below code snippet cant add whole here. help?
select pbd.proj_id, case when phase =1 'phase i' when phase=2 'phase ii' tasktype,area_name,projectname,os_name,ptcdd.remarks projectdetails (nolock) pbd inner join projecttestprocessdetails (nolock) ptpd on pbd.proj_id =ptpd.proj_id inner join projecttestcycledet (nolock) ptcd on ptcd.proj_id=pbd.proj_id inner join projecttestcycleduration (nolock) ptcdd on ptcdd.proj_id=pbd.proj_id inner join projecttestprocesscostdetails (nolock) ptpcd on ptpcd.proj_test_prepareid=ptpd.proj_test_prepareid inner join areamaster on am.area_id =pbd.areaid inner join projectmaster pm on pm.projectid =pbd.platformid inner join osmaster os on os.os_id =pbd.osid status in ('s','r','c') , tasktype,area_name,projectname,os_name,ptcdd.remarks group pbd.proj_id,pbd.created_by,pbd.created_on,status,taskgivendate order ptcd.taskenddate desc
check link here explaination of store procedure , details u want
Comments
Post a Comment