We need to essentially run the same MS SQL script twice when we run the install... the only difference is the first few lines of the file.
The first time it needs to run <Static Lines 1> + <Dynamic Lines 1>
The second time it needs to run <Static Lines 2> + <Dynamic Lines 1>
We know all of these at compile time. We'd like to make this as convenient as possible. One way we could do it is to have a DOS batch file that creates these, but we're wondering if there's a better way.