A little bit of thinking could bring you to a conclusion that you probably need to do this conversion not only for dates...

Write INSERT statement in QA.

And many people find an idea of developing front-end applications for entering data quite brilliant.

Any clue why?

You need to explicitly convert DATETIME variables to VARCHAR before you use it in concatenation for PRINT or anything else.

Otherwise Server is trying to convert all VARCHAR variables to dattime.

And...

As a novice you should start from reading manuals.

Open BOL ("help" in SQL Server), find topic "FROM clause (described)" and read how to use joins.

It has good definitions, explanations, examples,...

The point here is: guys developed (and keep developing) systems which don't work without manual...

net,

terrible design remains terrible design regardless who and when has done it.

If you need to do 100 tables you need 100 triggers, one extra field in your tracing table...

Just keep in mind: NULL must be unique as well.

You can have error handling and update status only if after sending email @@Error remains = 0.

It's something my fingers can do even I'm asleep:

F1 -> C+A+S+T -> Enter -> Enter

🙂

How about this:

SELECT c.fname, c.lname, moc.value AS PHONE

FROM CHARs C

INNER JOIN MeansOfCommunications MOC

ON c.id = moc.CHARacter

...

It works perfectly for all datatypes allowing implicit conversion to SQL_VARIANT.

This is true for almost all datatypes excluding timestamp, image, text and ntext.

It will fail for those types.

And for...

Wow!

Guys, honestly, instead of cursing politics and auditors you should pay more attention to the quality of your applications.

Can you imagine: some people deploy their projects on Client's site totally...

Sorry you cannot send this private message.

• The recipient has already exceeded their permitted number of private messages.

Jeff, it's about you. :blink:

I guess your problem is terrible design.

Can you post DDL for your "many tables" to give us an idea what is it about.

And post one of your triggers. I'm pretty...

Not really - still has to work. :laugh: