hi jeff,

The code is really working , but it is working fine for single data. How to use it for whole table ?

When i try to...

Thanxs Jeff for the reply,

hello,

I have made changes to the code, but still i am not getting desired result, as specified above.I don't know how pivot works.

use pokayoke_128stages

SELECT TIMESTAMP_MS as milliSec,

[VALUE] as...

hi Vijaya

I have seen the link u posted. but i prefer pivot insted of excel.

i have applied the pivot concept to above data.Here is code

use pokayoke2

SELECT 'TIMESTAMP_S'...

Thanxs for quick reply. 🙂 I am new to sql server . I have seen the pivot ,unpivot. But didn't understood the concept. bcaz in pivot it requires one aggregate...

Plz , does anybody know the solution for this problem ?

Plz reply.

ok, this is table structure script, on which i have written trigger.

The Field TIMESTAMP_S is in unix time format,

to convert it into sql format

DATEADD(s, TIMESTAMP_S, '19700101')

///////////////////////////////////

USE [POKAYOKE2]

GO

/****** Object:...

Hello friends,

Finally I have created the required trigger, but I have a problem.

I have written 2 cursors, 30 if...

Hi,

got ur reply.

But this is the format provided by my client.

I have tried to write trigger,...