ishfaqad

Employee

since

‎10-10-2022

User Statistics

1 Posts
0 Solutions
0 Kudos given
0 Kudos received

User Activity

Posts
Replies

CASE Statement use in Select Statement

10-10-2022

Dear All,Can we Use CASE Statement in SQL Query while "Creating View" with "SQL Query"...i.e...SELECT v.FianaceYear, v.FinanceMonth ,FT.FinanceType_Eng, M.Description_en,CASE WHEN v.tContractStatusId =3 and v.IsWriteOff IS NULL THEN 'Termianted'WHEN ...