Solved

Problem in cast in sql

Posted on 2014-10-01
1
182 Views
Last Modified: 2014-10-01
Query : select firstname, case when ProjectName Is Null Then 0 else ProjectName  end  from EmployeeTable
Left join
Projectdeatil on EmployeeTable.Employeeid = Projectdeatil.EmployeeDetailID order by firstname

Error:   Conversion failed when converting the varchar value 'Task Track' to data type int.
0
Comment
Question by:satmisha
1 Comment
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40354860
Change it to:

select firstname, case when ProjectName Is Null Then '0' else ProjectName  end  from EmployeeTable 
 Left join 
 Projectdeatil on EmployeeTable.Employeeid = Projectdeatil.EmployeeDetailID order by firstname 

Open in new window

0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question