Now that, sir, is a thing of beauty!

Thanks so much for your ridiculously quick response, it's been a pleasure communicating with you!

I am still having some problems with this demonic...

Haha! Thanks!

Is it okay if I reply with another problem though? (Talk about a trial by fire, this DB is the devil!)

4 columns in this DB are datatype "real", and...

Hi Lowell - I made a change which appears to have sorted out the comma, but I'd like to know whether removing the space padding might have som drawback which...

I'm sorry to say it, but the result is almost exactly the same:

CREATE TABLE [dbo].[ACCESS] (

[TEMPFLAG] bit ...

Hey again.

I saw in the SP that you insert the data into @Results, so I caught the contents of that - check out the index_name and index_columns_key columns(only 2 rows,...

Hey there.

Here's the table scripted using Management Studio:

CREATE TABLE [dbo].[ACCESS](

[TEMPFLAG] [bit] NOT NULL,

[varchar](50) NOT NULL,

[DESCRIPTN] [varchar](50) NOT NULL

) ON [PRIMARY]

Then the index also using Management Studio:

CREATE NONCLUSTERED INDEX ...

ARGH! This is why I hate old databases - in the db I'm testing the script on, I have many many tables with indexes on single columns, so this gets...

Wow man!! I can't get over that response time! Thanks a stack, the table method will fit me to a T - again, just to say thanks, I'm completely blown...

Hey Lowell,

I'm sure you're not expecting a reply so long since you last updated, but here it is. This SP is absolutely fantastic - a work of art - but...