You might want to consider looking in to the full-text search; see this article for more details: http://msdn.microsoft.com/en-us/library/ms142571.aspx. This page talks about the exact nature of full-text search...

I've a similar follow up question to this. I know that if you use NOLOCK on a query, you will be reading uncommitted data, which also means that your query...

How is order not guaranteed? I'm ordering it by ID, which is the primary key - the order should be absolute, no?

Sorry - I should have elaborated on that one too, lol. My bad.

Rather, as a full solution, and using the above sample data,

DECLARE @NewID INT

DECLARE @OldID INT

SET @NewID = 0

SET...

Alrighty - I've come up with a solution that I think will be acceptable for my purposes. One thing that i should have noted is that i'll only be dealing...

hm - interesting idea, let me see if it will work for my application... will post back shortly

T1

IDField1Field2Field3Field4

11111

22141

Yeah I was considering that approach, unfortunately the simple example that I gave is much less involved than the actual problem. Was really hoping for some better way of doing...

Ah, sorry, i guess the example data I gave was a bit misleading - it's not that I want the minimum values - rather, what I want is the *first*...

here you go:

DECLARE @test-2 TABLE

(

ID INT,

Field1 INT,

Field2 INT,

Field3 INT,

Field4 INT

)

DECLARE @Test2 TABLE

(

ID INT,

T1ID INT,

Field1 INT,

Field2 INT,

Field3 INT,

Field4 INT

)

INSERT INTO @test-2

VALUES (1, 0, 0, 0, 0)

INSERT INTO...

My situation's actually kinda a good example for this discussion. See, when I joined the company I'm in right now, it was just after I graduated from university. I had...

Oh don't get me wrong - I'm far from complaining. I just wanted to clarify my situation, and perhaps add somewhat to the discussion.

Sometimes I read comments on these forums,...

Having read through most of the replies in this thread, I feel like I need to make something clear.

I'm more than capable of going through the indices on the table...

@Dixie Flatline, that's pretty much spot on. The issue of the tables being badly designed / indexed is a major issue, but it's not something we can just drop everything...

Yeah this sort of idea is not for the purposes of an action which is going to be taken on a regular basis - moreso for a report purpose. It's...