Need to instead 2020 put DateTime.Now.Year
My part query:
'RN '+ CAST(FORMAT(@maxRB,'000') AS VARCHAR(MAX)) + ' 2020 ' + CAST(@maxRN AS VARCHAR(MAX))
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Laxmidhar SahooPosted Jul 10, 2020, 7:51 AM
Jenith ThakkarPosted Jul 9, 2020, 11:46 PM
'RN '+ CAST(FORMAT(@maxRB,'000') AS VARCHAR(MAX)) + Datetime.Now.ToString('yyyy') + CAST(@maxRN AS VARCHAR(MAX))
Try this
Accept this answer if it's helpful for you