Create 2 views in one query batch file 1

[MrBillSC]

I want to create view A then read view A and create view B.
When I try to do this within a single query batch file I get an error at my second "create view" statement that says "'CREATE VIEW' must be the first statement in a query batch."
Do I have to create these views with separate query batch files? Since view B is based on view A it would be nice to create them in the same query batch file.

I am using SQL Query Analyzer version SQL 8.00.194

MrBill

 

[JackVam]

Have you got GO between the various segments
e.g
CREATE VIEW 1


GO


CREATE VIEW 2

Jack Vamvas

All the IT jobs in one place -

http://www.ITjobfeed.com

 

[MrBillSC]

Perfect.

MrBill