X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 13133D1BA13 for ; Mon, 23 Feb 2004 08:33:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01149-10 for ; Mon, 23 Feb 2004 04:33:11 -0400 (AST) Received: from ind-iport-1.cisco.com (ind-iport-1-sec.cisco.com [64.104.129.9]) by svr1.postgresql.org (Postfix) with ESMTP id 5612AD1B8F2 for ; Mon, 23 Feb 2004 04:33:08 -0400 (AST) Received: from india-core-1.cisco.com (64.104.129.221) by ind-iport-1.cisco.com with ESMTP; 23 Feb 2004 19:37:51 +0530 Received: from cisco.com (charminar.cisco.com [192.135.240.11]) by india-core-1.cisco.com (8.12.10/8.12.6) with ESMTP id i1N8WwWT020032; Mon, 23 Feb 2004 00:32:58 -0800 (PST) Received: from sbiswasw2k01 (dhcp-10-77-21-42.cisco.com [10.77.21.42]) by cisco.com (8.8.8-Cisco List Logging/8.8.8) with ESMTP id OAA24910; Mon, 23 Feb 2004 14:01:10 +0530 (IST) From: "Sumita Biswas" To: "'Tom Lane'" Cc: Subject: EXECUTing QUERY: Date: Mon, 23 Feb 2004 14:03:05 +0530 Message-ID: <003501c3f9e7$a8699840$2a154d0a@apac.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 In-reply-to: <20409.1077506948@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/384 X-Sequence-Number: 17074 I had the following code in an MSSQL Stored Procedure: SET @QueryToPopulateTemp= "INSERT INTO #Tmp_Conference(ConferenceType, CallManagerId, ClusterId, DestConversationId, ConnectDate, FinalDestination)" +" SELECT 1, Global_CallId_CallManagerId, globalCallId_ClusterID, DestConversationID, StartDate = MIN (Connect_Date), Final_Destination " +" FROM Tbl_Billing_Data WHERE (connect_date BETWEEN '"+ cast(@ld_FromDate as NVARCHAR) +"' AND '"+ cast(@ld_ToDate as NVARCHAR) +"' OR disconnect_date BETWEEN '"+ cast(@ld_FromDate as NVARCHAR)+"' AND '"+cast(@ld_ToDate as NVARCHAR)+"') AND DestConversationID <> 0 AND Call_Type='" + @lv_Adhoc_Conf + "'" +" GROUP BY Global_CallId_CallManagerId, globalCallId_ClusterID, DestConversationID, Final_Destination order by startdate"; EXEC sp_executesql @QueryToPopulateTemp; ------------------------------------------------------------------------ ------------------------------------------------- I have changed it to the following in the Postgres Function: QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType, CallManagerId, ClusterId, DestConversationId, ConnectDate, FinalDestination)'' +'' SELECT 1, Global_CallId_CallManagerId, globalCallId_ClusterID, DestConversationID, StartDate = MIN (Connect_Date), Final_Destination '' +'' FROM Tbl_Billing_Data WHERE (connect_date BETWEEN ''''+ cast(ld_FromDate as NVARCHAR) +'''' AND ''''+ cast(ld_ToDate as NVARCHAR) +'''' OR disconnect_date BETWEEN ''''+ cast(ld_FromDate as NVARCHAR)+'''' AND ''''+cast(ld_ToDate as NVARCHAR)+'''') AND DestConversationID <> 0 AND Call_Type='''' + lv_Adhoc_Conf + '''''' +'' GROUP BY Global_CallId_CallManagerId, globalCallId_ClusterID, DestConversationID, Final_Destination order by startdate''; PERFORM QueryToPopulateTemp; ------------------------------------------------------------------------ ------------------------------------------------- Does this look fine? Regards, Sumita