You bet... thanks for the feedback. Gotta love those "3rd party vendors". 😛 Only reason I knew how to do this is because I had to fix one...

winston Smith (11/6/2007)

---

this seems to work, however id like to know why my join didnt work. it just kept running and running until i killed it after 8 minutes. anyone...

Henry Omodara (11/6/2007)

---

I got put off by the charge myself. I am always looking for good people for the Canadian Market with real openings. If you are interested, please send...

Not to over simplify too much... but why don't you just use CASE statements?

Ummm.... how does putting it into extended properties make it any more accurate than putting it in a header comment? Sure, I understand it make it more accessible, but...

The SSIS package should be able to check if incoming rows already exist previously, perform updates if there were changes on any columns, and insert a new row if data...

True enough... and nicely done. I was being a bit sarcastic because the OP didn't want to use a stored procedure... I went a bit overboard with a way...

Duplicate post...

http://www.sqlservercentral.com/Forums/Topic419299-266-1.aspx

If you have a table that looks kinda like this called "yourtable"...

CREATE TABLE yourtable (ProductName VARCHAR(10), SubmissionID INT)

INSERT INTO yourtable

(ProductName,SubmissionID)

SELECT 'AAA',123 UNION ALL

...

Heh... this reminds me of doing volumetric rotations in Calc II... instructor was busting our chops about how he could do immensely accurate calcs to calculate the amount of material...

Heh... yeah, and I absolutely agree... the "proper documentation" fairy got on my shoulder, again.

Sure it's easier... that's not the name of the game... name of the game is nearly-continuous availablity of the data... depending on the size of the table, you may have...

A really great way is to include some revision history in the header comments of the proc... you know... the same place where you identify what the proc does, what...

Do you mean that you need to drop the time before you compare? If so...

WHERE DATEDIFF(dd,Table1.TimeStamp1) = DATEDIFF(dd,Table2.TimeStamp2)

Do be aware that because you have column names in formulas, there...

Yes... it's \"... if you want to depict "," (quotes included), the delimiter would be identified as "\",\"" in the format file. But, beware... the first quote in the...