I don't have the access to open 'profiler'.

I want to prepare a report saying that this much of cost has been reduced after tuning the procedure.

let us take the current...

I am looking for some advanced level. Thats is, if more than one process is running when we execute the procedure how much of cpu utilized by this procedure? i...

how the scalar function and ITVF are working internally?

i think i need to study how PIVOT is working internally...because the concept is unclear for me...

if anybody explain it little bit more,it would help me....

PIVOT (MAX(Item) FOR StringPos IN...

I thought to use Tally table to split the string...but i got struck up when i think about transposing a column into multiple columns. Because the Tally table transpose the...

Paul White NZ (4/20/2010)

---

And a nested PIVOT:

SELECT P.tran_id,

name1 = MAX(P.name1),

value1 = MAX(P.[1]),

...

here are the results from my PC.

********** COldCoffee's Concatenate and Split solution **********

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

SQL Server...

COldCoffee (4/19/2010)

---

Thanks Karthikeyan!! I wonder how...

Yes. I tested both the query plan...i didn't see any difference.

I think it should work...

A small modification in coldcoffee's code.

WITH MIN_MODIFIED_DATE_FOR_EACH_ID (ID, MIN_DATE)

AS

(

SELECT

...

why don't you use replace function?

Try this one...

Declare @str varchar(255)

select @str = '[Mon Mar 02 08:54:49 2009]Local/GMR09/OTLCHK/admin/Info(1021006)'

select replace(@str,'/',',')

Try this one...

declare @n varchar(10)

set @n ='10'

select case when ascii(left(@n,1)) > 47 and ascii(left(@n,1)) < 58 then 1 else 0 end

I am not getting the...

As ColdCoffee said read the article and implement it. I have already implemented 'Quirky Update' to resolve running total problem 🙂

It is working perfectly...

Actually I thought that MIN() function caused the performance issue. Thats why i asked get...