Ok... but the scenario you just stated exactly fits the methods I suggested... whatever.

To answer your original question, you need to use some Dynamic SQL to do what you want......

Here's a way to avoid the table scan...

select * from task where Descr LIKE '% myword %' OR Descr LIKE 'myword %' OR Descr LIKE '% myword'+char(10)+'%'

If you...

IMHO, archiving data into separate monthly named databases is one of the worst things you could do... they (3rd party provider) did the same thing were I work and it's...

Does this do it for ya?

SELECT 'ID1' AS IDName, ID1 AS IDValue FROM yourtable

UNION ALL

SELECT 'ID2' AS IDName, ID2 AS IDValue FROM yourtable

UNION ALL

SELECT 'ID3' AS IDName, ID3...

I know what you mean... It's only when they live up to the name of "BSOFH" and they've got that control thing going on... or, they're just plain old stupid.

I gotta agree with THAT!  Between a tally table (you guys call it a numbers table) and/or a date table (mine are combined into one which is why I called...

Cool... Thanks Noeld.  It's been so long since I've used a trusted connection, I almost forgot they existed.

I'll probably keep using linked servers, though,...

One of the things I don't like about open row sets is the login information is in the query... and, no, I prefer not to encrypt queries especially on development...

test

Reddy,

Thanks for the advice especially about the Repair_Allow_Data_Loss option... I'll remove that holding it for the very last stab.

Understood about the other stuff... I did try attaching in EM, using...

Awesome, ain't it? Most good SQL Developers would be disappointed if that took more than a handfull of milli-seconds regardless of how many...

All good points, Rudy... I'm used to good DBA's that take proper care of those things, so I tend to forget about them.  My big problem has been that most...

Frank and Chris,

Because the 1st of January, 1900 was a Monday, this also works regardless of the setting of DateFirst.

DECLARE @Year    CHAR(4)

DECLARE @ISOWeek VARCHAR(2)

    SET...

Nice article, Chris... excellent links, as well.

Thanks Chris,

I'll take a look.