Viewing 15 posts - 76 through 90 (of 152 total)
June 5, 2017 at 8:36 pm
June 5, 2017 at 3:53 pm
June 5, 2017 at 2:38 pm
June 1, 2017 at 11:14 pm
There will be no issue. I have done multiple.
April 10, 2017 at 4:06 pm
April 4, 2017 at 10:26 am
Updated code:
UPDATE Inventory
SET Price = Price + 2
where Dept_ID = '1123' and Price > '0.00'
This actually works.
March 31, 2017 at 1:04 pm
March 27, 2017 at 12:31 pm
Thank you everyone. This really helped me!
March 27, 2017 at 8:55 am
Would this work? (I know, test, but I am asking for further knowledge)
DELETE
FROM Inventory_BumpBarSettings
WHERE ISNUMERIC(ItemNum) = 12
UPDATE: Does not work, I am...
March 24, 2017 at 11:42 am
Thank you to everyone that put effort here. Very much appreciated!
March 16, 2017 at 4:26 pm
March 15, 2017 at 12:12 pm
No luck with this:
UPDATE Inventory
SET ItemNum = CAST(CAST(ItemNum AS BIGINT) AS VARCHAR(50))
WHERE LEN(ItemNum) = 12 and ItemNum like '0%'
March 15, 2017 at 12:04 pm
Viewing 15 posts - 76 through 90 (of 152 total)