declare @test varchar(50)
select @test

declare @otherPrivateProducts varchar(max)
        set @otherPrivateProducts=''
        select @otherPrivateProducts=isnull(@otherPrivateProducts,'')+isnull(EproductIdStr,'') from EprivateShowRoom where EcompanyId={0}
        select @otherPrivateProducts;