Did you try to call the function including the schema?

E.g....

@pravasis:

It seems like this function can be eliminated and the lookup could be used directly...

I tried to find the data in the tables used in your verbal description. But I couldn't.

You should start offering a voucher for the person that would provide ready to...

Please don't crosspost.

No further replies please.

Discussion already started here.

edit: duplicate post reply moved to the "twin post"

Edit: double post

Carlton B Ramsey (1/27/2011)

---

Please see the attached actual execution plans. One useing the address search and the other useing a taxid search.

The address search tool around 5 minutes the taxid...

@PSB:

Did you actually read my previous reply? My comment stands as it is. Reposting it won't change it.

Here's one way how to do it.

You could also search the...

First of all: you did an excellent job setting up the test scenario and collecting the data!

What I would do as a next step is to compare the actual execution...

"It wasn't me" is not a valid answer. 😉

The question is: can you change it? If not the column data type,...

At a first glance there should be an easier solution.

But, like others, I prefer to test my solution before posting.

So, please provide table def, sample data and expected result as...

:blush:

Naah... I'm just trying to return what I've learned over the years hanging...

I'm sorry but I have to ask: since you posted on a SS2K8 version, why don't you use the DATE and TIME data type to store the info you need?

If...

Here's how I'd do it:

SELECT something

FROM someentity

WHERE somedate>= DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)

Please note that I removed the datepart function from the source column to make it SARG-able (= to allow for an index...