Hi, maybe this can help you. i did a similiar thing to what you are trying, just adapt your temp table and select query for the BCP...

CREATE PROCEDURE [dbo].[PROC_NAME]

AS

BEGIN

declare @CLOCKINGS...

yeah, it's a Kronos labour management system.

that first part rocks, Sreejith you the man!

now comes the trick, here's my query:

SELECT ssMainData.dbo.ssTagHolders.EmployeeNumber, LEFT(dbo.ssAccessLog.DateTime, CHARINDEX(' ', dbo.ssAccessLog.DateTime,...