<div>
if you need the &quot;max&quot; rehire date, you need to apply MAX() around the case expression (and put the relevant GROUP BY to your sql also, of course.
</div>


if you need the "max" rehire date, you need to apply MAX() around the case expression (and put the relevant GROUP BY to your sql also, of course.

<div>
<div class="content wysiwyg-content">
I NEED &nbsp;a case statement that returns the max rehire date when the condition = 101.<br />
here is the original case statement:<br />
<br />
case when eec.EecJobChangeReason &nbsp;= '100' then &nbsp;CONVERT(VARCHAR(25),eec.Ee<wbr />cDateOfOri<wbr />ginalHire,<wbr /> 101) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;when eec.EecJobChangeReason &nbsp;&lt;&gt; '101' then CONVERT(VARCHAR(25),eec.ee<wbr />cdateoflas<wbr />thire, 101) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end AS 'Hire Date',<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case when eec.EecJobChangeReason &nbsp;= '101' then CONVERT(VARCHAR(25),eec.ee<wbr />cdateoflas<wbr />thire &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, 101)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end as 'ReHire-Date',<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CONVERT(VARCHAR(25), eec.EecDateOfSeniority, 101) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AS 'Seniority Date',<br />
<br />
<br />
******I need &nbsp;this part of the case statement to return the max rehire date for that employee**************<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case when eec.EecJobChangeReason &nbsp;= '101' then CONVERT(VARCHAR(25),eec.ee<wbr />cdateoflas<wbr />thire &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, 101)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end as 'ReHire-Date',
</div>
</div>


I NEED  a case statement that returns the max rehire date when the condition = 101.
here is the original case statement:

case when eec.EecJobChangeReason  = '100' then  CONVERT(VARCHAR(25),eec.EecDateOfOriginalHire, 101) 
		 when eec.EecJobChangeReason  <> '101' then CONVERT(VARCHAR(25),eec.eecdateoflasthire, 101) 
		 end AS 'Hire Date',
		case when eec.EecJobChangeReason  = '101' then CONVERT(VARCHAR(25),eec.eecdateoflasthire	, 101)
		end as 'ReHire-Date',
		CONVERT(VARCHAR(25), eec.EecDateOfSeniority, 101)			AS 'Seniority Date',


******I need  this part of the case statement to return the max rehire date for that employee**************

		case when eec.EecJobChangeReason  = '101' then CONVERT(VARCHAR(25),eec.eecdateoflasthire	, 101)
		end as 'ReHire-Date',

Max rehire date for employee in a case statement

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.