...
>is the SQL much faster?
>is it better in any way?
>does it give the same result?
>are there any advantages at all in using the old system?

Hi Rakesh,

To add to what Sylvain said, if you ever move your data to SQL Server you can more easily upsize the code into a stored procedure or whatever.