OK Sample:

create table YourBaseTable (

  pkey int primary key,

  col text

)

go

create trigger InsteadOf_Trigger_Example on YourBaseTable

instead of update

as

  if update(pkey)

   begin

   ...

De nada!

You're welcome

Select q.consultancybookingnumber, q.ConsultancyStateID, h.ConsultancyID

from

    (select consultancybookingnumber, max(consultancystateid) as ConsultancyStateID

     from ben_vw_consultancy_history

     group by consultancybookingnumber

    ) q

    join  ben_vw_consultancy_history  h

      on  q.consultancybookingnumber = h.consultancybookingnumber

      and q.ConsultancyStateID =...

as long as you don't have stored procedures of your own you should not need to restore master at all mdb files and ldb files should be sufficient because this...

I thought about that too and you can make it static by simply defining group date 0 as the earliest date in your db and increment from that to current...

Best bet for access violations is to send the minidump to Microsoft PSS.

Cheers, 

OR upgrade to SQL 2005 and create a simple DDL trigger

this is how you move system dbs (master, model and tempdb):

http://support.microsoft.com/kb/224071/

Ok Now I think I understand what you need.

If you can not persist the calculation some how you won't be able to use an index on the transaction_date nor on...

Ah... The "Performing Completition Tasks" hatred message

This is very related with the email subsystem that your SQL SERVER AGENT is using. it tends...

although a function like this:

create function dbo.WeekOfTheMonth (@date_in datetime)

returns tinyint

as

begin

 declare @Wknumber tinyint

 set @Wknumber = (datepart(wk,@date_in) - datepart(wk,dateadd(m,datediff(m,0,@date_in),0))) + 1

 return @Wknumber

end

It is in my opinion a lot better...

you can add the maximum sizes of the different datatypes  and that will give you a maximum record size.

If you already have the table created and some data in...

select  Task

       ,Sum( case when Quarter = 'Q1' then Hours else 0 end) Q1Hours

       ,Sum( case when Quarter = 'Q1' then Cost else 0 end) Q1Cost

       ,Sum( case when Quarter...

here is an example of how I would go about it:

Declare @Firstdate datetime, @LastDate datetime

select @FirstDate = dateadd( mm, -12 *10, '20063103'), @LastDate = '20063103'

Select      SUM(t.Transaction_Amount) as Amount

          , month(...

Some Pointers here:

1. All Dates should be converted to datetime variable prior to query execution.

2. Make sure you have indexes in your searched (and joined)  columns

3. "Distinct" is not necessary...