Oh, you've already found out while I was typing

More than one way to skin that cat. Personally I prefer

IF OBJECT_ID('authors') IS NOT NULL

 PRINT 'Hello World'

However, Chris and I were focusing on your incorrect use of OBJECTPROPERTY. This should...

and OBJECTPROPERTY(id, 'Customers') = 1)

Which OBJECTPROPERTY are you interested in? "Customers" ?

You should do as Antares already suggeted. And once you're done, define a proper PRIMARY KEY on that table, so that you don't run into the same issue again one...

As Brian already said, one might be inclined to think that this is a test question, you should really answer yourself. It will yield you nothing, if you can provide...

Can you offer any reason why this column shouldn't even exist, other than it can be calculated from 2 others on demand (if reporting required it)?

Isn't that reason enough?

Let me see if I have what it does straight: datediff returns the integer number of days since "day 0" for the smalldatetime value in question. dateadd takes that integer,...

Don't know if it helps in your case, but here goes:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Btw, looks like perfect weather for a ride.

What are you trying to catch with

 if @@rowcount > 0 begin

in the UPDATE part? @@ROWCOUNT will take the value of the last statement executed, so in your case

select @loc_id =...

Geeh, I should have known before...

Well, first I would consider breaking this up into three separate triggers. Not only does this encapsulate the logic a bit more but it also...

Hm, it might be helpful to see the code.

See if this helps:

http://www.umachandar.com/technical/SQL6x70Scripts/Main47.htm

CAST(dateadd (d, 0, datediff(d, 0, getdate())) AS SMALLDATETIME)

This CAST is not needed I think, since you've already set the time to midnight and are only interested in the date stuff...

I don't think you should place this into your DDL. This information becomes only interesting when you request it and then it is very easy to calculate this in a query....

I'll keep my fingers crossed!

I don't know what the situation is like over there, but here at times I'm inclined to think that it's not a matter of course to...