set @sql = 'select m.orderid , m.orderno , m.ContSize , m.ContClass , m.contno,m.txd,m.port ' select @sql = @sql + ' , max(case n.px when ''' + cast(px as varchar ...