T.Ashish (7/29/2013)

---

Parameters goes like this:

(isnull(@activity_id,0)=0

or

pd.activity_id = @activity_id)

and

...

Just because recompilation occurs, does not mean that the optimizer will make a different decision, but it may very well arrive at the same plan.

So the simplest would be to defined a linked server, then you would not need to use dynamic SQL, but you could make a plain procedure call.

But to continue on...

The optimizer often does a better job with UNION than OR, but that applies to conditions like:

thiscol = @value OR thatcol = @value

Which does not seem to...

WITH SCHEMABINDING has these effects:

1) As Gail says, it is required if you want to create an indexed over the view.

2) It prevents any of the tables and the columns...

Only to add what Jeff suggests: there are multiple ways to skin this cat, and which one that fits you depends on a lot things. My suggestion assumes that you...

This is what SET CONTEXT_INFO and the function context_info() is for.

See this section in an article on my web site for more details:

http://www.sommarskog.se/grantperm.html#context_info

(You only have to read this section, and...

The neatest solution is to write a small console-mode program that parses the file, and then sends the comma-separated to a table-valued parameter, which you pass to a stored procedure...

Yes, this is a problem in your network somewhere. You should be able to produce this problem by sending a query that produces a result set of some size, and...

What exactly is the error message that users get when they try to connect?

This is a forum for SQL questions, not for telepathy. If you don't include table and column definitions, the answers you get will be based on wild guesses.

If these columns...

In such case...

with tmp as (

select ...

CASE WHEN T2 < R2 THEN T2

WHEN T2 < S2 THEN T2-R2

ELSE S2

END * O2

convert(int, round(((Monthly Revenue field - Monthly Cost field )/Monthly Revenue field) * 100), 2))

Coming late to the party, but...

The charindex expression is bound to scane the entire table.

LIKE '9000413237%' will seek the index in a normal way.

LIKE '%9000413237%' will also result in an...