Bottom line, syntax error should be the correct answer. I saw the infinite loop, but figured that was a rouse to hide the fact that there were no "go" separators...

sknox (12/30/2010)

---

Daniel Ruehle (12/30/2010)

---

... case

when Age > 90 then 1

when Age < 5 then 0

when Gender...

Gianluca Sartori (12/30/2010)

---

Daniel Ruehle (12/30/2010)

---

One easy way to make sure short circuiting works the way you want it is using case statements:

select

*

from

Person

where

1 = 1

...

One easy way to make sure short circuiting works the way you want it is using case statements:

select

*

from

Person

where

1 = 1

and CreateDateTime >...

The main issue with using the "Log to table" option without the "Append" option is that each execution overwrites the previous output. If you have a job that executes...

Could you not have just added:

set transaction isolation level read committed

after the "set nocount on" in the trigger to set the isolation level for the duration of the trigger execution....

What if someone sells a product whose only purpose is to kill people? Should they be shut down?

Definately not!  Gun manufacturers should certainly not be shut down because they sell...

Couldn't you simply create a function:

create function dbo.fnViewDate()
returns datetime
as
declare @ret datetime
select @ret = date from tableA where id = host_id()
if @ret is null set @ret = getdate()
return @ret
go

and then your...