I need to read a Microsoft sql db table record one at a time (first in first out). we have Field1 with time stamp of insert of record into table. we have Field2 with value 'N". I need to pick the oldest record of table first with Value "N" on the basis of Field1 and Field2.
Can you advise the SQL query for this requirement ? I have a business requirement where in I need to read only one record at a time, and I am not explaining that business requirement here. I have batch job scheduled and will run every 5mins.
Thanks in Advance
kandimal