I have to run extended operations on bulk records in the destination table. I thought Delete if exists, then Insert would be a possible solution, but the trigger is working some times and failing other times, and when it does fail, it cancels out the transaction on the original table resulting in data loss.

I know that part. But I need to create a View of some sort with 60 x 4 = 240 rows, I cant use Limit for both tables in a single query now, can i?

Hi, I have a sql server table with fields EmployeeID, Date, TimeIN, TimeOut, Remarks. Now there is a unique constraint on both EmployeeID and Date such that only one record exists for a particular Employee on a particular date. Now the main application can insert and update records. I need a trigger to track changes such that on insert or update, the values are copied onto a data_log table. Here is the problem, I need the trigger to check if the row exists in data_log for that EmployeeID and Date, then update, else insert. So there should be only one record of each employee per date in the data_log table as well. I just want the most current change and need to overwrite previous log entry. thanks

Hi, I have two mysql tables with large amount of data. Table_1 has fields PropID, FullStreetAddress, City, State, Zipcode, Remarks, Date which I want to pick. Table_2 has PropID,URL. Now I want to pick top 60 rows from table_1 order by date desc. Each PropID has several URL records in Table_2. Out of those records, I need to pick only 4 for each PropID in table_1. So in effect I would get a result set of 60 x 4 = 240 rows. Selecting from table_1 and inner joining on PropID in table_2, I am getting a complete result set, but I need to limit that somehow to get 60 rows from table_1 and 4 rows for each of the 60 ids from table_2 in a single query. thanks.

Hi, Thanks for the prompt response. Will try it out. Cheers.

Hi, I have a list of urls from where I need to download images. The images are being served from a database. Here is a sample url: http://csmedia.mris.com/platinum/getmedia?ID=90217207979&LOOT=50045650620[^] Since it is not an absolute path to the image, I am having trouble with it. Need your valuable expert guidance on a C# function to download image from the urls of the type above. thanks.