Quote:
Originally Posted by tcliam
I have about 15 Ms SQL store procedures that all use a temporary table like this.
|
Strange strategy...
Quote:
|
As for the above query the two select statements are doing similar things however they are using different parameters.
|
Makes more sense
Quote:
I have actually posted the function with the wrong parameter in the first query.
Heres how it should look using the parameter "RenewFromSchemeProjID", which I think will make having one query more complicated.
|
Not at all, just move the query for the temp table inside the main query as shown in my first example.
Temp tables might be a good choice for MS SQL Server, but they are not for Postgres (or Oracle that is)