or another alternative to Luis code - wonder which one will run faster

UPDATE Inventory
SET ItemNum = stuff(ItemNum, 1, patindex('%[^0]%', ItemNum) - 1, '')
WHERE ItemNum like '0%'

I would try and do one of those loads onto a varchar(100) and then do a select convert(uniqueidentifier, varcharcolumn) and see if any fails.

If the test above does...

for 2012 - http://download.microsoft.com/download/7/3/C/73CAD4E0-D0B5-4BE5-AB49-D5B886A5AE00/SQL_Server_2012_Licensing_Reference_Guide.pdf

Lowell,

Not according to the license terms - None of the SQL Developer blocks (SSIS, SQL Server itself, SQL Server Agent, SSAS, Report Services) can connect to a production...

one other option which may be viable depending on the number of distinct values of that field and its mapping to the new system.

something around these lines

VS is only 32 bit and so is SSDT (as this is nothing else than extensions to VS).

Normally this is not an issue as most of the common...

you can use ram for tempdb
look at http://www.superspeed.com/servers/ramdisk.php

Based on your current setup I would get more RAM on the server and use part of it for the...

just text added to it as to ensure the code I was doing was picking up the correct values only, and not empty spaces afterwards

Just a bit of an exercise to show what can be done, and some of the possible issues if the date format isn't always the same

declare @tbl...

Glad it worked.

Just as an additional check as it may also affect this (and other) queries, how many CPU's you got allocated to this VM and how many...

the code I gave does guarantee that.
but if you wish to have the extra validation you can try this variation to the code I gave

[code...

without a full rewrite I would try the following
looking at the code and the plans the following is not quite what I would do and I do think it...