used this to add a record number

DECLARE @counter int

SET @counter = 0

UPDATE DBO.NEWDUNDD_SEAXX

SET @counter = rec_numb= @counter + 1

they are not unique values unfortunately, with the primary key suggestion, is there a way to create a unique record for each row that is added to the table such...

i dont want to update all the values in the column, only certain ones.

if you look at the data below, you will see there are only certain rows that...

havent gotten that far yet on the insert into, need to get the syntax together prior to creating the new table.

this is a data example of what i am attempting to parse into columns. i have tried the substring, not working so well not standard positions on the values

(blank spaces)24W...

this is what i am using currently, but all the values are not being populated properly.

IF OBJECT_ID('tempdb..#Temp') IS NOT NULL DROP TABLE #Temp

CREATE TABLE #Temp (ID INT Identity, OrigField VarChar(Max),f1...

i know what is missing by looking at the data.

if i use replace, i still cant get the values in the columns i need due to length of the field. there is no set length on the first value...

i used delete top(1) from table etc.... that seemd to work

thanks

If i create a table that contains my duplicate values, how do i delete them from the other table

not sure of the syntax to use

select * from duptable where rec=table.rec...

Thanks, that is basically what i am looking for, i apologize for being slow on getting this, but i want to understand as well as, get it working.

the first substring...

Some additional assistance please. I used this to create a function, but how do i get it to a table? i have done some searching but im stumped. it...

thank you very much, that is exactly what i am looking for to retrieve the data to columns,

how do i create a table from that, can i just replace...