Whoops did not realize this was SQL 2000 - sorry Thanks Sergiy

Have you looked at ROW_NUMBER (Transact-SQL) in BOL? It is very useful and quite fast for...

yulichka

SELECT COUNT(*) AS 'Staff Count'

FROM #Table GROUP BY DATEPART(m, SignIn),DATEPART(d, SignIn),DATEPART(yy, SignIn),DATEPART(hh, SignIn)

for your use just substitute the fully qualified table name as your schema name your tables name...

and

check for valid data in the table...

Using T-SQL and a temporary table for illustration

CREATE TABLE #Table

(SignIn DATETIME)

INSERT INTO #Table

SELECT '4/6/2009 6:10:17 AM' UNION ALL

SELECT '4/6/2009 6:10:51 AM' UNION ALL

SELECT '4/6/2009 6:11:22 AM' UNION ALL

SELECT...

john_chrome

Step 1. Import all the data without any additional processing this is what I imitated in creating the temporary table #Table1.

Step 2. Identify all rows in #Table1 that...

Assuming I read your post correctly and more importantly what the Cursor was utilized for, you might want to try the following to eliminate the Row by Row cursor processing

CREATE...

From Dataphor SQL RAC

Dataphor - Sql: what does Update..From mean?

What is really wrong with the "UPDATE.. FROM.." syntax?

This example uses MS Sql Server 2005

and

the D4 language of...

Removed as confusing to too many

Paul care to post some code that shows an example of where a cursor...

I highly recommend an article by Jeff Moden

http://www.sqlservercentral.com/articles/TSQL/62867/

If you really want to get into the depths of replacing a cursor follow this forum here on SSC

http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx

In the msdb database check the following stored procedure:

sp_sqlagent_log_jobhistory - I believe it is what you are looking for. It is a long proc so read it all.

I am going to guess the answer is Yes. But with the data you have given, it is difficult if not impossible to assist you. Please read the...

Are you sure you are passing in a value - paraphrasing your procedure

CREATE PROC dbo.myproc

@Exists INT

AS

IF @EXISTS = 1

BEGIN

PRINT 'UPDATE METHOD HERE'

END

IF @EXISTS =0

BEGIN

PRINT 'INSERT METHOD HERE'

END

dbo.myproc NULL -- imitating...

Suggest that you view this School Video by Randy Warren

http://www.sqlservercentral.com/articles/Video/65076/. It appears to fit perfectly as a answer to your problem

I know that this will not be the real answer to your final deployment on a hosted server, but have you examined the availability of SQL Server 2008 DEVELOPER EDITION....