sorry i mis understood, i thought you wanted each of the lower TASKs..

in that case, i'd use the row_number() feature and an outer select:

SELECT * FROM (

select row_number()over (PARTITION BY...

you can use the default trace, and hopefully find what happened;

here is aan example:

-- obtain file name for Default Trace

declare @TraceFileName nvarchar(256)

set @TraceFileName = (select path from sys.traces where...

search the "Scripts" section here on SSC for "Split Function"

there are a lot of great contributions there;

they typically expect a varchar string and a delimiter to split them by:

for example:

select...

here's an example which gets the lowest task for each row; you simply compare the column values in a case statement. that will get you started on which tasks to...

you started a second thread on the same issue.. a lot of posters asked for clarification, and you never replied.

we really need an explanation of the format of the string.

you...

you have to install the Oracle Client tools on the server, set up the TNSNAMES.ORA and SQLNET.ORA files so you can actually connect with SQLPLUS or other Oracle utilities like...

I answered in the other thread that was alonst the same subject:

a specific example for you:

create proc test ()

as

begin

BEGIN TRAN

update table1 WITH(TABLOCKX)................

Insert into table 2 WITH(TABLOCKX)...................

not sure why you'd want to lock a table up, but I would do it with a transaction.

one of the HINTs you can use is to exclusively lock a table:

From...

interesting;

i used the default trace and my own DML trace to see what it was doing.

the code you posted executes and created a stored procedure.,

the procedure gets encrypted, so...

was this post just a way to infect a computer by executing code you don't know what it does?

i know once wayne identified it, you got it, but here's an example of what i tested as a result of reading this thread:

SELECT

A.NAME,

STR(CAST(SUM(SIZE)...

server side traces using sp_trace_create are low impact and a good way to track recent changes.

when you create a trace, there is an expectation that you only keep X number...

MS is bringing you kicking and screaming into a more secure password structure. there may be ways around it, but they made it a lot harder to leave systems unsecure.

here's...

in my case, i do all my calculations in the SQL, instead of in the report....

so my SQL would have one more field, that has this for the calculation:

(A_Rev_TY/B_Rev_TY) /...

are you going to provide any more information?

The more detail you give us, the more we can offer suggestions...it looks like your post is just a venting because you...