a sarg is a searchable argument. By making the Longitude and latitude searchable as below, this will quickly eliminate all those zipcodes outside of the squared off area....

Almost there,

you need cross apply , not cross join

select myAlias.* ,Thesaurus.definition

from Thesaurus

cross apply dbo.[fn_split](Thesaurus.definition,',') myAlias

You cant do that, a view is a single select statement.

Can you give an example of what you are attempting ?

There are a few methods , not exists, count(*)=0 etc but

I prefer to test non-existance with a left outer join

select *

from WCE_ILR

left join WCE_COURSE_DELEGATE_LINK ...

There was a link in that document

http://www.sommarskog.se/arrays-in-sql-2000.html

I would wrap it in a Cte and then filter on the result of that.

However , what will hurt your performance more is unnecessary calculations.

In my Sarg i would also...

Can you show us how you have tried to resolve the issue ?

Try this link

http://www.sommarskog.se/arrays-in-sql-2005.html

That will be the guy we gave the...

Also the rowid is treated as a string

@paul-2 , yes fun

INSERT dbo.Employee VALUES ('abc', 2000);

INSERT dbo.Employee VALUES ('asd', 1000);

INSERT dbo.Employee VALUES ('azz', 5000);

INSERT dbo.Employee VALUES ('awe', 4000);

INSERT dbo.Employee VALUES ('qwe',...

%%lockres%% is undocumented, Paul certainly has a found a new use for it

From http://www.informit.com/articles/article.aspx?p=686168&seqNum=5

The second option for row and key resources is to use the %%lockres%% virtual column....

Ok , now you've defined an order things get much easier....

Steven has give you the answer above.....

Ok , heres an analogy for you.

Image that each rows data is written on a piece of paper then thrown into a bucket.

Now , you are asking for the sixth...

Well you clearly havent, as you are still saying 6'th record.

What order by clause are you using to make it the 6'th row in your result set.

Please note the massive...

Another urgent one

http://www.sqlservercentral.com/Forums/Topic803961-338-1.aspx

Quick everyone , stop what you are doing.

All he needs is the sixth row, doesnt SQL suck!