如何在sql中的下面的查询中编写存储过程。 [英] How to write stored procedure in the below query in sql.

问题描述

Sqlstr = "select sum(sal_det_amt) as reimbursement from salary_details where sal_det_desc IN ("+
 " select comp_set_desc  from companyinfo where comp_id = " + strCompanyid +
" and comp_set_type = 'Earnings' and comp_set_deleted = 1 and sal_isdeduct = 0 ) "+
" and sal_id IN (select sal_id from salary_master  where sal_deleted = 0 "+
 " and sal_Year = " + lngPreviousYear + " and comp_id = " + strCompanyid +
 " and emp_code = '" + Txt_Employee.Text + "' ";

推荐答案

select sum(sal_det_amt) as reimbursement 
from salary_details 
where sal_det_desc 
IN 
(select comp_set_desc  from companyinfo where comp_id = 1
and comp_set_type = 'Earnings' and comp_set_deleted = 1 and sal_isdeduct = 0 ) 
and sal_id 
IN 
(select sal_id from salary_master  where sal_deleted = 0 
 and sal_Year = 2014 and comp_id = 1
 and emp_code = 'EMPLOYEECODE' )

这个程序可能会对你有所帮助

this procedure may u help

create PROCEDURE [dbo].[Procedurename]
(
    @strCompanyid  varchar(22)
    ,@lngPreviousYear int

    ,@Txt_Employee varchar(22)
)

as
begin


select sum(sal_det_amt) as reimbursement from salary_details where sal_det_desc IN (
  select comp_set_desc  from companyinfo where comp_id =@strCompanyid
 and comp_set_type = 'Earnings' and comp_set_deleted = 1 and sal_isdeduct = 0 )
and sal_id IN (select sal_id from salary_master  where sal_deleted = 0
and sal_Year = @lngPreviousYear and comp_id = @strCompanyid
and emp_code = @Txt_Employee)

 end

这篇关于如何在sql中的下面的查询中编写存储过程。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！