many,many tks

Hi

you are completly right, it works, the problem was a null value on the table

thk for the patient that you all had.

thats the problem i´m executing it all

hi

my problem is in the insert statment

declare @_type int

select @_type = max(turno) from u_contadores

insert into u_contadores (b1,b1cont,turno)

VALUES

('00003','00003',@_type)

returns

Msg 137, Level 15, State 2, Line 4

Must declare the scalar variable "@_type".

if i run

SELECT max(turno)+1 INTO@_type FROM u_contadores;

i get the desired value

please help

tks a lot!

just see how to do it

...always learning!

ok, with new values PROJECT = 888

_TABLES BO and BI

select bo.fref,bi.ref,bi.edebito from bo

inner join BI on bo.bostamp=bi.bostamp where bo.fref=888

returns:

888625 ...

carlos cachulo-318532 (12/1/2010)

I´ve these tables

BO, BI, FN and U_IDINET

I need to group and sum several fields whithin this tabels

BO and BI can be joined by BO.BOSTAMP=BI.BOSTAMP

BO and FN...

Start from the begining

2 DATABASES - MANDIFLEX and PRODIFLEX

MANDIFLEX has this tables TABATOPCO and TABAT

PRODIFLEX has the table ST

TABATOPCO and TABAT can me joined by this fields tabat.st_tabatphc=tabat.stamp

and TABAT...

ok, thank you very much

hello the query returns

Server: Msg 156, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'from'.

i´v tried this

update tabatopco set u_nconsumo=1 where (select ref,u_nconsumo,cod_art,desc_art

from tabatopco(nolock),tabat(nolock) inner...

thanks for the help, is working !!!

thank you

thank you very much for the support, the final result was this and is working !!

select distinct BI.REF,BI.DESIGN,SUM(BI.QTT) as QTT_A_PRODUZIR, ST.STOCK, dif=(st.stock-sum(bi.qtt))

from bi (nolock) inner join bo (nolock)...

hello

thanks, sorry for this dummie questions, i´m begining to discover sql

thank you veru much

carlos a. cachulo

hi again

one problem just came up,

in this quantities some are out orders and others are in orders,

example

if sl.origem='BO' +

and if sl.origem='FT' -

is is possible to reflect this...