Thread: Dynamic Stored Procedure

I figured it out I forgot to select that field from the view

Originally Posted by Lauramc

I don't see application_delet. But I do see application_deleted. Are you getting this error when trying to execute the code or when trying to print it? If it is on execute, you might try printing it so you can see what the output is.

[EDIT] I am glad you got it figured out. Let's hope it's all good now! [/EDIT]

Nope...now I have a syntax error near 'AND' lol..I'll just keep reviewing it...man I hate dynamic stored procedures...but in this case, it's necessary...

Originally Posted by lewy

You may want to post what your sp looks like as working so that others may benefit from the final solution.

It's not working yet, still some bugs I have to work out with similar errors as above.

BTW, don't tell me what to do in my own forum

I'm a total nit sometimes. The query wasn't working because I assigned the @sql variable as varchar(255) but the string was over 255 characters. Once I increased the amount of characters, the whole string was being read into the variable. Now it works