sql server - Msg 102, Level 15, State 1, Procedure CaseSummary, Line 18 Incorrect syntax near 'end' -


i'm trying create input parameter procedure i'm having error in

  create procedure casesummary (@client_id int='') begin if exists(select client_id [client] client_id= @client_id) begin select caseregister.client_id,caseregister.case_id,  caseassign.lawyer_id ,  document.doc_id, casetocourt.court_id, casetojudge.j_id,  casedetail.result, clauses.clause_id, subclauses.sc_id from((((((((( caseassign inner join lawyer on caseassign.lawyer_id = lawyer.lawyer_id) inner join caseregister on caseassign.cr_id = caseregister.cr_id) inner join client on client.client_id = caseregister.client_id) inner join document on document.client_id= client.client_id) inner join casetocourt on  casetocourt.cr_id= caseregister.cr_id )  inner join casetojudge on casetojudge.cr_id = caseregister.cr_id ) inner join casedetail on casedetail.cj_id = casetojudge.cj_id ) inner join clauses on clauses.cd_id = casedetail.cd_id) inner join subclauses on subclauses.clause_id = clauses.clause_id); end 

error:

msg 102, level 15, state 1, procedure casesummary, line 18 incorrect syntax near 'end'.

try this;

create procedure casesummary (@client_id int='')  if exists(select client_id [client] client_id= @client_id) begin select caseregister.client_id,caseregister.case_id,  caseassign.lawyer_id ,  document.doc_id, casetocourt.court_id, casetojudge.j_id,  casedetail.result, clauses.clause_id, subclauses.sc_id caseassign inner join lawyer on caseassign.lawyer_id = lawyer.lawyer_id inner join caseregister on caseassign.cr_id = caseregister.cr_id inner join client on client.client_id = caseregister.client_id inner join document on document.client_id= client.client_id inner join casetocourt on  casetocourt.cr_id= caseregister.cr_id   inner join casetojudge on casetojudge.cr_id = caseregister.cr_id  inner join casedetail on casedetail.cj_id = casetojudge.cj_id  inner join clauses on clauses.cd_id = casedetail.cd_id inner join subclauses on subclauses.clause_id = clauses.clause_id end 

the 'begin' @ start either needs 'end' @ end or don't specify it


Comments

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

html - How to custom Bootstrap grid height? -

transpose - Maple isnt executing function but prints function term -