I understand that - but you're still not getting my question. SQL Server doesn't acknowledge physical order, so there's ultimately no way (without something like an autonumbered field) to...

to look for the literal %, enclose it between square brackets.

Something like:

create table #strings(str_all varchar(20))

insert #strings

select 'cow 1' union all

select 'cow 2' union all

select 'cow 3' union all

select 'cow%1' union...

What order do you plan on using in the selection process from MasterList? As in - positions 3,10,17 based on what ordering scheme?

Manish Mittal (6/13/2008)

---

Yes sure.

You can create a SQL job by using Enterprise Manager, schedule the job to run on daily basis and write following SQL stsement in Command text box...

Essentially. The main difference in my mind is that...

Kargin - this is not so much an indexing thought, more taking a look at the Regex function. You're calling a table-valued CLR function twice, and running aggregates on...

don't know if this will help, but - there was a discussion not to long ago about Top @N making some really poor decisions on execution plans. Something akin...

I think you hit the nail on the head when you were describing the issue at hand. It's not so much that the processing time is going to change...

Yup - I certainly use primary keys on my Access tables, which I think also throws in some extra "incertainties" into these. The behavior around compact does sound familiar,...

hmm... didn't notice the double-post until now....

Please don't cross-post - you end up diluting/confusing the conversation. Besides you tend to piss off regular posters so you might get less...

Sergiy (6/12/2008)

---

Yes, of course.

Let's say, it was an intentional bug to make OP to analize and understand the code, not to just copy-paste it.

😉

Does it work as an excuse? 😛

And...

Stephen Morley (6/12/2008)

---

Sorry but i do not agree with you.

MS Access holds an internal bookmark on records in tables so it can determine the first record entered into that table....

Lowell (6/12/2008)

---

Stephen is kind of right, as long as you ignore some stuff.

unless you've added a primary key to the table, because Access is file based, Access really does keep...

Stephen Morley (6/12/2008)

---

Matt,

The help excerpt you published references a DAO recordset object. I am not using a recordset in my example - i am simply creating a query against a...

Agreed - with the get external data and connection based on windows auth - you've got it all covered and no VBA needed.