[GENERAL] How to debug efficiently

Hi All In SQL Server I could copy sql code out of an application and paste it into SSMS, declare & assign vars that exist in the sql and run.. yay great debugging scenario. e.g. (please note I am rusty and syntax may be incorrect) declare @x as varchar(10) set @x = 'abc' select * from sometable

[GENERAL] Merge data from two databases

Hi There We have a stats databases which has been dumped out a few times over the last year. What i would now like to do is to merge these dumps into one database. The problem is is that when the dumps were done, a drop and create was carried out on the database so primary key columns will

[GENERAL] SSIS and Postgres

Hi there we are having some problems using OLEDB PGNP and SSIS, this is a post we have added to experts exchange, but we were wondering whether anyone here could shed some light on this. We are also interested how others manage ETL Cheers Jamie Data Warehousing Postgres We're

Re: [GENERAL] Postgres and multiple updates in one statement

thanks Jamie -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of nha Sent: 27 July 2009 14:35 To: Jamie Lawrence-Jenner Cc: PgSQL-general Subject: Re: [GENERAL] Postgres and multiple updates in one statement Hello, Le 27/07/09

[GENERAL] Postgres and multiple updates in one statement

Hi there We have a function which runs a set of update clauses and we are considering putting all the update clauses into one statement. I would like to understand how postgres handles multiple updates. If we were to send 5 update statements in one sql statement to the db would it: Do 5