Database

<br />
SELECT ISNULL(smv.definition, ssmv.definition) AS [Definition]<br />
FROM sys.all_views AS v<br />
LEFT OUTER JOIN sys.sql_modules AS smv ON smv.object_id = v.object_id<br />
LEFT OUTER JOIN sys.system_sql_modules AS ssmv ON ssmv.object_id = v.object_id<br />
WHERE (v.type = 'V')and(v.name=N'{my_view_name}' and SCHEMA_NAME(v.schema_id)=N'dbo')<br />

SELECT main.EmpId, main.Date, 
(SELECT i.EventTime FROM Attendance i 
WHERE i.EmpID = main.EmpId AND 
i.Date = main.Date AND i.Login_Type = 'I') AS ShiftInTime, 
(SELECT o.EventTime FROM Attendance o
WHERE o.EmpID = main.EmpID AND
o.Date = main.Date AND o.Login_Type = 'O') AS ShiftOutTime
FROM Attendance main

SELECT main.UserName, <br />
(SELECT i.EventTime FROM History i  <br />
WHERE i.FuncCode="0") AS InTime, <br />
(SELECT o.EventTime FROM History o  <br />
WHERE o.FuncCode="10") AS  OutTime <br />
FROM  History main

SELECT     
  h.EmpID, 
  h.[Date], 
  h.EventTime AS ShiftInTime, 
  h2.EventTime AS ShiftOutTime
FROM 
  History h 
LEFT OUTER JOIN
  History h2 
ON 
  h.EmpID = h2.EmpID AND 
  h.[Date] = h2.[Date] AND 
  h2.EventCode = 'O'
WHERE
  h.EventCode = 'I'

SELECT h.UserName, h.EventDate, h.EventTime AS InTime, h2.EventTime AS OutTime, h.Dept<br />
FROM History AS h LEFT JOIN History AS h2 ON (h.UserName = h2.UserName) AND (h.EventDate = h2.EventDate)<br />
WHERE (((h.EventDate)=#2/24/2006#) AND ([h.FuncCode]="0") AND ([h2.FuncCode]="10") AND ((h.Dept)="Engg"));