Subhash,

For the first problem, use the UNION query you made as if it were a table and do the GROUP BY on that... like this...

 SELECT d.EmpNo, SUM(d.Sal) AS...

declare @dbname varchar(100)

    set @dbname = 'Some Database'

DECLARE @sql VARCHAR(8000)

    SET @sql = 'use ' + @dbname

             + ' dbcc shrinkfile (''File'', Size)'

   EXEC (@SQL)

...should work for what...

I don't beleive that moving the SELECT into a transaction will prevent others from writing to the target table and, therefore, will not prevent you from inserting a duplicate ID...

First, I agree with Remi 100% but those darned 3rd party dummies just keep writing junk and selling it.  Worse yet, we keep buying it

I'll probably get a...

The problem isn't that DATEDIFF subtracts years... it's that it counts the number of times the date changes from 12/31 to 01/01.  Subtle difference but very important using other date...

Wasn't that lucky... it's 24/7.  We get to bounce the server once a week for "impacting changes" for about 30 minutes... then, QA get's to verify what we've done.  Of...

Yeah, I wish I didn't need it!  Wonderful 3rd party solution at work.  Bunch o' DB rookies... these are the same wonderful folks that built an Oracle-Like sequence table (NextID)...

Hang on there, Paully21, I'll get to you in a minute...

I absolutely agree with everyone that having CSV columns in a table is a basic form of "death by SQL". ...

LMBO!  Both at the design and your great sense of humor which allows you to calmly handle the mess they've heaped upon you!  I don't know about anyone else, but your...

Dang!  I must be old!  None of the newer online slang dictionaries has SOFH or BSOFH!  Remi, where did you find that definition?

Ok, ok... you got me... I've got dirt in my garden that's younger than I am... As you can tell, though, I've had...

Remi is correct... it takes the original description and wraps it in single spaces.  Basically, it allows this single search ('% myword %') to work on the following descriptions...

something myword...

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...