select INVOICEDATE, ACCOUNT, FEE , case when INVOICDATE in [QtrEndDate] then ‘Mgmt Fee’ else ‘Final Fee’ end as TYPE from INV_INVOICESUMMARY where INVOICEDATE >= @FromDate and INVOICDATE DATE <= @ToDate
|What is wrong with the following Dynamic SQL using SQL Server 2008? Conversion failed when converting the varchar value '01/01/2014' to data type int.||6||30|
|SQL Query Conversion of IIF statement into CASE - Syntax issue||17||29|
|mysql joining from the same table||6||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!