Tag Info

Hot answers tagged


You need the USING clause to ALTER TABLE ... TYPE ..., e.g.: ALTER TABLE mytable ALTER COLUMN "Longitude" TYPE NUMERIC(14, 11) USING ("Longditude"::NUMERIC(14,11)), ALTER COLUMN "Latitude" TYPE NUMERIC(14, 11) USING ("Latitude"::NUMERIC(14,11)); assuming you want a numeric with precision 14 and scale 11 and your columns really do have an ...


The first thing I would do is identify rows where those 6 characters can't possibly be an integer. SELECT ProcessInstanceAppianID, ProcessInstanceDescription FROM InternalUseOnly.dbo.processinstance WHERE RIGHT(ProcessInstanceDescription, 6) NOT LIKE '[0-9][0-9][0-9][0-9][0-9][0-9]'; Then fix that data or somehow exclude it from the results. ...

Only top voted, non community-wiki answers of a minimum length are eligible