HTH.

Isn't sp_executesql limited to 4000 characters?

I don't want to seem needy, but I don't see any duplicates in the data you sent us.

Which columns have duplicate values?

I never tried that, but is it possible to do a search and replace in the html document like this?

Replace (html, '', ' ')

That way the indexing should pick up...

Can you show us the raw data in the table?

This is annoying... I'll try this query on other servers here... but they are all 2k, with different services packs. Maybe I'll see a difference then.

he wants to sort by Jan, feb, march, apr...

not August, december....

Can you post the stored proc?

Why are you splitting the data into multiple tables??

The only valid time to use this technic is when you have a few M rows and...

update resource set lot_ctl_item = 'N' where lot_ctl_item = 'Y'

I think that the safest way to handle this would be to have a copy of the table in each database. That way you could create your foreign keys...

Maybe this will help (from today's articles) :

Checking Your Database Fragmentation Level

Assuming that these can come under many different formats, I'd simply save then directly on the server's hd and just save the path to the db. Just make sure...

Now that you've been humbled, we'll send you on your way to the next bug .

Looks like I can't help you. Maybe somebody else will, but if we can't it probabely means that you have found a bug in sql server... wouldn't be the first...

The server will not be able to use an index seek in you use datediff() and datepart(). You must use something like ">=" operators if you want to have...