I'm trying to optimize the following statement:
'VI'+CAST(month(GETDATE()) AS NVARCHAR)+'/'+CAST(year(GETDATE()) AS NVARCHAR) +'/00000' +CAST(@number+1 AS VARCHAR)
The statement produces a value like
VI1/2011/000002 if the
@number parameter is
I would like to optimize this in terms of removing redundant cast statements and providing an efficient way to concatenate the strings and integers.