Hi
Progressing my coding from Crystal Reports into SQL, and running into some problems with NULL and ISNULL calculations. The following is some basic coding I have done, and am getting errors around the ISNULL statement.
I would be gratfeul for any help.
Thanks
GV
SELECT
"OtherAsset"."id",
"PartyFinancialItem"."partyId",
"OtherAsset"."type",
CASE "OtherAsset"."type"
WHEN 'Deposit' THEN "OtherAsset"."accounttype"
WHEN 'Other' THEN
CASE "OtherAsset"."otherdescription"
WHEN ISNULL THEN "OtherAsset"."othertype"
ELSE "OtherAsset"."otherdescription"
END
END,
"OtherAsset"."xvalue"
FROM "Phase2FiordlandApp"."dbo"."OtherAsset" "OtherAsset"
LEFT OUTER JOIN "Phase2FiordlandApp"."dbo"."PartyFinancialItem" "PartyFinancialItem"
ON "OtherAsset"."id"="PartyFinancialItem"."financialItemId
Progressing my coding from Crystal Reports into SQL, and running into some problems with NULL and ISNULL calculations. The following is some basic coding I have done, and am getting errors around the ISNULL statement.
I would be gratfeul for any help.
Thanks
GV
SELECT
"OtherAsset"."id",
"PartyFinancialItem"."partyId",
"OtherAsset"."type",
CASE "OtherAsset"."type"
WHEN 'Deposit' THEN "OtherAsset"."accounttype"
WHEN 'Other' THEN
CASE "OtherAsset"."otherdescription"
WHEN ISNULL THEN "OtherAsset"."othertype"
ELSE "OtherAsset"."otherdescription"
END
END,
"OtherAsset"."xvalue"
FROM "Phase2FiordlandApp"."dbo"."OtherAsset" "OtherAsset"
LEFT OUTER JOIN "Phase2FiordlandApp"."dbo"."PartyFinancialItem" "PartyFinancialItem"
ON "OtherAsset"."id"="PartyFinancialItem"."financialItemId