Msg 245, level 16, state 1, line 73 conversion failed when converting the varchar value 'anantapur' to data type int.

Question

1.00/5 (1 vote)

See more:

i want to get an output username, email, statename, districtname but getting an error

am writing query for inner joins.

What I have tried:

select 
userprofiledetails.username, userprofiledetails.email,
state_info.statename,
districtinfo.districtname
from userprofiledetails 
inner join state_info
on userprofiledetails.stateid=state_info.stateid
inner join districtinfo on 
userprofiledetails.districtid=districtinfo.districtname

Posted 22-Jan-23 15:24pm

Ashwin Kumar Jan2023

Updated 22-Jan-23 18:02pm

Add a Solution

Comments

Sandeep Mewara 22-Jan-23 21:39pm

You have shared SQL query but error seems to be with your programming code. It clearly states the reason to - seems your conversion is failing from varchar to int as one of the values retrieved from DB is not integer. You need to handle the usecases correctly.

I would guess field values that are either NULL or space could be first possibile culprit.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2023-01-22T18:02:00

First, we're going to rewrite the statement so it's a bit easier to read:

SQL

SELECT upd.username
     , upd.email
     , si.statename
     , di.districtname
FROM userprofiledetails AS upd
INNER JOIN state_info AS si ON upd.stateid = si.stateid
INNER JOIN districtinfo AS di ON upd.districtid = di.districtname

Now, take a look at your second INNER JOIN:

SQL

INNER JOIN districtinfo AS di ON upd.districtid = di.districtname

The error is complaining that you're trying to equate a "districtname" to a "districtid".
It's telling you that you cannot convert the name to an integer to join the records in both tables.

So what do you think that join should really look like?

SQL

INNER JOIN districtinfo AS di ON upd.districtid = di.district??

Msg 245, level 16, state 1, line 73 conversion failed when converting the varchar value 'anantapur' to data type int.

1 solution

Solution 1

Add your solution here

Preview 0

Msg 245, level 16, state 1, line 73 conversion failed when converting the varchar value 'anantapur' to data type int.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us