Thanks for the reply but unfortunately it is not working. When I executed the same query in the separate window its works great but while I replace my code  with...

• This reply was modified 4 years, 9 months ago by  chowdarydeepus@gmail.com.

Thanks for letting me know. I will update the post with scripts as per your suggestions.

Thanks, it works.

Yeah, I agree with you DateTime or Date column datatypes are good. But not sure who created this table this is what it is. Right now it is YYYY-MM-DD

Thanks, it worked. I really appreciate your help. Made below changes.

Instead of alertQueue used nestedAlertQueue and it resolved my issue.

SELECT alertQueue.[Prod No] AS ProdNumber
, SUBSTRING(alertQueue.[Prod No], PATINDEX('%[^0]%',...

• This reply was modified 4 years, 10 months ago by  chowdarydeepus@gmail.com.