Tag Info

New answers tagged

1

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 ...


1

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. ...



Top 50 recent answers are included