And to finish it off, I just removed pb.ticker="SAP500" statement.
-Original Message-----
From: Pilarinos, Dionysios
Sent: Monday, March 01, 2004 4:56 PM
To: [EMAIL PROTECTED]
Subject: RE: Executing REPLACE from IF statement?
After some thought, this is what I came up with
ke this run for each pb.ticker without having to
explicitly identify it in the script.
Feel free to give me suggestions.
-Original Message-----
From: Pilarinos, Dionysios
Sent: Monday, March 01, 2004 3:53 PM
To: [EMAIL PROTECTED]
Subject: Executing REPLACE from IF statement?
Hi,
I was wond
Hi,
I was wondering if someone can point out a way to make the below script
update a row.
Query:
SELECT pb.ID, c.mdate, bc.mdate,
IF(DATE_FORMAT(c.mdate,'%m/%d/%Y') = bc.mdate, "Same Date", "Not Same Date")
FROM product_bench pb, current c, bench_current bc
WHERE pb.ticker="SAP500" and c.ID=pb.I