Jarek Z. ASTOR
Temat: CASE
Pisze procedure i mam pewnien problemfragment
SELECT @OffOccurances = COUNT(*) FROM #DiscreteHistoryData WHERE value = 0
SELECT @OnOccurances = COUNT(*) FROM #DiscreteHistoryData WHERE value = 1
SELECT @NullOccurances = COUNT(*) FROM #DiscreteHistoryData WHERE value is Null
SELECT top 1 @LatestDateTime=dt,@LatestValue=value FROM #DiscreteHistoryData WHERE dt <=@End ORDER BY dt DESC
IF (SELECT @LatestDateTime)<@End
BEGIN
INSERT #DiscreteHistoryData VALUES(
@End,
case @LatestValue
when 1 then 0
when 0 then 1
"
jak zapisać warunek,że jeżeli jest wartość Null to ma ustawić '0'??
'when is Null then 0' ?--> mam error