[Dbix-class] subquery insert for MSSQL

[Peter Rabbitson]

On Wed, Jul 22, 2009 at 09:30:19AM -0500, fREW Schmidt wrote:
> 
> Indeed.  The following works:
> 
> 
> > INSERT INTO WorkScopeOperations (
> >    department,
> >    description,
> >    id,
> >    signature_required,
> >    work_order_id,
> >    work_scope_id
> > ) SELECT
> >    ?
> >    '?,
> >    MAX(id) + 1,
> >    ?,
> >    ?,
> >    ?
> >       FROM WorkScopeOperations me
> >       WHERE ( ( work_order_id = ? AND work_scope_id = ? ) )
> 
> 
> 

I don't quite follow... What are the bind values that the top placeholders
take? Also '?, seems to be a typo... I think.