[dba-SQLServer] Converting Access nested queries into SPs

Use derived tables. They work great.


At 12:00 PM 10/12/2008, you wrote:
>Date: Sun, 12 Oct 2008 17:18:16 +1300
>From: Stephen <stephen at bondsoftware.co.nz>
>Subject: [dba-SQLServer] Converting  Access nested queries into SPs
>To: dba-sqlserver at databaseadvisors.com
>Message-ID:
>         <569E08FC48047F4F848850B118195FBE03834C at server.BondSoftware.local>
>Content-Type: text/plain; charset=us-ascii
>
>
>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