declare @mediaid int
declare @volumeid int
set @mediaid=1121
set @volumeid=12
select (cast(1000000+@mediaid as nvarchar)+right((N'000'+cast (@volumeid as nvarchar)),3))
declare @mediaid int
declare @volumeid int
set @mediaid=1121
set @volumeid=12
select (cast(1000000+@mediaid as nvarchar)+right((N'000'+cast (@volumeid as nvarchar)),3))