I am getting an error:
Conversion failed when converting the nvarchar value '10/2007' to data type int.
using:
a.[calyearmonth] = b.[calyearmonth] - 1
calyearmonth is a nvarchar and I need to get previous month in table b.
Do I need to covert calyearmonth somehow?
Conversion failed when converting the nvarchar value '10/2007' to data type int.
using:
a.[calyearmonth] = b.[calyearmonth] - 1
calyearmonth is a nvarchar and I need to get previous month in table b.
Do I need to covert calyearmonth somehow?