I agree with all of the negatives posted here.

Only one positive thing that I know of:

A query that is built up in a scripting language can end up being cleaner...

This should work:

WHERE (dbo.tblConVendtoSuperClient.VendorID = 199)

AND (dbo.tblvendor.vendorid <> 123)

and (dbo.tblVENDOR.VendorName=@Attorneyrname)

and ((@Report_Parameter_1='Forclosure' and dbo.tblRAIL.lkpRailid = 1)

  or (@Report_Parameter_1='Bankrupcy' and dbo.tblRAIL.lkpRailid = 2))

A co-worker tracked down the problem to one of the DLLs in C:\Program Files\Common Files\System\Ole DB becoming unregistered. He reregistered all of the DLLs and the problem was resolved. Don't...