ya well once the new number is created its then stored in a file and re read into table so its always there.

it works well for the one account but...

have it sorted cheers. just created a temp table and used insert with your select

thats does work as far as it select it, but i need it to be commit to the table like that as when i pull the data into an excel...

anyone have ideas on how i can combibe data together.

this is how my table is as of right now

FundCodeACCOUNTPERIODClassNameNAVSharesOutstanding

IL0131/12/2013Class A GBP23704633.79

IL0131/12/2013Class A GBP20143018.57

IL0131/12/2013Class I2 GBP252178460.2

IL0131/12/2013Class I2 GBP210634139.7

IL0131/12/2013Class I2 EUR Hedged651780501.3

IL0131/12/2013Class...

how could i over come this problem as more than likely there will be more thqan 1 been updated at a time

good guess

thanks for help

Can anyone help with this

sorry i didnt think i was drip feeding i just thought if i got it working for 1 table i would just get it working for them all.

basically i...

i cant have 2 isdentity columns

there isnt alot of difference all right in thsi table. but will have to do something similar for another table and the id def...

it come out like this

PK_GLSectionSectionNumber

6TestNULL

1Assets1

2Liabilities2

3Revenue3

4Expense4

5Capital5

is there a way to auto incremnet the scention number number

thanks for that. will try that.

just 1 thing would that still work if say i had 10 different pieces of data in the second table that i wanted to update...

basically i read in a text file i do a few things to it get it to write to my output table it comes out like this

PK_IDFundCodeACCOUNTPERIODClassNameNAVSharesOutstanding

4IL0112/31/2013Class A GBP23704633.79

5IL0112/31/2013Class A...

hi thanks for that has to be generic.

i will be reading in loats of files at different times with different info

any way to get it to to that

have tried it like this

SELECT RIGHT(String,

CASE WHEN CHARINDEX('class',REVERSE(String))= 0

THEN 0

ELSE CHARINDEX('class',REVERSE(String))-1

END

)

FROM @tbl

returns blank

for f sake. some of the columns dont have full stops. this data is all over the place

can i use that to copy it from the word class instead of...