Hi all,
I have codes as follows:
SET @strSql='SELECT salaryDate,workingHourID FROM ATC_SALARYSTATUS WHERE staffid='+ ltrim(str(@staffID)) +
' AND SalaryDate >= ''' + CONVERT(varchar,@date_min,101) + ''' AND SalaryDate <=''' + CONVERT(varchar,@date_max,101) + ''''
EXECUTE ('DECLARE...