Create procedure dbo.test (@column char(2))

as

exec ('select itemtype from import where ' + @column + ' = ''x''')

go

Make sure you read this before going down that road.

The...

Select dateadd(D, 0, Datediff(D, 0, GetDate()))

Can't find anything either in BOLs!!

Does that mean that microsoft isn't perfect???

The solution to that problem is quite easy, can you post the ACTUAL NON SIMPLIFIED problem so that we don't do the work twice??

It's not the first time I hear of performance problems when talking about table variables . Looks like you're past the threashold of...

Could you post the tables DDL and the full sql statement? Maybe we'll spot the problem.

HTH, again .

Are those tables in the same db?

Do the tables have the same collations?

Select id, name, enabled, email_address from dbo.SysOperators

Maybe that would get Sushila back to work . So what about those big ants/ints??

Already sent him this link... I wanted to have a more experienced person make a correct recommendation. I never actually had to make such a choice in my [short]...

Now that's irony .

where CreateDate >= '12/12/2005 1:00 PM' and CreateDate < '12/12/2005 2:00 PM'

No wife or G/F, and I would assume that she wouldn't be stupid enough to bet anything valuable of ours ont that contest ...

You're still a wowen so it's still in your DNA somewhere that you got to argue... unless you are THE exception. I guess we'll never know.