--I added these just to test syntax
declare 	@FeedID int
		,@FeedDataTitle int
		,@FeedDataLink int
		,@FeedDataDesc int
		,@FeedDataDate int

-- WE WILL UPDATE THE RECORD AND THEN CHECK TO SEE HOW MANY ITEMS WERE UPDATED
UPDATE RSS_Feeds_Data SET 
	Data_DateCreated = Date 
WHERE	Data_Desc_Checksum = binary_checksum(substring(@FeedDataDesc,1,8000)) 
AND	Data_Title_Checksum = binary_checksum(substring(@FeedDataTitle,1,4000))

if @@rowcount = 0
begin
	-- LETS ADD THIS RECORD
	INSERT INTO RSS_Feeds_Data 
		(Data_FeedID
		,Data_Title
		,Data_Link
		,Data_Desc
		,Data_DateCreated) 
	VALUES 
		(@FeedID
		,@FeedDataTitle
		,@FeedDataLink
		,@FeedDataDesc
		,@FeedDataDate)
end
else
begin
	-- LETS MAKE SURE THERE IS NOT MORE THEN ONE RECORD
	if @@rowcount > 1
	begin
		-- LETS DELETE SINCE THERE IS MORE THEN 1 RECORD UPDATED
		DELETE 
		FROM	RSS_Feeds_Data 
		WHERE	Data_Desc_Checksum = binary_checksum(substring(@FeedDataDesc,1,8000)) 
		AND	Data_Title_Checksum = binary_checksum(substring(@FeedDataTitle,1,4000))

		-- LETS ADD THIS RECORD
		INSERT INTO RSS_Feeds_Data 
			(Data_FeedID
			,Data_Title
			,Data_Link
			,Data_Desc
			,Data_DateCreated)
		VALUES 
			(@FeedID
			,@FeedDataTitle
			,@FeedDataLink
			,@FeedDataDesc
			,@FeedDataDate)
	end
	else
	begin
		-- WE ARE NOT GOING TO DO ANYTHING SINCE THERE IS ONLY 1 RECORD THAT WAS UPDATED
		raiserror('Record already exists', 10, 1)
	end
end

strSQLString = strSQLString & "SET ARITHABORT ON" & vbCrLf
strSQLString = strSQLString & "EXEC usp_InsertFeedData 1, 'Brad', 'http://www.brad.com/default.xml', 'Brads test', '6/30/2005 11:45:32 PM';"
my_Conn.Execute (strSQLString)

quote:

---

Stored procedures execute with the SET settings specified at execute time except for SET ANSI_NULLS and SET QUOTED_IDENTIFIER. Stored procedures specifying SET ANSI_NULLS or SET QUOTED_IDENTIFIER use the setting specified at stored procedure creation time. If used inside a stored procedure, any SET setting is ignored.

---

set ANSI_NULLS on
set ANSI_PADDING on
set ANSI_WARNINGS on
set ARITHABORT on
set CONCAT_NULL_YIELDS_NULL on
set QUOTED_IDENTIFIER on
set NUMERIC_ROUNDABORT off

--The insert statement...

--Or this?

UPDATE RSS_Feeds_Data SET 
	Data_DateCreated = '6/30/2005 11:45:32 PM' 
WHERE	Data_FeedID = 1

--OR This?

UPDATE RSS_Feeds_Data SET 
	Data_DateCreated = Date 
WHERE	Data_Desc_Checksum = binary_checksum(substring('Brads test',1,8000)) 
AND	Data_Title_Checksum = binary_checksum(substring('Brad',1,4000))