Calling a query from another query using Query Analyzer

[supermama]

A have read a lot and did not found how to do this.
I know I can execute a sp with exec (sp_whatever)
I just want something like that but with queries. I need to call or execute a query (*.sql) from another query code (*.sql). Something like this (guessing...!)


use pubs
select * from authors
go

call (library) --where 'library' is another query (library.sql)

Thank you for your help!!

'Love T-SQL'

 

[JamesLean]

Put whatever script is in the .sql file into a stored procedure and just call that.

--James

 

[Glyndwr]

supermama


if you wish to execute sql batched in text files then I suggest you look at the osql or isql command line utilities.

 

[supermama]

Thank you James. That was the first thing I thought too, but I'm trying to avoid sp...

If there's no other way to do that, I will have to go to sp's...

'Love T-SQL'