Basssque
asked on
SSIS/SSDT Derived Table Syntax
Is it possible to insert the field results into this statement?
I want to return the information from the matching field after my statement below
This is what I have now
[JOBS_CONTRACT_END_DATE] < (DT_WSTR,10)(DT_DBDATE)(GE TDATE()) ? "ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y)" [JOBS_CONTRACT_END_DATE]
It throws "ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y)" in replacement for the value if the value in the [JOBS_CONTRACT_END_DATE] is less than the current date.
I want to add the actual value to the end of my string so it returns
ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y) [JOBS_CONTRACT_END_DATE]
[JOBS_CONTRACT_END_DATE] would be a date formatted as yyyy-mm-dd
Is that Possible?
Thanks!
I want to return the information from the matching field after my statement below
This is what I have now
[JOBS_CONTRACT_END_DATE] < (DT_WSTR,10)(DT_DBDATE)(GE
It throws "ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y)" in replacement for the value if the value in the [JOBS_CONTRACT_END_DATE] is less than the current date.
I want to add the actual value to the end of my string so it returns
ERROR(CONTRACT EXPIRED) BUT (EMPLOYMENT STATUS = Y) [JOBS_CONTRACT_END_DATE]
[JOBS_CONTRACT_END_DATE] would be a date formatted as yyyy-mm-dd
Is that Possible?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.