subject:"\[SQL\] Converting Query from MS SQL"

Re: [SQL] Converting Query from MS SQL

2003-10-06 Thread Richard Huxton

On Monday 06 October 2003 14:04, Kumar wrote: > Dear Friends, > > I am working with Postgres 7.3.4 on RH Linux 7.2. While migrating all the > SPs (from MS SQL Server), I come across these lines in MS SQL Server > procedure. > > SET @v_sql = "UPDATE "Schema1".employee SET rec_deleted_flag = 'Y' WHER

[SQL] Converting Query from MS SQL

2003-10-06 Thread Kumar

Dear Friends, I am working with Postgres 7.3.4 on RH Linux 7.2. While migrating all the SPs (from MS SQL Server), I come across these lines in MS SQL Server procedure. SET @v_sql = "UPDATE "Schema1".employee SET rec_deleted_flag = 'Y' WHERE empid IN (" + @p_list_ids + ");" EXEC(@v_sql)