[dba-SQLServer] Converting Access nested queries into SPs

Stephen stephen at bondsoftware.co.nz
Sat Oct 11 23:18:16 CDT 2008


I am converting an Access system to SQL-S back-end and Access front-end.

Presently converting the queries into SPs. I use nested queries a lot -
the lower levels form commonality for other specific higher level
queries. Is there a way I can build SPs in this nested fashion without
having to specifically repeat the lower-level code each time in the
higher-level SP?

Stephen Bond
Otatara
New Zealand





More information about the dba-SQLServer mailing list