I have a 4 different columns that each contain a different date format.
YYMMDD, MMYY, YYYYMMDD, YMMDD
I need to convert these to an integer date format, YYYYMMDD. I understand how to do such, thanks to Reza. However, would it be beneficial to create a function in a script component transformation to handle these dates. What is the difference
in just coding it out in comparison to that of creating a function?SQL - new guy
View Complete Post