1
iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd
Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here’s the ” Hard coded version (Works) SELECT SLSBIGD.R1SSID,SLSBIGD.prdistynm,SLSBIGD.prdiclrd,SLSBIGD.prdiclrnm, sum(SLSBIGD.MNET$) [...]
Answer Question
| May 30, 2008 2:31 PM
Date format, Date variable, DB2/400, SQL Query, SQL Subselect
Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here’s the ” Hard coded version (Works) SELECT SLSBIGD.R1SSID,SLSBIGD.prdistynm,SLSBIGD.prdiclrd,SLSBIGD.prdiclrnm, sum(SLSBIGD.MNET$) [...]
Answer Question
| May 30, 2008 2:31 PM
Date format, Date variable, DB2/400, SQL Query, SQL Subselect
How to use subselect in a case statement
Getting error… “Token EXISTS was not valid….” on case statement… ,case when g.GFGSTS = ’2′ and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = ’3′ ) then count(*) end as Void#
Answer Question
| January 17, 2008 3:11 PM
CASE statement, SQL, SQL Subselect
Getting error… “Token EXISTS was not valid….” on case statement… ,case when g.GFGSTS = ’2′ and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = ’3′ ) then count(*) end as Void#
Answer Question
| January 17, 2008 3:11 PM
CASE statement, SQL, SQL Subselect
1
