Good day, I'm getting an error when I'm inserting to my standard table. The below is the code that I have - Insert into Bidvest.dbo.[Bidvest Database] ([Item],
-
[Cardholder Name],
-
[Date Collected],
-
[Type],
-
[Address1],
-
[Address2],
-
[Address3],
-
[Address4],
-
[Work],
-
[Home],
-
[Cell],
-
[Plastic Number],
-
[ID Number],
-
[Cardholder ID],
-
[Company],
-
[CardType],
-
Delivery_Method,
-
[Cardholder Proof of Residence]
-
)
-
Select r.Main_Link,
-
r.ClientName,
-
CCDCommon.dbo.DateOnly(Getdate()),
-
'Wealth',
-
r.Address1,
-
r.Address2,
-
r.Address3,
-
r.Address4,
-
r.Work,
-
r.Home,
-
r.Cell,
-
r.UniqueRef,
-
r.ClientIDNumber,
-
cast(r.Branch as nvarchar(500)),
-
r.CardType,
-
r.[Type],
-
case when r.IDIndicator = 'Y' then 1 else 0 end,
-
case when r.PORIndicator = 'Y' then 1 else 0 end
-
From Bidvest.dbo.[ImportData_Wealth] r left join [Bidvest Database] d
-
on cast(r.[Main_Link] as nvarchar(250))= cast(d.[Item]as nvarchar(250))left join CCDArchive.dbo.[BidvestDatabase] a on a.[Plastic Number] = r.CardRef
-
and a.Type = 'Wealth'
-
Where r.CardType = 'Electron Card'
-
and r.[ImportDate] is null
-
and d.Item is null
-
and a.Item is null
-
-
but I get the below error:
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarchar value 'RMB PRIVATE BANK JOHANNESBURG - JHB' to data type bit.
1 4010 Sign in to post your reply or Sign up for a free account.
Similar topics
by: Saso Zagoranski |
last post by:
Hi!
I have created an SqlCommand object and I have set some parameters to it...
One of the parameters is of the DateTime type;
here is the code:
sqlCommand.Parameters.Value =...
|
by: Sebastian Mark |
last post by:
Did anyone got error like that?
When I'm trying to Update WebReference in my project this is an error I'm
getting "Custom tool error: Failed to generate dataset. Undefined data
type:...
|
by: darrel |
last post by:
I'm getting this error:
Arithmetic overflow error converting numeric to data type numeric.
Triggered on this line of my code:
objOleDbAdapter.Fill(DS, "rss")
Everything works when this is...
|
by: sonata |
last post by:
I am trying to compare two fields which are char data typr.
BUT the comparision must be arithemetic in nature.
so i tried to cast both the data base field and my parameter field to big int...
|
by: Hulikal |
last post by:
Hi,
I using the following query
select dateadd(s, 1185255439727, '01-01-1970 05:30:00')
on MSSQL 2005. I get the error
Arithmetic overflow error converting expression to data type...
|
by: bipinskulkarni |
last post by:
Hi,
i have a field createdby with datatype GUID.
In following query ,i encountered with the error
"Conversion failed when converting from a character string to uniqueidentifier"
select...
|
by: gggram2000 |
last post by:
I need some help, cant figure out the error.
SqlConnection dbConnection = new SqlConnection(xmldb);
dbConnection.Open();
string sql = "SELECT InvStatus FROM SaleReceipts Where AccNum = '" +...
|
by: Joell |
last post by:
When I try to insert values into an existing table, I am getting the following error. The table is not in bit data type format and neither is the target table. Conversion failed when converting the...
|
by: vertigo262 |
last post by:
This is driving me crazy
I run this query in the sql management studio and it works fine. but seems like it doesn't work in the stored procedure
Can I not use a LIKE '%' in an integer field?
...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |