let see if i got this correct,

if i run update with the insert with the same records, will i get the same duplicate error, or will it overwrite the records...

what if im trying to do an insert of records that already there, then will i get the message about duplicate key objects?

will it work in 2005?

how do i find the base defined types for my Customers table?

Does this help you create a table?

USE [AtriumWOE_CS_UserData_52]

GO

/****** Object: Table [dbo].[Customers] Script Date: 11/12/2008 16:06:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Customers](

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

[ParentCustomerID] [dbo].[C_ID]...

thanks

i get this:

Nov 12 200

Lynn the create table statement was wrong, what about the datatypes, and how many value lines do you need

I used a CAST function for the value

Case When A.Customer_Status = 'I' THEN CAST ('0' AS int) ELSE CAST('1' AS int) END

So status in the table should be updated to...

i think i have a solution i just dont know why the cast function im using doesnt work when i run my stored procedure? with the script i gave you,...

it works but error is:

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

what does seconded mean?

what else do you need from me ?

here are the view datatypes from oracle and the output to update from

Account_number NOT NULL VARCHAR2(30)

Customer_name VARCHAR2(150)

Known_As ...

here is a create table example

CREATE TABLE [dbo].[Customers](

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

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

[ShortName] [dbo].[C_Caption] NULL,

[ReferenceNo] [dbo].[C_Name] NULL,

[EffectiveDate] [dbo].[C_Date] NOT NULL CONSTRAINT [DF__Customers__Effec__220B0B18] DEFAULT (getdate()),

...

im a little confused on that, all i understand is that you want me to create a table,how many columns do i need?