Let me try to explain a little better.

I need to get a select where all columnB that are not columnA value 1 turn to zero.

Yes i want to group by day and by artigo.

ill try your sugesttions

the simple awnser is always the best.

Sorry for my ignorance

it work's

what if i wanna keep the top 10 of the products and send the rest to historic table, sorry for the abuse

Thanks i will walk from there

hi,

In the column SNPN  i will make it UNIQUE index/constraint on the week because it doesnt allow me to do it we workstation labeling.

I think this column was created for...

I have alter the app code with:

INSERT EtiquetasKLC.dbo.etiquetas
(
    nome_posto
   ,data
   ,lote
   ,serialnumber
   ,partnumber
   ,versao
...

Thanks for your help.

Yes we could skip one or another serial.

I will rewrite the code with the suggestion and give feedback soon.

• This reply was modified 5 years, 5 months ago by  nrdroque.