Database

SELECT DISTINCT employee.intEmpID AS ID, employee.strEmpID AS CardReference, 
		CASE WHEN Employee.intStatus = 0 THEN 
			NULL 
        ELSE 
			Employee.strTitle + ' ' + Employee.strForename + ' ' + Employee.strSurname 
		END AS Visitor, 
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			(SELECT TOP 1 Company FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC)
		END As Company,
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			(SELECT TOP 1 VisitorCardEmpId FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC)
		END As ResponsiblePersonnelID,
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			dbo.fnGetEmployeeName((SELECT TOP 1 VisitorCardEmpId FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC))
		END As ResponsiblePersonnel,
		CASE Employee.intStatus 
			WHEN 1 THEN
				-1 
			ELSE 
				0 
		END AS ClockedIn,
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			(SELECT TOP 1 TimeIn FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC)
		END As ArrivalTime
	FROM         Tensor.dbo.tblEmployee AS employee LEFT OUTER JOIN
                      dbo.tblVisitors AS Visitor ON Visitor.intEmpId = employee.intEmpID 
	WHERE     (employee.strEmpID LIKE 'V%')
	ORDER BY CardReference

select ID = Table1.ID
If Table1.Status = 0 Then
Name = Case when Table1.Status = 0 then Table1.Name else Table2.Name end,
Company = case when Table1.Status = 0 then NULL else Table2.Company end
from Table1
inner join Table2 on Table2.ID = Table1.ID

<br />
TRUNCATE TABLE tablename<br />

razov wrote:

Solution 1 - you will have to delete foreign key occurence of the data first and then delete primary key occurence or you'll get reference error which I think you are facing currently,

SELECT 
    FK_Table  = FK.TABLE_NAME, 
    FK_Column = CU.COLUMN_NAME, 
    PK_Table  = PK.TABLE_NAME, 
    PK_Column = PT.COLUMN_NAME, 
    Constraint_Name = C.CONSTRAINT_NAME 
FROM 
    INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C 
    INNER JOIN 
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK 
        ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME 
    INNER JOIN 
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK 
        ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME 
    INNER JOIN 
    INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU 
        ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME 
    INNER JOIN 
    ( 
        SELECT 
            i1.TABLE_NAME, i2.COLUMN_NAME 
        FROM 
            INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1 
            INNER JOIN 
            INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 
            ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME 
            WHERE i1.CONSTRAINT_TYPE = 'PRIMARY KEY' 
    ) PT 
    ON PT.TABLE_NAME = PK.TABLE_NAME 
-- optional: 
ORDER BY 
    1,2,3,4

WHERE PK.TABLE_NAME='something'

WHERE FK.TABLE_NAME='something'

WHERE PK.TABLE_NAME IN ('one_thing', 'another')

WHERE FK.TABLE_NAME IN ('one_thing', 'another')

select distinct data,<br />
(select top 1 (t1.num) from myTable as t1 where t1.data = myTable.data order by t1.id ) as firstRow,<br />
(select top 1 (t2.num) from myTable as t2 where t2.data = myTable.data order by t2.id desc) as LastRow<br />
 from myTable