What do you mean by pseudo-code? I want to delete records from the rt_edt table everytime an update occurs. The updated data first comes into the rt_edtstaging table as one...

Thanks. Assuming that the delete was working, where could I put it in the code above so that all data for a particular 'mid' is deleted  from rt_edt before the...

You do have the right idea!  Your comments above have prompted me to do further testing. I just have to wait for the next...

Thanks Remi. I know that I need to delete all the data from the rt_edt table prior to going into the cursor to ensure that there is no duplicate target...

The data being parsed in from the rt_edt staging file looks like this:

Thanks for the suggestions Remi. But it should only be deleting records based on the current value of 'mid'.

The rt_edt table is used to store data for real-time updates...

Thanks all. I used DBCC CHECKIDENT, as suggested by PhilPacha, to look for the last identity value used and then incremented that value. Your feedback was greatly appreciated!

It is a varchar and your example above did not seem to work. The error returned was :

"Syntax error converting datetime from character string."

and the code I used was:

set @newdate...

Sorry about the mispelling in the previous post. None of the above seems to be working. It does work from the command line though:

G:\cnd_reports\JmailAirCND.exe BKSF05-145 5/9/2005 104445

Could this be...

The G drive is local to the machine and these are the results when I ran:

EXEC master..xp_cmdshell "DIR G:\"

 Volume in drive G is DATA

 Volume Serial Number is 5010-1ECA

NULL

 Directory of...

Thanks SRB and scking. You have been a great help. That SQL Digger Application is sweet!

Yes, I only concerned with the time portion of date/time.

Thanks Noel. You are da man!

Ooops....sorry Noel...forgot to answer your question. I am trying to generate a simple checksum for the number that is being passed into a stored procedure that I have created.

Thanks Noel, but your function did not seem to work for my purposes. I am looking for a function to sum all the values in the number 462304.94. ie. the...