Good call....

Take a look at this, courtesy of Jeff Moden:

http://www.sqlservercentral.com/articles/TSQL/62867/

Why would you do something like this?

Heh, good, I kept trying it and didn't get...

The word "Table" is a keyword. Try using something like MyTable instead.

Can you guarantee that all error codes are exactly 3 digits in length?

For the future, when someone asks for table structure / data, please post it like this:

[font="Courier New"]CREATE TABLE Table1(

fname VARCHAR(50),

lname VARCHAR(50),

error_code VARCHAR(100))

CREATE TABLE Table2(

err_cd VARCHAR(50),

err_msg VARCHAR(100))

INSERT INTO Table1(fname, lname, error_code)

SELECT...

My edit went through after your post. Please also provide sample data as so. Make sure you include data that will demonstrate the double entry issue.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Beautiful, thank you sir.

That depends on what you'd like to happen in the case that they don't supply either value.

[font="Courier New"]

SET @body =

'The system has detected the following event: ' + CHAR(10) + CHAR(13) +

'SQL Alert Notification: No Activity ' + CHAR(10) + CHAR(13) +

'Date time:' + CAST(@TimeStamp AS...

Please post your table layouts for us to give you an example query. What you are looking for is just going to be a very simple join, but without...

Off Topic:

Chris, how are you getting your SQL code color coded rather than all Black and White?

Indeed it does. I was using the _ to ensure that nothing wacky happened with the Querystring, but SQL handles the %20 just fine. Thanks Jack.

Write an Update statement with REPLACE(column,'"','') for each column.

That replace is: REPLACE ( column, ' " ', ' ') in...