<div>
The error was not in the case statement, I was missing a comma in the previous sections and Toad was erroring out at this location. Everything OK now. Thanks!
</div>


The error was not in the case statement, I was missing a comma in the previous sections and Toad was erroring out at this location. Everything OK now. Thanks!

<div>
<div class="content wysiwyg-content">
I have a decode statement from an Oracle Report I am trying to translate into SQL server.<br />
<br />
Here is the statement:<br />
<br />
<i>DECODE(RECEIPT_DATE, NULL, DECODE(DISP_DATE,NULL,DATE<wbr />_SERIALIZE<wbr />D,DISP_DAT<wbr />E),RECEIPT<wbr />_DATE) transfer_date &nbsp;</i><br />
<br />
From what I researched, SQL's equivalent would be a case statement. This is what I got so far but is erroring out: &quot;incorrent sytax near word case&quot;<br />
<br />
<i>case <br />
&nbsp; when RECEIPT_DATE is null then (<br />
&nbsp; &nbsp; case when DISP_DATE is null then date_serialized<br />
&nbsp; &nbsp; else DISP_DATE end)<br />
&nbsp; else receipt_date end as transfer_date</i><br />
<br />
Did I miss something?
</div>
</div>


I have a decode statement from an Oracle Report I am trying to translate into SQL server.

Here is the statement:

DECODE(RECEIPT_DATE, NULL, DECODE(DISP_DATE,NULL,DATE_SERIALIZED,DISP_DATE),RECEIPT_DATE) transfer_date  

From what I researched, SQL's equivalent would be a case statement. This is what I got so far but is erroring out: "incorrent sytax near word case"

case 
  when RECEIPT_DATE is null then (
    case when DISP_DATE is null then date_serialized
    else DISP_DATE end)
  else receipt_date end as transfer_date

Did I miss something?

Converting Oracle Decode to SQL equivalent

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.