The following Query string , when executed does not give an Error, even though the table Tbl_Billing_Data is not present.
QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType, CallManagerId, ClusterId, DestConversationId, ConnectDate, FinalDestination)''+'' SELECT 2, Global_CallId_CallManagerId, globalCallId_ClusterID, DestConversationID, StartDate = MIN (Connect_Date), Final_Destination ''+'' FROM Tbl_Billing_Data''; PERFORM QueryToPopulateTemp; I some how feel that the Query is not getting executed at all, otherwise its sure to give an error. So can you please comment what would have gone wrong? Regards, Sumita ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]