What does parameter sniffing mean .?

Could it really turn performance way down and your method is preventing the performance fall back.?

Then should not every stored procedure be written that way.?

I...

Hi Chris,

Tnx, This is what i was looking for,

Strange but i had been trying that in my experiments and got the error on the "<"

As i try your code...

Hi Vic,

Was been thinking on that also as solution,

but as i have to get this for multiple variables it does make the code messy

and therefore i was trying whether...

jgrubb (1/30/2009)

---

I'm a little rusty on progress. Couldn't remember the system user name. It's a quirky DB, and you can get bit by a bunch of things....

is the security is the failure,

Then make sure you create a user called "sysprogress" in de prodb

any other user will fail if this one does not exists,

Wkr,

Eddy

Hi ChrisM,

Tnx a lot for your assistance,

It works not only like a charm, It gives me the results that i wanted so thats verry nice, but it also execute faster...

Hi Jef,

In fact it is really simple,

I select a lot of columns from different tables (lets say 10)

I know for sure that i will get 3 rows back for each...

Hi Jef,

Well what i mean is that when i'm off starting to include more "columns" (edited from rows) its more likely that those rows wont be unique (distinct) anymore...

Hi chrism,

Tnx this seems to work for the example,

Now i going to try to implement this with an update statement

my original temptable has this structure and i foresee some...

Hi Eddy, this is a really useful exercise you've come up with here. Looking at this problem from a row-by-row point of view, it appears difficult. But SQL Server works...

GilaMonster (11/20/2008)

---

Sorts are expensive operations and distinct requires a sort, as do most other methods of removing duplicates from a resuuklt set.

The best 'workaround' is to find out why...

Hi, Garadin,

Nope, that...

in my testtable

i have 4 rows when run without the distinct and 3 rows if i use the distinct keyword

what is exactly what it should return cause i have put...

That is idd whats the demand,

DISTINCT works fine, don't understand me wrong, but cause i have been told its more expensive i'm looking for a more faster query method if...

Hey Jeff,

I was looking for the SP_MakeWebTask but the following appears on my screen.

sp_makewebtask is retained for backward compatibility. New Web pages are more easily created using Microsoft SQL Server...