ScottPletcher (8/29/2014)

---

j_depp_99 (8/29/2014)

---

thanks much for your response. Testing it now but not sure about the variable. What does this represent? ?

Msg 207, Level 16, State 1, Line 8

Invalid column...

ScottPletcher (8/28/2014)

---

Something like below. I don't have test data, so haven't tested it yet.

Edit: The WHERE conditions on your original query caused the LEFT JOIN to become a de...

USE tempdb;

GO

/* Test data */

WITH SYNCHMESSAGE (M_KEY,M_MSG) AS

(

SELECT

M_KEY

,M_MSG

...

thanks much for your response. Testing it now but not sure about the variable. What does this represent? ?

Msg 207, Level 16, State 1, Line 8

Invalid column name 'KEY'.

Msg...

Is there a way to set your column width to fixed positions so that one is not taking most of the space?

I made the changes as far as the clustered and non-clustered indexes and the data field types. Just restarted everything and wasn't too long before I got the timeout...

wow you guys are awesome in response times:

so here goes -- I have less than 2 years experience so forgive the odd errors in design.

- The MD5 hash key was...

Thanks to everyones responses..

- I can only insert one record at a time since I need to know whether that record already exists in my DB table before I write...