Sorry for me to be the bad news bearer

But is is really important that you patch that server ASAP

declare @sql varchar(1000), @x varchar(10)

set @x = 'field'

set @sql = 'update table set column = ''' + @x + ''''

exec(@sql)

But I don't see a way to order it the way you want

select *

from #EmpAges

where age between (@age - @Diff) and (@age + @Diff)

order by abs(age - @age) , age

All you need to do is a join of the the two like:

Select Normal.PERSONFULLNAME,PERSONNUM,Unit,Department,ApplyDate,Total,TotalAccrossDept

FROM

(

select PERSONFULLNAME,PERSONNUM,Unit,Department,ApplyDate,SUM(Regular) Total from VP_KSS_Overtime

 where

  ApplyDate between CURRPAYPERIODSTART and CURRPAYPERIODEND

group by PERSONFULLNAME,PERSONNUM,Unit,Department,ApplyDate

) Normal

join

(

select PERSONFULLNAME,...

Here is a bit of explanation for you:

Nested triggers is a setting that by default is turned off and what it does is

that if an update happens in the...

Ok, First things first:

This is basically the trigger you need:

ALTER TRIGGER TriggerOne ON YourTable

AFTER  Update

AS

Update S set ModifiedDate = GetDate()

  FROM YourTable S

    JOIN Inserted I

      ON I.ID = S.ID

Let me try to understand what you expect as output:

PERSONFULLNAME

,PERSONNUM

,Unit

,Department

, TOTAL NUMBER REGARDLESS THE DEPARTMENT ???

if not that can you post an example on how you want the output to...

I haven't promised anything ... yet

I am also as an employee as you are. Even though I do consulting on the side. If I get to see that the consulting...

select Employee, sum(Hours) Total  from Table group by Employee

where is the problem ???

RTM = Release To Manufacture.

You have the original retail version of SQL server installed you need to at least go to SP3a or SP4 if you can!!!

Cheers!

Sushila-- don't need to thank me it feels good when you put peoples perspectives on the line and make the right thing

Remi --...

Sorry to hear that, because

1. is Free

2. is proven

3. is easy to use

4. not intrusive

5. self contained

but well it was a shot!

Not so sure you wouldn't... those monster tend to pay big $$$

even when the Drs only provided all the necessary info after 5 -...

I just wouldn't want to be the guy who has to fill 112 fields to add a student.

I worked once for a pharmaceutical company and the Clients were Drs....

may I ask what SP level is your server running?

select serverproperty('ProductVersion'),serverproperty('ProductLevel')