Finally...

I got it right this time. After looking through few examples in Microsft KB

Heres the code

WHILE 2 > 0 AND @itemCounter <= 2

BEGIN

SET @strSQL = N' SELECT @strCntOut = count(*)...

Im lost already.

I cant seems to find where can I put the output parameter..

Can you help me.

SELECT @strSQL = N' SELECT count(*) FROM ' + @tabPName +

+ ' WHERE iID...

Well... Yeah. I check the code again... And it doesnt work. Sorry.

And yes, I want to save the output from the EXEC statement in @strCnt

THANKS A LOT!!!

It works now...

Wouldnt make it with out your help.

Heres how the code looks now

SELECT @strSQL = N' SELECT '+ @strCnt +' count(*) FROM ' + @tabPName +

+...

Ok.. Will try that one.

Besides nvarchar, what else that i can use.

Thanks

If i execute it.. EXECUTE (@strSQL)

It will return the results of this EXECUTE statement in QA. Things work fine there.

What I want to achieve here is, if the EXECUTE statement...

I have to use a dynamic sql to solve this probs cause im using a numbers of different staging database that will be created by the user.

so i just want...