Hi All, I am using SQL Server 2005 and have the following function working properly. Now I need to pass some (but not all, bold and red) columns for select and group by at runtime. How can I do that and what is the best way to achieve it?
ALTER FUNCTION [dbo].[GET_MT_DAILY_HIST] (@STARTDATE DATETIME, @ENDDATE DATETIME)
RETURNS TABLE AS
RETURN
(
SELECT OP_CODE, SHORT_CODE, SID, CP_CODE, KEYWORD,
CONVERT(CHAR(10), SEND_DATE_TO_OP, 101) AS REC_TERM, YEAR(SEND_DATE_TO_OP) AS REC_YEAR,
SUM(TOTAL) AS TOTAL
FROM CPGW_SUMMARY.DBO.MT_SUMMARY
WHERE SEND_DATE_TO_OP BETWEEN @STARTDATE AND @ENDDATE
GROUP BY OP_CODE, SHORT_CODE, SID, CP_CODE, KEYWORD,
CONVERT(CHAR(10), SEND_DATE_TO_OP, 101), YEAR(SEND_DATE_TO_OP)
)
Thanks in advance.
Regards,
-Zia
Passing Columns to Function
Posted - 05/28/2012 : 04:37:35
