status from Customers table is datatype int

Status from view is NOT NULL VARCHAR2(1)

I can alter this stored procedure but i get this error:

Conversion failed when converting the nvarchar value 'A' to data type int

Why do i keep getting this error when i...

Need to change nvarchar to int

Case when A.Customer_Status = 'I' THEN CAST('0' AS int). Will this work

IS this the correct way to write this if i need to change a datatype from nvarchar to int:

select A.Account_number, A.Customer_name, A.Known_As, A.Legacy_Account_Number, A.Account_Established_Date, CASE WHEN A.Customer_Status = 'I' THEN...

there is a problem converting nvarchar to int

Conversion failed when converting the nvarchar value 'A' to data type int.

when i do an insert from my stored procedure

insert into dbo.Customers (CustomerID, Name, ShortName, ReferenceNo, EffectiveDate, Status, CreateDate)

select A.Account_number, A.Customer_name, A.Known_As, A.Legacy_Account_Number, A.Account_Established_Date, A.Customer_Status, A.Account_Established_Date

I need to create...

i found out that it was looking at my view and my view equivalent for the table is such:

Status = Customer_Status

CreateDate = Account_Established_Date

USE [AtriumWOE_CS_UserData_52]

GO

/****** Object: Table [dbo].[Customers] Script Date: 11/11/2008 10:27:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Customers](

[CustomerID] [dbo].[C_ID] NOT NULL,

[ParentCustomerID] [dbo].[C_ID] NULL,

[ParentContactID] [dbo].[C_ID] NULL,

[Name] [dbo].[C_Name] NOT NULL,

[ShortName]...

that is correct do i need to put dbo.Status, dbo.CreateDate ?

error is

Msg 207, Level 16, State 1, Procedure BILLTO_Customers, Line 14

Invalid column name 'Status'.

Msg 207, Level 16, State 1, Procedure BILLTO_Customers, Line 34

Invalid column name 'Status'.

Msg 207, Level 16,...

this is the error:

Msg 137, Level 15, State 2, Procedure BILLTO_Customers, Line 8

Must declare the scalar variable "@Account_Number".

Msg 102, Level 15, State 1, Procedure BILLTO_Customers, Line 28

Incorrect syntax near 'CustomerID'.

Can you tell me why this doesnt run:

USE [AtriumWOE_CS_UserData_52]

GO

/****** Object: StoredProcedure [dbo].[BILLTO_Customers] Script Date: 11/10/2008 16:02:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[BILLTO_Customers]

AS

SET...

i sent you an email with a screenshot

EffectiveDate column is NULL

Account_Established_Date column is from the view, i dont understand what im supposed to do next

error message:

Msg 515, Level 16, State 2, Procedure BILLTO_Customers, Line 7

Cannot insert the value NULL into column 'EffectiveDate', table 'AtriumWOE_CS_UserData_52.dbo.Customers'; column does not allow nulls. UPDATE fails.

The statement has been...