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
Post a Comment