Operand type clash: date is incompatible with int

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 2008 Forums

Transact-SQL (2008)

Operand type clash: date is incompatible with int

Author

Topic

kiranmurali
Yak Posting Veteran

55 Posts

Posted - 2011-08-19 : 08:44:39

Hi All,

this is my querry and while running am getting the below error:
Operand type clash: date is incompatible with int

querry
DECLARE @DEPID VARCHAR(500)
SET @DEPID='1,2,3,4'
DECLARE @EMPID VARCHAR(500)
SET @EMPID='1,2,3,4'
DECLARE @LEAVETYPEID VARCHAR(500)
SET @LEAVETYPEID='1,2,3,4'
DECLARE @STATUSID VARCHAR(500)
SET @STATUSID='1,2,3,4'
DECLARE @STARTDATE DATE
SET @STARTDATE='2010-09-09'
DECLARE @ENDDATE DATE
SET @ENDDATE='2011-09-09'
DECLARE @SQL VARCHAR(MAX)
SELECT @SQL=
'SELECT
A.PI_Firstname,
D.LEAVETYPE_NAME AS LEAVETYPE,
C.LEAVESTATUS AS STATUS,
B.LEAVE_FROM,
B.LEAVE_TO,
E.Group_Name as ORGANIZATION,
FUNCTION_DEPARTMENT as FUNCTION_DEPARTMENT,
B.MGR_COMMENTS AS COMMENTS,
G.LOB_Name AS LOB,
H.LOCATION AS LOCATION,
B.NO_DAYS AS NO_DAYS

FROM
PNET_PFILE_DATATABLE1 A,
PNET_PFILE_EMPLOYMENT_INFO A1,
PNET_LEAVE_LEAVE B,
PNET_MASTER_LEAVESTATUS C,
PNET_LEAVE_MASTER_LEAVETYPE D,
PNET_ORG_ORGANIZATION E,
PNET_MASTER_FUNCTION_DEPARTMENT F,
PNET_ORG_LOB G,
PNET_MASTER_LOCATION H
WHERE
B.DEPARTMENTID IN ('+@DEPID+')
AND B.LEAVETYPE_ID IN ('+@LEAVETYPEID+')
AND B.LEAVE_STATUSID IN ('+@STATUSID+')
AND B.EMP_ID IN ('+@EMPID+')
AND B.LEAVE_FROM >= '+CAST(@STARTDATE AS varchar(12))+'
AND B.LEAVE_TO <='+CAST(@ENDDATE AS varchar(12))+'
AND A.PI_EmployeeId=A1.PI_EmployeeId
AND B.LEAVETYPE_ID=D.LEAVETYPE_ID
AND A.PI_EmployeeId=B.EMP_ID
AND B.LEAVE_STATUSID=C.LEAVESTATUS_ID
AND B.DEPARTMENTID=F.FUNCTION_DEPARTMENTID
AND B.ORG_ID=E.ID
AND A1.lobid=G.SesKey
AND A1.LocationID=H.LOCATIONID
AND A.DEL_FLAG=0
AND B.DEL_FLAG=0
AND A1.Del_Flag=0
AND A1.EMPLOYEE_INFO_TYPE=''CE'''

EXEC(@SQL)
can any one help me to solve this problem.

thanks in advance
kiran murali

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-19 : 08:52:12

what are data types of LEAVE_FROM and LEAVE_TO?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

kiranmurali
Yak Posting Veteran

55 Posts

Posted - 2011-08-19 : 08:54:36

LEAVE_FROM & LEAVE_TO data type is date.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-19 : 09:01:08

make it like


....
AND B.LEAVE_FROM >= '''+CAST(@STARTDATE AS varchar(12))+'''
AND B.LEAVE_TO <='''+CAST(@ENDDATE AS varchar(12))+'''

...

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

kiranmurali
Yak Posting Veteran

55 Posts

Posted - 2011-08-19 : 09:43:30

quote:
Originally posted by visakh16

make it like

....
AND B.LEAVE_FROM >= '''+CAST(@STARTDATE AS varchar(12))+'''
AND B.LEAVE_TO <='''+CAST(@ENDDATE AS varchar(12))+'''

...

thanks a lot, its working.
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-19 : 10:52:45

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources