DECLARE @NumDec INT
SELECT @NumDec = CONVERT(INT,KeyValue) FROM HotelSetUp WITH (NOLOCK) WHERE SearchKey = 'NumberOfDecimalsInPrices'
UPDATE Ware SET NumberOfDecimals = @NumDec WHERE NumberOfDecimals IS NULL
