Thanks Gian for a fast reply! 🙂

My guess is right then, i was on a debate that this is not a code mistake, but rather the network/hardware limitation. Hmmm.....

wow, thanks for that! You're welcome! 😉

C'est Pras :cool:!

You're welcome, apat!

Deepak, here is piece that might get you what you want:

This code will produce the heirarchical output when IsFolder column is not taken into account

;WITH HierarchyCTE (ID, AssetName , ParentID)

AS

...

Deepak, the desired output image is not visible.. can u put the image as attachment?

You have to make use of Trigger for auditing purpose:

A sample trigger code:

Create an audit Table:

CREATE TABLE dbo.Audit

(

ID INT,

[Login Name] VARCHAR(1000),

[SESSION USER] VARCHAR(1000),

[User Name] VARCHAR(1000),

[APP_NAM]...

Also please take a cue from my post on how i presented the problem with the necessary sample, te table structures! This wil help the volunteers here immensely so that...

Hi there,

As Mike said, without any information of your system , it is very hard to work on your requirement! But still, i have coded a piece for you here....

Hi,, this is short but still performs your request

;WITH CTE as

(

SELECT MAX(TickID) AskSideRWsizeTickID

FROM #TABLE WHERE AskSideRWsize IS NOT NULL

UNION ALL

...

Friend, here is something of gift for you! From what i understood, this would help you

First the tables and sample data: (Please look how i post data so that it...

Friend, you have not provided the sample data for us to work on. I have created the sample data, the sample DDLs and have coded a piece. Please revert back...

I second George here.. Control the DELETE to be done in chunks! This will help you better!

Cheers!

If you want it that way, then you will have to loose the INT data-type and your string will be of VARCHAR..

Exactly.. use PIVOT with some aggregate functions, then u can transpose rows to columns! There is also another old method, which is bit faster than PIVOT for larger data sets!...

malavika.ramanathan (5/12/2010)

thanks for your reply. i dont think it works practically as there are many possible durations...or even if we think of 5 min duration the least, i will have...