Simple thing
I need to create 2 queries depending on criteria entered by the user and then to create a final query joining the first two queries.
My first query : the number of Non-conforming parts.
My second query : the number of parts delivered
These queries depend on criteria selected such as customer, parts group/family etc ..
Then I need to create a query which divides the number of NOK parts by the the No of parts delivered for each specific categories/groups.
In Access, I used the CreateQuerydef to create the first two queries in Access and then called them in the sql statement of the final query by using the querydef names. created.
How to perform this in ASP : do I have to create stored procedure and if yes, how to do that.
Thanks
I need to create 2 queries depending on criteria entered by the user and then to create a final query joining the first two queries.
My first query : the number of Non-conforming parts.
My second query : the number of parts delivered
These queries depend on criteria selected such as customer, parts group/family etc ..
Then I need to create a query which divides the number of NOK parts by the the No of parts delivered for each specific categories/groups.
In Access, I used the CreateQuerydef to create the first two queries in Access and then called them in the sql statement of the final query by using the querydef names. created.
How to perform this in ASP : do I have to create stored procedure and if yes, how to do that.
Thanks