Viewing 7 posts - 16 through 22 (of 22 total)
I added TRY/CATCHES around the query, but 0 records were added. I have 17,000+ records in the originating table, and 533 in the resulting table.
May 12, 2011 at 9:58 am
#1323781
So here's my question...
SELECT
RIGHT('000000' + convert(varchar(6), PartNo), 6),
0,
...
May 12, 2011 at 9:51 am
#1323776
NOW IT WORKS.
Thank you...
May 12, 2011 at 9:45 am
#1323773
Dan's posted code produces:
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '0'.
May 12, 2011 at 9:43 am
#1323771
Produces Incorrect Syntax near 0. This is bit data - perhaps I need to use true / false??
INSERT INTO dbo.Purchasing(PartNumber, IsHardware, KitAlways, ChinaPN, KitChina, InstallTime, LaborClass, UnitCost)
RIGHT('000000' +...
May 12, 2011 at 9:34 am
#1323760
I'm just trying to update another table based on various criteria, obviously. What you are saying is that there must be better ways for me to do this??
May 11, 2011 at 2:44 pm
#1323379
Thanks. One more thought, is there a way to update the same field in another table with the same statement?
Any recommended reading?
May 11, 2011 at 2:42 pm
#1323376