Well, it still depends on your table definition and data distributions, but:

1) I doubt that you can do much with this one. Maybe a clustered index on [ordered], but...

ALTER DATABASE [MyTests1] SET OFFLINE

It depends on the table's definition and what queries you are using.

Cool.

OK, this should do it.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#MyTestRates','U') IS NOT NULL

DROP TABLE #MyTestRates

IF OBJECT_ID('TempDB..#MyTestCalendarTally','U') IS NOT NULL

DROP TABLE #MyTestCalendarTally

IF OBJECT_ID('TempDB..#MyTestCurrencies','U') IS...

Thanks, Matt. I'm still waiting to see how I did in the evaluations from everyone else...

Thanks, Johan. 🙂

I am somewhat skeptical that all of your requirements can be met using SQL Server 2000 (That is, non-RBAR, non-Triangular View). however, I am willing to give it a...

This is probably caused by commas in your string-based columns. You will need to put quotation marks around the columns that might have commas embedded in their text. ...

Oops, you should change the Index names (I did a cut and paste).

Or alternatively, drop the existing indexes of the same names as they are redundant now.

Thanks. You need these two indexes:

CREATE NONCLUSTERED INDEX [IX_ptDictation_MRN_Status] ON [dbo].[ptDictation]

( [MRN] ASC,

[DOS] ASC,

...

Glad I could help.

Note that this will handle multiple locations within the same form.

Heh, I actually wrote an entire data-drive application framework built like this about 6 years ago.

Anyway, try this:

Declare @sql Varchar(MAX)

Set @sql = ''

SELECT @sql = @sql

--select form,location, (Row_Number() Over (Partition...

Apparently, the default behavior is to pad the attachment out to 256 characters. Which would definitely have the results that you see.