Also - You can't "build and execute" at the same time. EXEC wants a static string (meaning - something fully built before you pass it to execute), not some...

Here is what I'm reading on msdn ms152560 (referenced in today's question)

...and these are excerpts...

In reference to the 'sync with backup' option...

Setting this option on the distribution database has no...

I worked on a project once where I got the 'report' requirements from the Business Analysts, and it simply said they wanted a report for EVERYTHING (literally, that is what...

Sorry about that, my bad...I jumped too quick.

Matt is correct with the 'char(39)'. I still could not get a similar construct to run in the 'exec' statement.

I had to...

If the code you posted is your real stored proc, the first 'if' statement does not have the 'char(39)', but the 'char(39)' is still in the query under the 2nd...

The way I would do it is to create a 'StatusTable' that contains the StatusID (S1, S2, etc), and a disposition for the status (open, closed, deferred).

It might look like...

Yep, your variable is already set as a varchar (string). You simply concatenate it to the other string in the dynamic sql as the previous post shows. 🙂

Some very good replies here...

Like some others here, I have no aspirations for management after seeing what they actually do (BORING!). I have an MBA and MS in Comp...

Nicely said Gail and Jeff...

Doing a little extra especially when it tends to 1) make your job easier such as in the case of utilities for troubleshooting, etc., and 2)...

Just out of curiousity, since you can't use a table variable in dynamic SQL, could you create a UDF that returns a table that was populated based on some param...

I have worked for technical managers who were clueless on the technology we were using, but they thought they were experts (how do they get these jobs?). Then we...

Consider this, most of the people at your new job probably know LESS than you do about SQL Server 2005. In my experience, the best way to learn about...

Sorry Brandie, I wasn't referring to all the testing you people were doing to answer the OP...that was interesting. I was referring to a post by 'annejo' about having...

No wonder applications break so easily. I learned not to use 'select *' in my Database 101 class in college years ago. It was very easy to understand...

I tend to be a contractor more than a permanent employer because I got tired of working more than 40 hours per week and not getting compensated for it.

I like...