How can I get the actual rows?

I get a error : Query execution failed. This syntax is only allowed for parameterized queries. Must declare the scalar variable '@P1'.

Let me refine the question, the sniffed parameters is included in the query plan, and plan explorer knows about it. I only want plan explorer to declare or substitute the variables automatic. I know I can do it manually and then it will work. But could it be done automatic?

Plan.pesession (4.0 kB)
avatar image By Hans 6 asked Aug 14, 2013 at 08:14 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x166
x4

asked: Aug 14, 2013 at 08:14 AM

Seen: 549 times

Last Updated: Aug 15, 2013 at 02:01 PM