如何在sql中的下面的查询中编写存储过程。

本文介绍了如何在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' )

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中的下面的查询中编写存储过程。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！