Sorry for not simplyfying it but I dont expect all to look at SQL.
It is just a Query which I am currently using @file.sql.

But My Front End users want it to run from VB as a . For that they want in Procedure. They say there is no way that @file can be run from VB.

In query there are many different queries and result has to be on one page. (Our user's are biggies ... they want everything in their formats)

Amol