SUM CASE DATE Problem

[KOVMoe]

when I use the Sum case on a date field I get an error, cannot convert nvarchar to int. Here is the code.

SUM(CASE WHEN d.dat_val_dt = '2005-08-03' THEN 1 ELSE 0 END)AS TOTSPH

Any ideas?


Thank you,

Moe-King of the Village Idiots.

"When in trouble,
when in doubt;
Run in circles-
SCREAM & SHOUT!!"
Burma Shave

 

[vongrunt]

This is not complete query... FROM what?
And what is datatype for dat_val_dt column?

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]