declare @orderId int --set this to value of the orderID to cancel and hide set @orderId = 1014 update {databaseOwner}[{objectQualifier}CVStore_Orders] set orderIsPlaced=0, orderStatusId=6 where orderId=@orderId