What is the error? How do you try to put TrxDateNumeric into StartDate?
ps: any reason why you are using NO_LOCK in your query?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP