I'm not sure the index helps when you use the '<>' operator.

I hope by FileMaker you don't mean that concoction created by IBM on their PS2 some years ago?

In any case, an alternative is to create a column in Excel that uses...

I use the VB/ADO code to get the contents of a BLOB into a file. After that you can fire up Word using OLE Automation and do the search. This...

In ADO the Open method of the Recordset object allows you to code the adFetchAsync parameter. I have never used it. But I presume it means:

1. code execution continues after...

In case you haven't found a split function amongst the zillion sitting out there here is one that should take care of your problem. Then all you need to do...

You could script yourselves out of this problem. You can format the date anyway you like. Then instead of writing

dir c:\temp\*.*

you write

cscript mydir.vbs "c:\temp"

Option Explicit

Dim objFso

Dim objItem

Dim colFiles

Dim datD

Set objFso...

But doesn't it worry anyone that instead of scanning 10 million records at the end you will have scanned over 5 billion records?

'deleted' is a special table available within the context of a trigger. The dynamic sql doesn't know it's being called by a trigger. But the use of a temporary table...

Welcome to the limited and confusing and mind boggling world of dynamic sql. My guess is that 'deleted' being a 'special table' of sorts is not recognized inside the dynamic sql...

Did some searching on 'dynamic sql' and came up with this as the solution to my original problem.

declare @tabname nvarchar(50)

declare @count int

declare @sql nvarchar(4000)

select @tabname='sometable'

select @sql=N'select...

Jeff,

Even though this kind of dynamic sql leaves a lot of room for generating incomprehensible code, I'm interested in getting to know it better. Any place you recommend with loads...

I try to stick with Join, Left Join, Right Join, Full Join and Cross Join and try to keep the reduntant and confusing OUTER out. But regarding pre SQL92 syntax, what's...

Slept on it. Decided to use VB+ADO. SQL Server dynamic stored procedures are simply not up to this without giving you some serious and unnecessary headaches.

This should get your juices flowing. Have your pick from the following three. I'll leave it up to you to make them robust. Thus the first one assume there are...

This is a classic case of vertical to horizontal rotation. There is no general solution for this using sql. You need to put limits around this problem, i.e. how many...