duplicate post. No replies please.

Please use the original post

I strongly vote for using a stored procedure instead of the direct Insert.

There are numerous reasons, one of them is to separate the database structure from the application layer. A...

You might also want to have a look into the OUTPUT clause.

This would help to avoid the additional SELECT to get the related Poll_ID.

To me it sounds like a combination of paging and catch-all-queries.

Therefore, a combination of Gails catch-all article[/url] together with Pauls Optimising Server-Side Paging[/url] should get you startet.

Based on your description

I'm...

Why not doing all the data manipulation inside the database?

can you provide a test scenario so we can better understand what you're trying to do?

As to my knowledge you cannot overrule each and every situation where SQL Server need to recompile a sproc.

There are numerous situations where SQL Server may "decide" to recompile a...

The answer is rather simple: it depends.

If there's a dedicated report server doing nothing but providing reports and there's a business oriented security model implemented (e.g. all reports are based...

please note that the very same question (just slightly rephrased) can be found at

You're talking about a proxy account being local admin on the machine holding the file.

So I'd guess you're talking about a SQL agent job. Or am I missing something?

Is it...

[sarcasm ON]

If the company can afford to pay someone to scroll through one million rows, they'll definitely have...

What you've described so far is HOW you do your corrent task. But not, WHAT this task really is.

If you'd describe the task you're faced with, we might be able...

"It's not working" doesn't really help us to help you in any way.

What's the exact error message you receive?

If you need to know the auto-generated identity value of the rows that has been added you could use the OUTPUT clause within your first INSERT statement together with the...