Hi Mahesh, > Is there a easy way to compare records of these 2 > Recordsets? ...if theres a field called FName in RS1 > that has 4 records and a field called FName in RS2 > that also has 4 records then I want to compare them > and see if the records are matching or not (regardless > of the order in which they are returned).
Are you wanting to only return records that are the same on both recordsets, or are you wanting to return a complete listing (side by side fields) where certain fields are equavalent, or are you wanting to return only records that don't have an equivalent record in the other table? All of these would have different implementation requirements. It really depends on exactly what you want. For the greatest control, you'd probably want to return both complete recordsets as arrays and compare the values programmatically or via XSL. The SQL to compare them directly from the database would be dependent on what db platform you use. Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== "There's a certain enjoyment to be gained from humiliating your friends." -- Guy Ritchie ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
