date between query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

date between query

Author

Topic

ramesh.g
Starting Member

11 Posts

Posted - 2010-10-05 : 07:21:43

MY stored procedure is below which work properly

ALTER PROCEDURE [dbo].[placement_pundit_advance_search] --'UploadDate between ''01/01/1900 00:00:00'' and ''5/10/2010 00:00:00'''
@SearchCriteria varchar(525)
AS
declare @sql varchar(max)
BEGIN
set @sql = 'SELECT jr.BackGround,Convert(datetime, jr.UploadDate,103) as UploadDate ,jr.Career,jr.Credentials,jr.CVDetails,jr.Email,jr.JSPerID,jr.JSProfID,jr.Phone,jr.Suitability,Convert(datetime,UploadDate,103) as UploadDate,bk.point2,bk.point1,bk.point3 FROM JobSeeker_Professional jr
Inner Join background bk On jr.BackGround=bk.backid where ' + @SearchCriteria
exec(@sql)
END

but when i execute it through browser it gives error below

An expression of non-boolean type specified in a context where a condition is expected, near 'UploadDate between ''01/01/1900 00:00:00'' and ''05/10/2010 00:00:00'' '.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An expression of non-boolean type specified in a context where a condition is expected, near 'UploadDate between ''01/01/1900 00:00:00'' and ''05/10/2010 00:00:00'' '.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-10-05 : 08:06:28

Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151082

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources