Maybe you should repost here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=213849

They added a leading space, now come on. At least put those "traps" a few weeks apart.

Are you telling us you missed that one??

I'd say it's exactly like that .

Why do you need to do that???

The Curse and Blessings of Dynamic SQL

Dynamic Search Conditions in T-SQL

Arrays and...

And you restarted EM???

No clue what's wrong. Maybe with a bigger sampling of the data, it would work.

how about sp_updatestats??

Try restarting EM (simple refresh might be enough).

Especially since it's a repeat of an older question (1-2 weeks ago).

Isn't UNION [ALL] ainsi standard??

Did you change the server's setting or your pc's settings?

Well there can be constraints but those are not the types of columns you want to index (a unique constraint is an index). What you need to do is...

Can you show us exactly what you are trying to do?

BOFH = Bastard [system] operator from hell.

The kind that doesn't want to spare 50K for a numbers table even if you prove that I'll lessen the load on the server...

Do you need help with the query??