PL/SQL query

SQeeL

Hello,

I am trying to convert a PL/SQL query to T-SQL. I have the following part of a query that I'm trying to understand:

SELECT

CASE WHEN 

 DSS.FN_SSRS_VALIDDATE(DSS_T_D_SSA_MASTER2.DTE_BIRTH_MM || DSS_T_D_SSA_MASTER2.DTE_BIRTH_DD || DSS_T_D_SSA_MASTER2.DTE_BIRTH_CCYY) = 'Valid'

 THEN

 to_date(DSS_T_D_SSA_MASTER2.DTE_BIRTH_MM || DSS_T_D_SSA_MASTER2.DTE_BIRTH_DD || DSS_T_D_SSA_MASTER2.DTE_BIRTH_CCYY,'MM/DD/YYYY')

 ELSE  NULL END as SSA_DOB

FROM

[TABLE]

WHERE

[JOIN]

I understand the CASE statement operation and || (concatenation) but how should I interpret the statement after CASE WHEN? Is DSS.FN_SSRS_VALIDDATE a reference table (like a LookUp) and the statement inside the parentheses the reference value? And how does that compare to a T-SQL statement? Thanks for any help.

Paulzip

DSS.FN_SSRS_VALIDDATE is a standalone function / or package function. You'll need to write the equivalent in T-SQL.

Paulzip

DSS.FN_SSRS_VALIDDATE is a standalone function / or package function. You'll need to write the equivalent in T-SQL.

User_H3J7U

> statement after CASE WHEN?

After when you have the equality operator =.

> Is DSS.FN_SSRS_VALIDDATE a reference table

It is a function.

Do not try to convert the expression exactly. You can probably get this result much easier.