Re: [SQL] Problem with SQL stored procedure

2006-12-08 Thread Shoaib Mir
Wrong mailing list to ask this :-) Try out a MS SQL Server one and you will get good help on that... Regards, Shoaib On 12/8/06, sid tow <[EMAIL PROTECTED]> wrote: Hi all I dont know if this is the right forum to post this but any way if you could help me or guide me to an appropriate

[SQL] Problem with SQL stored procedure

2006-12-08 Thread sid tow
Hi all I dont know if this is the right forum to post this but any way if you could help me or guide me to an appropriate forum, I would appreciate it. I am trying to call a SQL (SQL server 2000) stored procedure from my c++ code and in that stored procedure I have a Print statement whic

Re: [SQL] problem with sql

2003-10-25 Thread Michael Glaesmann
Hi Adam, On Monday, Oct 20, 2003, at 01:56 Asia/Tokyo, Adaś wrote: status. I made a query using LAST and GROUP BY to select last order for each customer and I wanted to use it in UPDATE query, but it seems to be impossible. I don't believe PostgreSQL has a built-in function similar to MS Access

[SQL] problem with sql

2003-10-24 Thread Adaś
Hello to everyone, In my own database, I linked customers table with orders table using one-to-many relation. I need to check status of last order for each customer and then set customer's status. I made a query using LAST and GROUP BY to select last order for each customer and I wanted to use

Re: [SQL] Problem with SQL query (eats swap)

2000-08-11 Thread Tom Lane
[EMAIL PROTECTED] (Mailing List Expander) writes: > select count(*) from attachments a where a.id in (select m.id from > mail m where m.date < now()-62); > but ran out of swap. The problem is that "now()-62" leaks memory to the tune of a few dozen bytes per evaluation. In existing releases that

[SQL] Problem with SQL query (eats swap)

2000-08-10 Thread Mailing List Expander
Hi, I have two tables into which I dump mail statistics. The two tables are: create table attachments ( id text, attachment text ); create table mail ( id text, size int, whofrom text, subject text, date datetime, inout char ); The table mail holds information about each mail me