Re: Embed a string in a string

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 21 Jun 2009 13:07:43 +0200
Message-ID: <41d4e$4a3e147f$524b9d64$13634_at_cache6.tilbu1.nb.home.nl>



martinamullin_at_yahoo.ie wrote:

>
> declare _at_WarehouseSQL nvarchar(100)
>
> select _at_WarehouseSQL = ' select distinct rqpropno
> from vi_MAItems where val_lvl <> MEZZ '
>
> exec(_at_WarehouseSQL)
>

Time to read up on Oracle and PL/SQL - not MicroSOft server and TSQL

-- 

Regards,
Frank van Bortel
Received on Sun Jun 21 2009 - 06:07:43 CDT

Original text of this message