[SQL] Stored Procedures returning a RECORD

g returned is in the web pages" SQLState: 08S01 Native Error Code: 1 Error while executing the query; ERROR: cannot display a value of type record"     Kent Anderson EZYield.com 407-629-0900 www.ezyield.com   This electronic message t

[SQL] Ordering a record returned from a stored procedure

doesn't seem to read the "sort" variable.   Any help would be appreciated.   Kent Anderson

Re: [SQL] Ordering a record returned from a stored procedure - date issue

;$2" at character 982) yield_date = '' || '' || submissiondate || '' || '' (returns ERROR: column "submissiondate" does not exist) FOR result IN EXECUTE ''SELECT (. select all necessary fields ...) FROM ( tables ...) WHERE hm

Re: [SQL] Ordering a record returned from a stored procedure - date issue

Never mind, it requires '''''''' on each side of the variable. Thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kent Anderson Sent: Monday, October 18, 2004 1:32 PM To: [EMAIL PROTECTED] Org Subject: Re: [SQL]

[SQL] Finding duplicated values

suggestions?   Kent Anderson EZYield.com 407-629-0900 www.ezyield.com   This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the

[SQL] How do you compare contents of two tables using 2 pk

second table.   table 1 t1_fk_wm (FK) t1_fk_hm (FK) ... ... ...   table 2 t2_fk_wm  (FK) t2_fk_hm  (FK)   Table 2 doesn't have the same number of records as the first table however it should.   Any suggestions would be appreciated as I am still very much a beginner at SQL.    Kent Anderson