It should be

CAST(IA.IAT_DATA AS VARCHAR(25)) AS Subject

I have tried this, and it seems to work.

SELECT COUNT(*) FROM card_pins WITH (TABLOCK, HOLDLOCK)

Put this as the first line after BEGIN TRAN. On Commit the lock is released.

Remi, you query returns count of clock records on each date - an employee may have 10 clock records on that day but it has to return 1 for that...

That was quick.

Thanks Lynn

This is not an actual table but a query. For simplicity sake, I had given the output as a table.

Thanks anyway.

If the SP just does that, you do not need a cursor

INSERT INTO INET.dbo.jones_report (ReportNumber, Adjuster, RGnameLast, ClientOffice, IOofficeName, WRworkOfficeID, WRid, Subject, FilterDate, ClaimNumber, VideoAmount, CaseCost, Results, WRinjury, WRnotes)

SELECT...

This might help

http://www.lumigent.com/downloads/general_toolkit2.asp

This will not work if you have 2 (or more) clock record at the same start time for different employees. The time clock table also holds clock records for jobs done...

if object_id( 'tempdb..#Temp' ) is not null  drop table #Temp

SELECT TOP 15000 .....

ORDER BY NEWID()

SELECT   CONVERT(varchar(10), current_timestamp, 110)

Not sure if you still need a stored procedure.

Create a SP that accepts parameters of all columns for the table with a default of Null.

Update TableA SET col1 = COALESCE(@col1, col1) , col2 = COALESCE(@col2, col2), .....

where...

DECLARE @t TABLE ( ID int, Dt datetime)

INSERT INTO @t VALUES (1,'2006-06-29 10:00')

INSERT INTO @t VALUES (2,'2006-06-29 11:00')

INSERT INTO @t VALUES (3,'2006-06-29 12:00')

INSERT INTO @t VALUES (4,'2006-06-29 13:00')

SELECT t1.ID, t1.Dt,...

The query timeout is set to 30 seconds in the app. How can I set the LockTimeout in my .Net application ?

Search for "Split" in the script section and you will get quite a few funtions.

Here in one that I have used

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=592