when i run this i get an error:

Msg 208, Level 16, State 1, Procedure BILLTO_Customers, Line 7

Invalid object name 'dbo.cust.Customers'.

USE [AtriumWOE_CS_UserData_52]

GO

/****** Object: StoredProcedure [dbo].[BILLTO_Customers] Script...

Customers is the table and AVW_11i_WA_BILLTO_Customers is a view i created that displays the data selected by the query. Some columns in my view are related to some columns in...

what about adding the cursor to read each row

when i run only this portion of the code i still get the same error:

Msg 9803, Level 16, State 1, Line 1

Invalid data for type "numeric".

SELECT 1

...

same error:

where

CAST(RIGHT(ca.attribute10,3) as varchar(3)) = '086'

--and si.bill_to_flag in ('P','Y')

...

When i start at the first line the error is:

Msg 9803, Level 16, State 1, Line 1

Invalid data for type "numeric"

where

str(ca.attribute10,9,3)...

still error:

Msg 8114, Level 16, State 5, Line 1

Error converting data type nvarchar to float.

yes

error is still

Msg 8114, Level 16, State 5, Line 1

Error converting data type nvarchar to float.

this is the original line in oracle

and sysdate between org.effective_start_date and nvl(org.effective_end_date,sysdate)

i believe it helps with the query in selecting the dates that match the order number.

for example,...

maybe its this line i have commented out:

how would i write this line:

--and between GetDate()org.effective_start_date and GetDate() org.effective_end_date

data types

EFFECTIVE_START_DATE NOT...

ATTRIBUTE3 VARCHAR2(150)

KNOWN_AS VARCHAR2(240)

here are the datatypes:

ORIG_SYSTEM VARCHAR2(30)

ORIG_SYSTEM_REFERENCE VARCHAR2(255)

ACCOUNT_NUMBER ...

here are the data types:

ORIG_SYSTEM VARCHAR2(30)

ORIG_SYSTEM_REFERENCE VARCHAR2(255)

ACCOUNT_NUMBER ...

with the query i gave you, i am converting from pl/sql into tsql

here is an output line from the pl/sql

ORACLE | 93596 | 68498 | 3089512-086 | MARTIN POWER SOLUTIONS...