DECLARE @sqlCommand varchar(1000)

DECLARE @SQLParam varchar(200)

DECLARE @SQLParamValue varchar(200)

DECLARE @SQLParamResult varchar(200)

DECLARE @SQlQuote char(1)

DECLARE @Comp_ID varchar(4)

DECLARE @Periode varchar(7)

DECLARE @prd varchar(1)





SET @SQLQuote = char(39)

SET @Comp_ID = '{?Comp_ID}'

SET @Periode = '{?Periode}'

SET @prd = {?Prd}

SET @SQLParamValue = '{?SQLParamValue}'

SET @SQLParam = '{?SQLParam}'

SET @SQLParamResult = ' AND ' + @SQLParam + ' = ' + @SQLQuote + @SQLParamValue + @SQLQuote 



if(@SQLParamValue = '')

 SET @SQLParamResult = ''



SET @sqlCommand = 'SELECT a.login_id,a.DS_Code, b.Plus_Minus, b.Taxed, b.DS_Desc, a.Curr_ID, b.DS_Urutan, SUM(a.Amount) As Amount , d.Nama_Divisi, e.Dept_Name, c.ID_Divisi, c.Dept_ID, ' +'''+ IDR +'''+ 'As Curr_ID 

 FROM PrSalary a 

 INNER JOIN Pr_DetailSalary b ON a.Comp_ID=b.Comp_ID AND a.DS_Code=b.DS_Code

 INNER JOIN Tbl_Prl_General_Info c ON a.Comp_ID=c.Comp_ID AND a.Login_ID=c.Login_ID 

 INNER JOIN Divisi d ON c.Comp_ID=d.Comp_ID AND c.ID_Divisi=d.ID_Divisi 

 INNER JOIN TDept e ON c.Comp_ID=e.Comp_ID AND c.ID_Divisi=e.ID_Divisi AND c.Dept_ID=e.Dept_ID 

 WHERE a.Comp_ID=' + @SQLQuote + @Comp_ID + @SQLQuote + ' AND a.Periode=' + @Periode + ' AND a.Prd='+ @prd +'

 '+ @SQLParamResult +' 

 GROUP BY a.login_id,a.DS_Code, b.Plus_Minus, b.Taxed, b.DS_Desc, a.Curr_ID, b.DS_Urutan ,d.Nama_Divisi, e.Dept_Name, c.ID_Divisi, c.Dept_ID 

 ORDER BY a.login_id, b.DS_Urutan'



EXEC(@sqlCommand)