Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
egemen_ates
Yak Posting Veteran
76 Posts |
 Posted - 2012-05-18 : 07:22:46
|
| how can i do this procedure?given errorALTER PROCEDURE [dbo].[SP_EXAMPLE ] @SQL VARCHAR(1000)ASBEGIN exec @SQL ENDEXEC SP_EXAMPLE 'SELECT * FROM EMPLOYEES' |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
egemen_ates
Yak Posting Veteran
76 Posts |
Posted - 2012-05-18 : 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 WORKINGquote:
Originally posted by khtan
BEGINexec (@SQL)END read this http://www.sommarskog.se/dynamic_sql.html
KH[spoiler]Time is always against us[/spoiler]
|
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-05-18 : 08:14:05
|
what is the error message ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
egemen_ates
Yak Posting Veteran
76 Posts |
Posted - 2012-05-18 : 09:16:35
|
THANK YOU SIR I SOLVE ITquote:
Originally posted by khtan
what is the error message ?
KH[spoiler]Time is always against us[/spoiler]
|
|
|
|
|
|
|
|
|
Stored proc help