COALESCE
COALESCE
(OP)
Hello All
Can you kindly advice what is wrong with this statement
COALESCE (SUM(Cost)) AS Cost,
I am getting this error
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near ')'.
Can you kindly advice what is wrong with this statement
COALESCE (SUM(Cost)) AS Cost,
I am getting this error
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near ')'.
RE: COALESCE
if SUM(Cost) is NULL, what value do you want?
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
RE: COALESCE
COALESCE (SUM(Cost),0) AS Cost,
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?