Yes, ranking functions might work; however, I assumed that since this was a SQL Server 7, 2000 forum that an SQL 2005 only option would not be viable. Is...

Oh, my! I last saw a Raima database in 1996. Brr! Cold!

Perhaps something like:

declare @test-2 table (aName varchar(10))

insert into @test-2

select 'scott' union all

select 'Tiger' union all

select 'Huli' union all

select 'abrash'

--select * from @test-2

declare @accum varchar(max)...

Thank you for picking me up, Jeff.

Amazing; obviously not your fault, but amazing.

create either a temp table or a table variable to store the serial numbers and then use a SELECT statement to generate the serial numbers -- something like:

declare @serialNo table

(...

Go ahead and work on this as a temp table exercise; however, you might also want to consider making this a permanent table. Here is a link that discusses...

It looks to me like you might have a trigger that does not properly handle multi-record updates. Check and see if the table that is the target of the...

An article that shows some use of CONTEXT_INFO can be found here at the MS Common Solutions site:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=AuditOrBypassTriggerExecution&referringTitle=Home

While this is not the same thing that you are wanting,...

Is what you are looking for basically something along the line of:

create procedure emp_proc @nameParm varchar(30)

as

SELECT Emp_No,Emp_Name FROM...

Congratulations, Gail. Well deserved and well done. 🙂

Kent

Congratulations to Jeff and Michael and a hearty round of applause. 🙂

Well done.

One thing you can do is to convert your varchar time to its lowest granularity -- seconds -- and then sum the seconds.

EDIT:

For example, perhaps something like:

declare @test-2...

Mike:

You might be able to use expression "OBJECT_NAME(@@ProcID)" to obtain the name of a calling procedure. This information could in turn be stored in the CONTEXT_INFO to save the...

Well, you seem to want to use the PIVOT operator, but you have posted in the SQL 2000 forum. The PIVOT operator is not available in SQL 2000. ...