SQL Server - query error

hi, is there any mistake in the following error
select Projectdtls.ProjectId,Projectdtls.Name,Projectdtls.Projectdate=(select CONVERT(varchar(10),getdate(),101)),Projectdtls.Venue,EmployeeDetails.EmployeeName from Projectdtls,EmployeeDetails where Projectdtls.EmployeeId = EmployeeDetails.EmployeeId 
it showing me an error... plz help

wat type of error shown? post the error message..

Issue : "Projectdtls.Projectdate=(select CONVERT(varchar(10),getdate(),101))"

Issue with red marked line in your query , you make mistake in two place one is where condition is putting in column vlaue in select 
and join condition should be using ON 

select Projectdtls.ProjectId,Projectdtls.Name,
Projectdtls.Projectdate=(select CONVERT(varchar(10),getdate(),101)),
Projectdtls.Venue,EmployeeDetails.EmployeeName from Projectdtls,EmployeeDetails
Where Projectdtls.EmployeeId = EmployeeDetails.EmployeeId  

Change above query as follows to corect

select Projectdtls.ProjectId,Projectdtls.Name,
Projectdtls.Venue,EmployeeDetails.EmployeeName from Projectdtls,EmployeeDetails 
ON Projectdtls.EmployeeId = EmployeeDetails.EmployeeId  
Where CONVERT( varchar(10), Projectdtls.Projectdate,101) = CONVERT(varchar(10),getdate(),101) 

hope this helps you

thank u its working...

Hi post the error message what ever it is showing.

u r welcome

Hello,

 

Try your query as following way

select Projectdtls.ProjectId,Projectdtls.Name,Projectdtls.Projectdate,Projectdtls.Venue,EmployeeDetails.EmployeeName

from Projectdtls INNER JOIN EmployeeDetails ON Projectdtls.EmployeeId = EmployeeDetails.EmployeeId

WHERE

CONVERT(varchar(10),Projectdtls.Projectdate,101)= CONVERT(varchar(10),getdate(),101)

Hope this is helpful !

Thanks

 

 

 

 

 

hi, it shows the current date not the table entries date
CONVERT(varchar(10),getdate(),101) 

If you want to show table field then do like this

thank u

u r welcome