Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The multi-part identifier error Expand / Collapse
Author
Message
Posted Wednesday, June 5, 2013 9:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 2, 2013 7:15 AM
Points: 2, Visits: 10
[size="1"]I've being trying to figured out why this error is happening but no lucky yet.

The code:

SELECT 
CONVERT(VARCHAR, S_OPERATION.DATE_OPER, 112) + ' ' + -- DATE OPER YYYYMMDD
CONVERT(VARCHAR, S_OPERATION.OPE_TIME, 102) + ' ' + -- OPE TIME HH:MI:SS
FNUMBER.FILE_SEQUENCY_REND + ' ' + -- BATCH NUMBER
RIGHT(REPLICATE('0',16) + CONVERT(VARCHAR(16),
DBO.F_EXTRACT_NBR_CHAR(RECEIVER.C_CPF)),16) + ' ' + -- RECEIVER CPF / CNPJ
DBO.FN_FORMAT_RIGHT_SPACES(RECEIVER.C_NAME, 40) + ' ' + -- RECEIVER NAME
RIGHT(REPLICATE('0',14) + CONVERT(VARCHAR(14),
DBO.F_EXTRACT_NBR_CHAR(RECEIVER.C_PHONE1)),14) + ' ' + -- RECEIVER PHONE NUMBER
DBO.FN_FORMAT_RIGHT_SPACES(RECEIVER.C_ADDRESS, 50) + ' ' + -- RECEIVER ADDRESS
DBO.FN_FORMAT_RIGHT_SPACES(RECEIVER.C_CITY, 20) + ' ' + -- RECEIVER CITY
DBO.FN_FORMAT_RIGHT_SPACES(S_ACCOUNT.ACCOUNT_STATE) + ' ' + -- RECEIVER STATE
RIGHT(REPLICATE('0',14) + CONVERT(VARCHAR(14), DBO.F_EXTRACT_NBR_CHAR(RECEIVER.C_ZIP)),14) + ' ' + -- RECEIVER ZIP
DBO.FN_FORMAT_RIGHT_SPACES(RECEIVERCOUNTRY.COUNTRY , 20) + ' ' + -- RECEIVER COUNTRY
RIGHT(REPLICATE('0',3) + CONVERT(VARCHAR(3), ISNULL(S_BANK.BANK_NUMBER, 0)),3) + ' ' + -- BANK NUMBER
DBO.FN_FORMAT_RIGHT_SPACES(S_ACCOUNT.AGENCY, 30) + ' ' + -- AGENCY
DBO.FN_FORMAT_RIGHT_SPACES(S_ACCOUNT.ACCOUNT, 16) + ' ' + -- ACCOUNT NUMBER (CHAR)
LEFT(ISNULL(S_ACCOUNT.ACCOUNT_TYPE, 'C/C'), 1) + ' ' + -- ACCOUNT TYPE
DBO.FN_FORMAT_RIGHT_SPACES(SENDER.C_NAME, 40) + ' ' + -- SENDER
DBO.FN_FORMAT_RIGHT_SPACES(SENDER.C_CUSTOMER_ID, 40) + ' ' + -- SENDER ID
DBO.FN_FORMAT_RIGHT_SPACES(SENDER.C_ADDRESS, 50) + ' ' + -- SENDER ADDRESS
DBO.FN_FORMAT_RIGHT_SPACES(SENDER.C_CITY, 20) + ' ' + -- SENDER CITY
DBO.FN_FORMAT_RIGHT_SPACES(S_ACCOUNT.ACCOUNT_STATE,2) + ' ' + -- SENDER STATE
RIGHT(REPLICATE('0',14) + CONVERT(VARCHAR(14), DBO.F_EXTRACT_NBR_CHAR(SENDER.C_ZIP)),14) + ' ' + -- RECEIVER ZIP
DBO.FN_FORMAT_RIGHT_SPACES(SENDERCOUNTRY.COUNTRY , 20) + ' ' + -- SENDER COUNTRY
RIGHT(REPLACE(REPLICATE('0', 15) + CAST(CAST(AMOUNT * RATE AS NUMERIC(15,2)) AS VARCHAR), '.', '') ,15) + ' ' + -- FOREING AMOUNT
'L' + ' ' + -- CURRENCY TYPE L = LOCAL / D = DOLLAR
'N' + ' ' + -- TRANS TYPE - N=NEW OR V=VOID
RIGHT(REPLICATE('0',10) + CONVERT(VARCHAR(10), S_OPERATION.OPE_NUMBER),10) + ' ' + -- OPERATIONS NUMBER
SPACE(20) + ';' + -- LIVRE
SPACE(80) -- LIVRE
AS LINE,
S_OPERATION.DATE_OPER,
S_OPERATION.OPE_TIME,
S_OPERATION.FOREING,
S_OPERATION.OPE_NUMBER,
S_OPERATION.OPE_SUBNUMBER,
S_OPERATION.MAKER,
S_OPERATION.AMOUNT,
S_OPERATION.FEE_AMOUNT,
ISNULL(S_OPERATION.COM_STAR,0) AS COM_STAR
FROM S_OPERATION, S_FILE_NUMBER FNUMBER
JOIN S_CUSTOMER SENDER
ON S_OPERATION.SENDER_ID = SENDER.C_CUSTOMER_ID
JOIN S_CUSTOMER RECEIVER
ON S_OPERATION.RECEIVER_ID = RECEIVER.C_CUSTOMER_ID
JOIN S_COUNTRY SENDERCOUNTRY
ON SENDER.C_COUNTRY_ID = SENDERCOUNTRY.COUNTRY_ID
JOIN S_ACCOUNT
ON S_OPERATION.ACC_ID = S_ACCOUNT.ACCOUNT_ID
JOIN S_BANK
ON S_ACCOUNT.BANK_ID = S_BANK.BANK_ID
JOIN S_S_OPERATIONATION_PAYERBATCH
ON S_OPERATION.OPE_NUMBER =
S_OPERATIONATION_PAYERBATCH.OPE_NUMBER
WHERE S_S_OPERATIONATION_PAYERBATCH.IDPAYERBATCH = @IDPAYERBATCH

And the error


Msg 4104, Level 16, State 1, Procedure sp_generate_payerbatch, Line 207
The multi-part identifier "S_OPERATION.SENDER_ID" could not be bound.
Msg 4104, Level 16, State 1, Procedure sp_generate_payerbatch, Line 209
The multi-part identifier "S_OPERATION.RECEIVER_ID" could not be bound.
Msg 4104, Level 16, State 1, Procedure sp_generate_payerbatch, Line 213
The multi-part identifier "S_OPERATION.ACC_ID" could not be bound.

Thanks for any help
[/size]
Post #1460294
Posted Wednesday, June 5, 2013 2:58 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 12, 2014 11:09 AM
Points: 815, Visits: 557
Start with the first join and see how that goes

SELECT TOP 100 *
FROM S_OPERATION, S_FILE_NUMBER FNUMBER
JOIN S_CUSTOMER SENDER
ON S_OPERATION.SENDER_ID = SENDER.C_CUSTOMER_ID

Are you trying to join 2 tables S_OPERATION and SENDER?
Then this should work

SELECT TOP 100 *
FROM S_OPERATION AS O
INNER JOIN SENDER AS S
ON O.ENDER_ID = S._CUSTOMER_ID
Post #1460454
Posted Wednesday, June 5, 2013 3:44 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 5:35 PM
Points: 861, Visits: 7,242
Not sure your join makes sense. You'll need to fill in the question marks below, but this removes the mixed join types:

FROM S_OPERATION
JOIN S_CUSTOMER SENDER
ON S_OPERATION.SENDER_ID = SENDER.C_CUSTOMER_ID
JOIN S_CUSTOMER RECEIVER
ON S_OPERATION.RECEIVER_ID = RECEIVER.C_CUSTOMER_ID
JOIN S_COUNTRY SENDERCOUNTRY
ON SENDER.C_COUNTRY_ID = SENDERCOUNTRY.COUNTRY_ID
JOIN S_ACCOUNT
ON S_OPERATION.ACC_ID = S_ACCOUNT.ACCOUNT_ID
JOIN S_BANK
ON S_ACCOUNT.BANK_ID = S_BANK.BANK_ID
JOIN S_S_OPERATIONATION_PAYERBATCH
ON S_OPERATION.OPE_NUMBER =
S_OPERATIONATION_PAYERBATCH.OPE_NUMBER
join S_FILE_NUMBER FNUMBER on ??????? = ???????
WHERE S_S_OPERATIONATION_PAYERBATCH.IDPAYERBATCH = @IDPAYERBATCH





And then again, I might be wrong ...
David Webb
Post #1460472
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse