From Google:

50 First Dates (2004)

FWIW, the code ran just fine for me against one of my development databases.

Remi,

This zip code format is referred to as zip plus 4.  All us addresses have a zip + 4 code but it is only commonly used in commercial applications.  Its purpose...

Well...just a little...but that's ok.

I'd just looked at my triggers and at least I didn't make that mistake there!

duh! Thanks

Was there something wrong with my post??

I'm always open to suggestions for improvement.

Show off

Your trigger updates all rows becuase your update statement has NO where clause.  The Select is just hanging out there attached to nothing.  You might be looking for something like this.

I get '1/1/1900' for null dates using that suggestion.  I think this does the trick.

declare @testdate datetime

set @testdate = getdate()

Select Isnull(CONVERT(varchar(12), @TestDate,101),'') as MyDate

set @testdate = null

It can be handy with cast/convert when you are not sure of the length of the result.

select convert(varchar, getdate(),110)

------------------------------

06-06-2005

(interesting anniversary)

Update will modify existing row(s).

There's always an exception

char and varchar

Fixed-length (char) or variable-length (varchar) character data types.

char[(n)]

Fixed-length non-Unicode character data with length of n bytes. n...

After --> TRUNCATE TABLE esi_auto_label there are no rows in the table to update.

UPDATE esi_auto_label ...

Alex I think you are looking for something like this:

Select a.value, b.value, c.value

From events e

Join Cust a

  On a.custId = e.custId

And CustomFormFieldDefinitions.fieldid = 2540

Join Cust b

  On b.custId = e.custId

And...

"...In fact the only thing I am doing is sub-queries within the main query

i.e. select x, (select y from table2) from table1..."

I'm thinking that a Select from more than one...