|
|
Hi,
Once again thanks for your interest and support shown for this article. You can find a revised version of the this article under Custom Tab Control[^]
|
|
|
|
|
BEGIN TRANSACTION
CREATE TABLE #TempAttInfo (StaffPIN VARCHAR(8),AttDate DATETIME,AttTime DATETIME)
Insert into #TempAttInfo Values ('00000007','Jan 27 2016','Jan 27 2016 10:29AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 10:27AM')
GO
Insert into #TempAttInfo Values ('00000289','Jan 27 2016','Jan 27 2016 10:26AM')
GO
Insert into #TempAttInfo Values ('00000441','Jan 27 2016','Jan 27 2016 10:19AM')
GO
Insert into #TempAttInfo Values ('00000163','Jan 27 2016','Jan 27 2016 10:19AM')
GO
Insert into #TempAttInfo Values ('00000589','Jan 27 2016','Jan 27 2016 10:15AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 10:12AM')
GO
Insert into #TempAttInfo Values ('00000615','Jan 27 2016','Jan 27 2016 10:11AM')
GO
Insert into #TempAttInfo Values ('00000481','Jan 27 2016','Jan 27 2016 10:10AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 10:08AM')
GO
Insert into #TempAttInfo Values ('00000685','Jan 27 2016','Jan 27 2016 10:04AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 10:04AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 9:54AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 9:53AM')
GO
Insert into #TempAttInfo Values ('00000407','Jan 27 2016','Jan 27 2016 9:52AM')
GO
Insert into #TempAttInfo Values ('00000666','Jan 27 2016','Jan 27 2016 9:52AM')
GO
Insert into #TempAttInfo Values ('00000441','Jan 27 2016','Jan 27 2016 9:52AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 9:51AM')
GO
Insert into #TempAttInfo Values ('00000381','Jan 27 2016','Jan 27 2016 9:50AM')
GO
Insert into #TempAttInfo Values ('00000409','Jan 27 2016','Jan 27 2016 9:49AM')
GO
Insert into #TempAttInfo Values ('00000126','Jan 27 2016','Jan 27 2016 9:49AM')
GO
Insert into #TempAttInfo Values ('00000702','Jan 27 2016','Jan 27 2016 9:48AM')
GO
Insert into #TempAttInfo Values ('00000042','Jan 27 2016','Jan 27 2016 9:48AM')
GO
Insert into #TempAttInfo Values ('00000634','Jan 27 2016','Jan 27 2016 9:47AM')
GO
Insert into #TempAttInfo Values ('00000473','Jan 27 2016','Jan 27 2016 9:46AM')
GO
Insert into #TempAttInfo Values ('00000631','Jan 27 2016','Jan 27 2016 9:46AM')
GO
Insert into #TempAttInfo Values ('00000074','Jan 27 2016','Jan 27 2016 9:46AM')
GO
Insert into #TempAttInfo Values ('00000033','Jan 27 2016','Jan 27 2016 9:45AM')
GO
Insert into #TempAttInfo Values ('00000225','Jan 27 2016','Jan 27 2016 9:44AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:44AM')
GO
Insert into #TempAttInfo Values ('00000583','Jan 27 2016','Jan 27 2016 9:41AM')
GO
Insert into #TempAttInfo Values ('00000268','Jan 27 2016','Jan 27 2016 9:41AM')
GO
Insert into #TempAttInfo Values ('00000599','Jan 27 2016','Jan 27 2016 9:38AM')
GO
Insert into #TempAttInfo Values ('00000637','Jan 27 2016','Jan 27 2016 9:38AM')
GO
Insert into #TempAttInfo Values ('00000678','Jan 27 2016','Jan 27 2016 9:37AM')
GO
Insert into #TempAttInfo Values ('00000596','Jan 27 2016','Jan 27 2016 9:36AM')
GO
Insert into #TempAttInfo Values ('00000626','Jan 27 2016','Jan 27 2016 9:36AM')
GO
Insert into #TempAttInfo Values ('00000628','Jan 27 2016','Jan 27 2016 9:36AM')
GO
Insert into #TempAttInfo Values ('00000149','Jan 27 2016','Jan 27 2016 9:35AM')
GO
Insert into #TempAttInfo Values ('00000603','Jan 27 2016','Jan 27 2016 9:35AM')
GO
Insert into #TempAttInfo Values ('00000326','Jan 27 2016','Jan 27 2016 9:34AM')
GO
Insert into #TempAttInfo Values ('00000485','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000418','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000433','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000320','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000230','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000603','Jan 27 2016','Jan 27 2016 9:30AM')
GO
Insert into #TempAttInfo Values ('00000638','Jan 27 2016','Jan 27 2016 9:30AM')
GO
Insert into #TempAttInfo Values ('00000702','Jan 27 2016','Jan 27 2016 9:26AM')
GO
Insert into #TempAttInfo Values ('00000700','Jan 27 2016','Jan 27 2016 9:26AM')
GO
Insert into #TempAttInfo Values ('00000664','Jan 27 2016','Jan 27 2016 9:24AM')
GO
Insert into #TempAttInfo Values ('00000659','Jan 27 2016','Jan 27 2016 9:22AM')
GO
Insert into #TempAttInfo Values ('00000665','Jan 27 2016','Jan 27 2016 9:21AM')
GO
Insert into #TempAttInfo Values ('00000413','Jan 27 2016','Jan 27 2016 9:21AM')
GO
Insert into #TempAttInfo Values ('00000655','Jan 27 2016','Jan 27 2016 9:21AM')
GO
Insert into #TempAttInfo Values ('00000459','Jan 27 2016','Jan 27 2016 9:19AM')
GO
Insert into #TempAttInfo Values ('00000632','Jan 27 2016','Jan 27 2016 9:18AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 9:17AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:17AM')
GO
Insert into #TempAttInfo Values ('00000245','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000636','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000386','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000668','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000344','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000066','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000660','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000692','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000585','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000242','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000619','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000678','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000478','Jan 27 2016','Jan 27 2016 9:13AM')
GO
Insert into #TempAttInfo Values ('00000408','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000404','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000704','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000697','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000023','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000627','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000620','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000698','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000066','Jan 27 2016','Jan 27 2016 9:10AM')
GO
Insert into #TempAttInfo Values ('00000481','Jan 27 2016','Jan 27 2016 9:10AM')
GO
Insert into #TempAttInfo Values ('00000634','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000461','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000277','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000063','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000066','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000469','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000656','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000474','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000414','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000606','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:07AM')
GO
Insert into #TempAttInfo Values ('00000001','Jan 27 2016','Jan 27 2016 9:07AM')
GO
Insert into #TempAttInfo Values ('00000682','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000690','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000670','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000639','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000074','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000658','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000462','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000007','Jan 27 2016','Jan 27 2016 9:05AM')
GO
Insert into #TempAttInfo Values ('00000676','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000303','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000007','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000315','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000467','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000163','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000485','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000019','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000208','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000630','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:02AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:02AM')
GO
Insert into #TempAttInfo Values ('00000672','Jan 27 2016','Jan 27 2016 9:02AM')
GO
Insert into #TempAttInfo Values ('00000675','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000703','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000162','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000500','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000364','Jan 27 2016','Jan 27 2016 8:55AM')
GO
Insert into #TempAttInfo Values ('00000603','Jan 27 2016','Jan 27 2016 8:55AM')
GO
Insert into #TempAttInfo Values ('00000602','Jan 27 2016','Jan 27 2016 8:54AM')
GO
Insert into #TempAttInfo Values ('00000701','Jan 27 2016','Jan 27 2016 8:53AM')
GO
Insert into #TempAttInfo Values ('00000026','Jan 27 2016','Jan 27 2016 8:53AM')
GO
Insert into #TempAttInfo Values ('00000370','Jan 27 2016','Jan 27 2016 8:53AM')
GO
Insert into #TempAttInfo Values ('00000370','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000689','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000688','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000336','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000195','Jan 27 2016','Jan 27 2016 8:51AM')
GO
Insert into #TempAttInfo Values ('00000498','Jan 27 2016','Jan 27 2016 8:51AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 8:51AM')
GO
Insert into #TempAttInfo Values ('00000679','Jan 27 2016','Jan 27 2016 8:50AM')
GO
Insert into #TempAttInfo Values ('00000026','Jan 27 2016','Jan 27 2016 8:50AM')
GO
Insert into #TempAttInfo Values ('00000687','Jan 27 2016','Jan 27 2016 8:50AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000679','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000193','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000667','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000579','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000026','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000659','Jan 27 2016','Jan 27 2016 8:46AM')
GO
Insert into #TempAttInfo Values ('00000499','Jan 27 2016','Jan 27 2016 8:46AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 8:46AM')
GO
Insert into #TempAttInfo Values ('00000416','Jan 27 2016','Jan 27 2016 8:41AM')
GO
Insert into #TempAttInfo Values ('00000315','Jan 27 2016','Jan 27 2016 8:41AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 8:41AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 8:40AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 8:39AM')
GO
Insert into #TempAttInfo Values ('00000289','Jan 27 2016','Jan 27 2016 8:36AM')
GO
Insert into #TempAttInfo Values ('00000289','Jan 27 2016','Jan 27 2016 8:35AM')
GO
Insert into #TempAttInfo Values ('00000106','Jan 27 2016','Jan 27 2016 8:32AM')
GO
Insert into #TempAttInfo Values ('00000106','Jan 27 2016','Jan 27 2016 8:31AM')
GO
Insert into #TempAttInfo Values ('00000587','Jan 27 2016','Jan 27 2016 8:20AM')
GO
Insert into #TempAttInfo Values ('00000587','Jan 27 2016','Jan 27 2016 8:16AM')
GO
Insert into #TempAttInfo Values ('00000593','Jan 27 2016','Jan 27 2016 8:03AM')
GO
SELECT * FROM #TempAttInfo
DECLARE @StaffPIN VARCHAR(8)
DECLARE @AttDate DATETIME
DECLARE @AttTime DATETIME
DECLARE Att_Cursor CURSOR FOR
SELECT * FROM #TempAttInfo a
INNER JOIN Staff AS s ON a.StaffPIN = b.StaPIN
OPEN Att_Cursor
FETCH NEXT FROM Att_Cursor INTO @StaffPIN, @AttDate, @AttTime
WHILE @@FETCH_STATUS = 0
BEGIN
IF NOT EXISTS (SELECT * FROM StaffDailyAttendance WHERE SdaPIN = @StaffPIN AND SdaAttDate = @AttDate)
BEGIN
INSERT INTO StaffDailyAttendance
(
SdaPIN,SdaAttDate,SdaTimeIn,SdaTimeOut,SdaInTerminal,SdaOutTerminal,SdaInNote,SdaOutNote,Setdate,UserName
)
SELECT @StaffPIN,@AttDate,@AttTime,NULL,'ATTEDANCESTL',NULL,NULL,'27-Jan-2016','stl'
END
FETCH NEXT FROM Att_Cursor @StaffPIN, @AttDate, @AttTime
END
CLOSE Att_Cursor
DEALLOCATE Att_Cursor
DROP TABLE #TempAttInfo
ROLLBACK TRANSACTION
|
|
|
|
|
BEGIN TRANSACTION
CREATE TABLE #TempAttInfo (StaffPIN VARCHAR(8),AttDate DATETIME,AttTime DATETIME)
Insert into #TempAttInfo Values ('00000007','Jan 27 2016','Jan 27 2016 10:29AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 10:27AM')
GO
Insert into #TempAttInfo Values ('00000289','Jan 27 2016','Jan 27 2016 10:26AM')
GO
Insert into #TempAttInfo Values ('00000441','Jan 27 2016','Jan 27 2016 10:19AM')
GO
Insert into #TempAttInfo Values ('00000163','Jan 27 2016','Jan 27 2016 10:19AM')
GO
Insert into #TempAttInfo Values ('00000589','Jan 27 2016','Jan 27 2016 10:15AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 10:12AM')
GO
Insert into #TempAttInfo Values ('00000615','Jan 27 2016','Jan 27 2016 10:11AM')
GO
Insert into #TempAttInfo Values ('00000481','Jan 27 2016','Jan 27 2016 10:10AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 10:08AM')
GO
Insert into #TempAttInfo Values ('00000685','Jan 27 2016','Jan 27 2016 10:04AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 10:04AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 9:54AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 9:53AM')
GO
Insert into #TempAttInfo Values ('00000407','Jan 27 2016','Jan 27 2016 9:52AM')
GO
Insert into #TempAttInfo Values ('00000666','Jan 27 2016','Jan 27 2016 9:52AM')
GO
Insert into #TempAttInfo Values ('00000441','Jan 27 2016','Jan 27 2016 9:52AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 9:51AM')
GO
Insert into #TempAttInfo Values ('00000381','Jan 27 2016','Jan 27 2016 9:50AM')
GO
Insert into #TempAttInfo Values ('00000409','Jan 27 2016','Jan 27 2016 9:49AM')
GO
Insert into #TempAttInfo Values ('00000126','Jan 27 2016','Jan 27 2016 9:49AM')
GO
Insert into #TempAttInfo Values ('00000702','Jan 27 2016','Jan 27 2016 9:48AM')
GO
Insert into #TempAttInfo Values ('00000042','Jan 27 2016','Jan 27 2016 9:48AM')
GO
Insert into #TempAttInfo Values ('00000634','Jan 27 2016','Jan 27 2016 9:47AM')
GO
Insert into #TempAttInfo Values ('00000473','Jan 27 2016','Jan 27 2016 9:46AM')
GO
Insert into #TempAttInfo Values ('00000631','Jan 27 2016','Jan 27 2016 9:46AM')
GO
Insert into #TempAttInfo Values ('00000074','Jan 27 2016','Jan 27 2016 9:46AM')
GO
Insert into #TempAttInfo Values ('00000033','Jan 27 2016','Jan 27 2016 9:45AM')
GO
Insert into #TempAttInfo Values ('00000225','Jan 27 2016','Jan 27 2016 9:44AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:44AM')
GO
Insert into #TempAttInfo Values ('00000583','Jan 27 2016','Jan 27 2016 9:41AM')
GO
Insert into #TempAttInfo Values ('00000268','Jan 27 2016','Jan 27 2016 9:41AM')
GO
Insert into #TempAttInfo Values ('00000599','Jan 27 2016','Jan 27 2016 9:38AM')
GO
Insert into #TempAttInfo Values ('00000637','Jan 27 2016','Jan 27 2016 9:38AM')
GO
Insert into #TempAttInfo Values ('00000678','Jan 27 2016','Jan 27 2016 9:37AM')
GO
Insert into #TempAttInfo Values ('00000596','Jan 27 2016','Jan 27 2016 9:36AM')
GO
Insert into #TempAttInfo Values ('00000626','Jan 27 2016','Jan 27 2016 9:36AM')
GO
Insert into #TempAttInfo Values ('00000628','Jan 27 2016','Jan 27 2016 9:36AM')
GO
Insert into #TempAttInfo Values ('00000149','Jan 27 2016','Jan 27 2016 9:35AM')
GO
Insert into #TempAttInfo Values ('00000603','Jan 27 2016','Jan 27 2016 9:35AM')
GO
Insert into #TempAttInfo Values ('00000326','Jan 27 2016','Jan 27 2016 9:34AM')
GO
Insert into #TempAttInfo Values ('00000485','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000418','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000433','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000320','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000230','Jan 27 2016','Jan 27 2016 9:32AM')
GO
Insert into #TempAttInfo Values ('00000603','Jan 27 2016','Jan 27 2016 9:30AM')
GO
Insert into #TempAttInfo Values ('00000638','Jan 27 2016','Jan 27 2016 9:30AM')
GO
Insert into #TempAttInfo Values ('00000702','Jan 27 2016','Jan 27 2016 9:26AM')
GO
Insert into #TempAttInfo Values ('00000700','Jan 27 2016','Jan 27 2016 9:26AM')
GO
Insert into #TempAttInfo Values ('00000664','Jan 27 2016','Jan 27 2016 9:24AM')
GO
Insert into #TempAttInfo Values ('00000659','Jan 27 2016','Jan 27 2016 9:22AM')
GO
Insert into #TempAttInfo Values ('00000665','Jan 27 2016','Jan 27 2016 9:21AM')
GO
Insert into #TempAttInfo Values ('00000413','Jan 27 2016','Jan 27 2016 9:21AM')
GO
Insert into #TempAttInfo Values ('00000655','Jan 27 2016','Jan 27 2016 9:21AM')
GO
Insert into #TempAttInfo Values ('00000459','Jan 27 2016','Jan 27 2016 9:19AM')
GO
Insert into #TempAttInfo Values ('00000632','Jan 27 2016','Jan 27 2016 9:18AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 9:17AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:17AM')
GO
Insert into #TempAttInfo Values ('00000245','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000636','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000386','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000668','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000344','Jan 27 2016','Jan 27 2016 9:16AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000066','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000660','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000692','Jan 27 2016','Jan 27 2016 9:15AM')
GO
Insert into #TempAttInfo Values ('00000585','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000242','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000619','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000678','Jan 27 2016','Jan 27 2016 9:14AM')
GO
Insert into #TempAttInfo Values ('00000478','Jan 27 2016','Jan 27 2016 9:13AM')
GO
Insert into #TempAttInfo Values ('00000408','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000404','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000704','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000697','Jan 27 2016','Jan 27 2016 9:12AM')
GO
Insert into #TempAttInfo Values ('00000023','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000627','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000620','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000698','Jan 27 2016','Jan 27 2016 9:11AM')
GO
Insert into #TempAttInfo Values ('00000066','Jan 27 2016','Jan 27 2016 9:10AM')
GO
Insert into #TempAttInfo Values ('00000481','Jan 27 2016','Jan 27 2016 9:10AM')
GO
Insert into #TempAttInfo Values ('00000634','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000461','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000277','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000063','Jan 27 2016','Jan 27 2016 9:09AM')
GO
Insert into #TempAttInfo Values ('00000066','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000469','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000656','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000474','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000414','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000606','Jan 27 2016','Jan 27 2016 9:08AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:07AM')
GO
Insert into #TempAttInfo Values ('00000001','Jan 27 2016','Jan 27 2016 9:07AM')
GO
Insert into #TempAttInfo Values ('00000682','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000690','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000670','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000639','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000074','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000658','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000462','Jan 27 2016','Jan 27 2016 9:06AM')
GO
Insert into #TempAttInfo Values ('00000007','Jan 27 2016','Jan 27 2016 9:05AM')
GO
Insert into #TempAttInfo Values ('00000676','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000303','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000007','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000315','Jan 27 2016','Jan 27 2016 9:04AM')
GO
Insert into #TempAttInfo Values ('00000467','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000163','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000485','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000019','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000208','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000630','Jan 27 2016','Jan 27 2016 9:03AM')
GO
Insert into #TempAttInfo Values ('00000035','Jan 27 2016','Jan 27 2016 9:02AM')
GO
Insert into #TempAttInfo Values ('00000423','Jan 27 2016','Jan 27 2016 9:02AM')
GO
Insert into #TempAttInfo Values ('00000672','Jan 27 2016','Jan 27 2016 9:02AM')
GO
Insert into #TempAttInfo Values ('00000675','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000703','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000162','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000500','Jan 27 2016','Jan 27 2016 9:01AM')
GO
Insert into #TempAttInfo Values ('00000364','Jan 27 2016','Jan 27 2016 8:55AM')
GO
Insert into #TempAttInfo Values ('00000603','Jan 27 2016','Jan 27 2016 8:55AM')
GO
Insert into #TempAttInfo Values ('00000602','Jan 27 2016','Jan 27 2016 8:54AM')
GO
Insert into #TempAttInfo Values ('00000701','Jan 27 2016','Jan 27 2016 8:53AM')
GO
Insert into #TempAttInfo Values ('00000026','Jan 27 2016','Jan 27 2016 8:53AM')
GO
Insert into #TempAttInfo Values ('00000370','Jan 27 2016','Jan 27 2016 8:53AM')
GO
Insert into #TempAttInfo Values ('00000370','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000689','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000688','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000336','Jan 27 2016','Jan 27 2016 8:52AM')
GO
Insert into #TempAttInfo Values ('00000195','Jan 27 2016','Jan 27 2016 8:51AM')
GO
Insert into #TempAttInfo Values ('00000498','Jan 27 2016','Jan 27 2016 8:51AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 8:51AM')
GO
Insert into #TempAttInfo Values ('00000679','Jan 27 2016','Jan 27 2016 8:50AM')
GO
Insert into #TempAttInfo Values ('00000026','Jan 27 2016','Jan 27 2016 8:50AM')
GO
Insert into #TempAttInfo Values ('00000687','Jan 27 2016','Jan 27 2016 8:50AM')
GO
Insert into #TempAttInfo Values ('00000696','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000679','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000193','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000667','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000579','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000026','Jan 27 2016','Jan 27 2016 8:49AM')
GO
Insert into #TempAttInfo Values ('00000659','Jan 27 2016','Jan 27 2016 8:46AM')
GO
Insert into #TempAttInfo Values ('00000499','Jan 27 2016','Jan 27 2016 8:46AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 8:46AM')
GO
Insert into #TempAttInfo Values ('00000416','Jan 27 2016','Jan 27 2016 8:41AM')
GO
Insert into #TempAttInfo Values ('00000315','Jan 27 2016','Jan 27 2016 8:41AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 8:41AM')
GO
Insert into #TempAttInfo Values ('00000657','Jan 27 2016','Jan 27 2016 8:40AM')
GO
Insert into #TempAttInfo Values ('00000238','Jan 27 2016','Jan 27 2016 8:39AM')
GO
Insert into #TempAttInfo Values ('00000289','Jan 27 2016','Jan 27 2016 8:36AM')
GO
Insert into #TempAttInfo Values ('00000289','Jan 27 2016','Jan 27 2016 8:35AM')
GO
Insert into #TempAttInfo Values ('00000106','Jan 27 2016','Jan 27 2016 8:32AM')
GO
Insert into #TempAttInfo Values ('00000106','Jan 27 2016','Jan 27 2016 8:31AM')
GO
Insert into #TempAttInfo Values ('00000587','Jan 27 2016','Jan 27 2016 8:20AM')
GO
Insert into #TempAttInfo Values ('00000587','Jan 27 2016','Jan 27 2016 8:16AM')
GO
Insert into #TempAttInfo Values ('00000593','Jan 27 2016','Jan 27 2016 8:03AM')
GO
SELECT * FROM #TempAttInfo
DECLARE @StaffPIN VARCHAR(8)
DECLARE @AttDate DATETIME
DECLARE @AttTime DATETIME
DECLARE Att_Cursor CURSOR FOR
SELECT * FROM #TempAttInfo a
INNER JOIN Staff AS s ON a.StaffPIN = b.StaPIN
OPEN Att_Cursor
FETCH NEXT FROM Att_Cursor INTO @StaffPIN, @AttDate, @AttTime
WHILE @@FETCH_STATUS = 0
BEGIN
IF NOT EXISTS (SELECT * FROM StaffDailyAttendance WHERE SdaPIN = @StaffPIN AND SdaAttDate = @AttDate)
BEGIN
INSERT INTO StaffDailyAttendance
(
SdaPIN,SdaAttDate,SdaTimeIn,SdaTimeOut,SdaInTerminal,SdaOutTerminal,SdaInNote,SdaOutNote,Setdate,UserName
)
SELECT @StaffPIN,@AttDate,@AttTime,NULL,'ATTEDANCESTL',NULL,NULL,'27-Jan-2016','stl'
END
FETCH NEXT FROM Att_Cursor @StaffPIN, @AttDate, @AttTime
END
CLOSE Att_Cursor
DEALLOCATE Att_Cursor
DROP TABLE #TempAttInfo
ROLLBACK TRANSACTION
|
|
|
|
|
The method has been used two months back. But here we have a problem. We can not give the border color to the Tab Heads. Or we can draw the tab heads and on this no controls can be dragged and dropped. The controls has to be added using code behind. Can any body solve this problem. If possible, please let me know. Thanks in adwance.
Pradeep K. V.
|
|
|
|
|
hi,
In my code i used something else for background color. Will you use this this insted of that.
backBrush = new System.Drawing.Drawing2D.LinearGradientBrush(e.Bounds, Color.Blue, Color.Gold, System.Drawing.Drawing2D.LinearGradientMode.Vertical);
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
Hi,
Once again thanks for your interest and support shown for this article. You can find a revised version of the this article under Custom Tab Control[^]
|
|
|
|
|