[dba-SQLServer] Converting Access nested queries into SPs

Stored procedures can also call other stored procedures.Nancy Lytle N_Lytle at terpalum.umd.edu



 EMAILING FOR THE GREATER GOODJoin me

> Date: Sun, 12 Oct 2008 17:18:16 +1300> From: stephen at bondsoftware.co.nz> To: dba-sqlserver at databaseadvisors.com> Subject: [dba-SQLServer] Converting Access nested queries into SPs> > > 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> > > _______________________________________________> dba-SQLServer mailing list> dba-SQLServer at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> http://www.databaseadvisors.com>