Solved using ...ROW_NUMBER() OVER (PARTITION BY ....

ST

REF DESIGN ...

yes, didn´t give any error,

Table ST

REF c(18)

DESIGN c(60)

STOCK n(10)

Table SC

REF c(18) this fiels exists on both

DESIGN c(60)

REFB c(18)

join: sc.refb=st.ref

The table ST has...

thanks for the quick reply, unfortenly the query you sent don´t return any result

thanks for the quick reply, unfortenly the query you sent don´t return any result

ok many thanks, works fine, e needed to create table tally on my database not in tempdb like in the example

if i do

select * from tally

returns all the numbers ok 1,2,....11000

i put

INSERT INTO BC

SELECT '001','teste', RIGHT( '000' + CAST( n AS varchar(4)), 4)

FROM dbo.Tally

WHERE n <= 9999

and returns this error msg

Erro: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object...

hi

After creating the tally table, used this, but gives me a error on the select

INSERT INTO BC (ref,design,codigo)

values ("001","teste", SELECT '001',

'teste',

RIGHT( '000'...

sorry, you are right

it worked as i intended.

Next time i post something, i definitly will put more information ( tables, data, fields...), to help you help me!

Thank you very much for your time...

First of all, many thanks for your response

it returned

Dossier 1|Null|10|20130210|client|999|Invoice|1|150,00

Dossier 1|Null|10|20130210|client|999|Invoice|4|250,00

Dossier 1|Null|10|20130210|client|999|Invoice|6|250,00

and i need that first value 1000,00

Dossier 1|1000,00|10|20130210|client|999|Invoice|1|150,00

Dossier 1|Null|10|20130210|client|999|Invoice|4|250,00

Dossier 1|Null|10|20130210|client|999|Invoice|6|250,00

just another question, is it possible to save the resulting .txt in ANSI mode instead of Unicode?

thanks in advance

ok thank you very much

it worked just fine