|
egemen_ates
Yak Posting Veteran
Turkey
63 Posts |
 Posted - 05/18/2012 : 08:12:28
|
exec DENEME_page'WITH CTE1 AS ( SELECT SOC.SID, SOC.SOCIAL_MEDIA_ID, SUBSTRING(SOC.SOCIAL_MEDIA_CONTENT,1,100) AS SOCIAL_MEDIA_CONTENT, SOC.PUBLISH_DATE, SOC.IMAGE, SOC.USER_NAME, SOC.SEARCH_KEY, SOC.SITE, SOC.RECORD_DATE, SOC.RECORD_EMP, SOC.RECORD_IP, SOC.UPDATE_EMP, SOC.PROCESS_ROW_ID AS PROCESS, SOC.UPDATE_DATE, SOC.UPDATE_IP, SOC.COMMENT_URL, SOC.LANGUAGE, SOC.USER_ID, PRO.PROCESS_ROW_ID , PRO.STAGE AS STAGE FROM SOCIAL_MEDIA_REPORT SOC, PROCESS_TYPE_ROWS PRO WHERE SOC.PROCESS_ROW_ID = PRO.PROCESS_ROW_ID AND ((SOC.PUBLISH_DATE >= {ts '2012-05-17 00:00:00'} AND SOC.PUBLISH_DATE <{ts '2012-05-19 00:00:00'}) OR PUBLISH_DATE IS NULL) ), CTE2 AS ( SELECT CTE1.*, ROW_NUMBER() OVER (ORDER BY SID DESC) AS RowNum,(SELECT COUNT(*) FROM CTE1) AS QUERY_COUNT FROM CTE1 ) SELECT CTE2.* FROM CTE2 WHERE RowNum BETWEEN 1 and 1+20-1'
IS NOT WORKING
quote:
Originally posted by khtan
BEGIN
exec (@SQL)
END
read this http://www.sommarskog.se/dynamic_sql.html
KH
Time is always against us
|
 |
|
Stored proc help
