> I'm looking to do as the topic says, I currently
> use temporary real tables (not #temp tables) that
> i keep in existence for just long enough for
> an access adp frontend to issue an output to excel
> command, and then it's dropped. The parameters are
> usually 2 dates to form a range or a few char fields.
> The cry for me to use views instead has been issued,
> and i'm investigating changing my select into queries
> into create view statements.
> My first problem is:
> "Server: Msg 111, Level 15, State 1, Line 4
> 'CREATE VIEW' must be the first statement in a query
> when i try a simple create view statement after
> defining a few variables. If i'm to issue go statements
> to get that working, i'll lose the definition of my
> So what are my options then, to use global variables?
> Further, does anyone know if the performance impact is
> worthwhile? The main reason for the change to views is
> to avoid the confusion of these tables with the permenant
> ones, but i'm curious about performance.
> thx ahead of time