<div>
oops almost an accidental sear word idue to typo &nbsp;replace twhat &nbsp; with what 
</div>


oops almost an accidental sear word idue to typo  replace twhat   with what

<div>
:( my fingers arent working properly today... Ill blame the keyboard :)
</div>


:( my fingers arent working properly today... Ill blame the keyboard :)

<div>
<div class="content wysiwyg-content">
Following code is not working and return A cursor with the name 'Cur' does not exist.<br />
But if i replace EXEC() by PRINT and run the printed line manually is working. What can i do?<br />
<br />
EXEC('DECLARE Cur CURSOR LOCAL FORWARD_ONLY READ_ONLY FOR SELECT DISTINCT(UI.FK_UserId), UI.DateInscrit, SM.DateEncaissement FROM Stats..UserNfo UI, SalesMembership SM, Stats_Panier_Moyen_'+@sPay<wbr />s+'_Cumul SPMCC WHERE UI.FK_UserId=SM.FK_UserId AND UI.FK_UserId=SPMCC.FK_User<wbr />Id AND SM.Annule=0 AND SM.MontantEncaissement&gt;0 AND SM.DateEncaissement&lt;='''+@<wbr />DateArretS<wbr />uivi+''' ORDER BY SM.DateEncaissement')<br />
<br />

</div>
</div>


Following code is not working and return A cursor with the name 'Cur' does not exist.
But if i replace EXEC() by PRINT and run the printed line manually is working. What can i do?

EXEC('DECLARE Cur CURSOR LOCAL FORWARD_ONLY READ_ONLY FOR SELECT DISTINCT(UI.FK_UserId), UI.DateInscrit, SM.DateEncaissement FROM Stats..UserNfo UI, SalesMembership SM, Stats_Panier_Moyen_'+@sPays+'_Cumul SPMCC WHERE UI.FK_UserId=SM.FK_UserId AND UI.FK_UserId=SPMCC.FK_UserId AND SM.Annule=0 AND SM.MontantEncaissement>0 AND SM.DateEncaissement<='''+@DateArretSuivi+''' ORDER BY SM.DateEncaissement')



EXEC DECLARE CURSOR with variable as tablename

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.