Comments by demoninside9 (Top 29 by date)

Types don't match between the anchor and the recursive part in column "DateValue" of recursive query "DateList".

same error

Msg 206, Level 16, State 2, Line 1
Operand type clash: date is incompatible with int

Operand type clash: date is incompatible with int


http://www.freeimagehosting.net/4dap1

Incorrect syntax near ')'.


http://www.freeimagehosting.net/eyo2z

http://www.freeimagehosting.net/ahcnt

http://www.freeimagehosting.net/nmaag

Incorrect syntax near ';'.

http://www.freeimagehosting.net/oeyvt

Incorrect syntax near ','.

Command(s) completed successfully.

DECLARE @STARTDATE AS DATE;
DECLARE @EntDt AS DATE;
set @STARTDATE = '06/01/2012';
set @EntDt = '12/31/2012';
declare @dcnt AS int;

with DateList as
(
select @STARTDATE DateValue
union all
select DateValue + 1 from DateList
where DateValue + 1 < convert(VARCHAR(15),@EntDt,101)
)
--INSERT INTO mtblAttendance
--select u.User_Id,
--Convert(VARCHAR(10),CONVERT(DATETIME,CONVERT(VARCHAR(10), DateValue, 121)) + ' 09:30:00', 121) As In_Time,
--Convert(VARCHAR(10),CONVERT(DATETIME,CONVERT(VARCHAR(10), DateValue, 121)) + ' 09:30:00', 121) As Out_Time
--from DateList, mtblEmployee u
--where DATENAME (dw, DateValue ) not IN ( 'Saturday','Sunday' )
--option (maxrecursion 365);

shows error
Incorrect syntax near ')'.

DateTime type

http://www.freeimagehosting.net/biyj4

shows error
Incorrect syntax near the keyword 'CONVERT'.
see the image below >>
http://www.freeimagehosting.net/7mt53

shows error "Operand type clash: date is incompatible with int"
here is the image
http://www.freeimagehosting.net/pfqud

DECLARE @STARTDATE AS DATE;
DECLARE @EntDt AS DATE;
set @STARTDATE = '06/01/2012';
set @EntDt = '12/31/2012';
declare @dcnt AS int;

with DateList as
(
select @STARTDATE DateValue
union all
select DateValue + 1 from DateList
where DateValue + 1 < convert(VARCHAR(15),@EntDt,101)
)
INSERT INTO mtblAttendance
select u.User_Id,
Convert(VARCHAR(10),CONVERT(DATETIME,CONVERT(VARCHAR(10), DateValue, 121)) + ' 09:30:00', 121) As In_Time,
Convert(VARCHAR(10),CONVERT(DATETIME,CONVERT(VARCHAR(10), DateValue, 121)) + ' 09:30:00', 121) As Out_Time
from DateList, mtblEmployee u
where DATE(WEEKDAY, DateValue ) not IN ( 'Saturday','Sunday' )
option (maxrecursion 365);

shows error
'DATE' is not a recognized built-in function name.
see the link http://www.freeimagehosting.net/h3v76

'DATE' is not a recognized built-in function name.

see the link http://www.freeimagehosting.net/h3v76

'DATE' is not a recognized built-in function name.

Column name or number of supplied values does not match table definition.

'VARCHAR' is not a recognized built-in function name.

i am using Sql Server 2008

'DATE' is not a recognized built-in function name.

shows 'DATETIME' is not a recognized built-in function name.

still same error :(

shows error
Msg 156, Level 15, State 1, Line 16
Incorrect syntax near the keyword 'CONVERT'.