Hi This is the query :

SELECT r.rim_identification_no, rmad.rim_manufacturer_name, rsize.rim_size, rstat.rim_status,t.serial_no, tman.tyre_manufacturer_name, tsize.tyre_size, ...

Thanks a lot.. for ur help..

But my problem is still there..

Anyway I wrote the query...

Thank you for your reply..

But I couldnt find sp_compile in my SQL Server databases..

Where I can find that ?

Thanks,

KYSC