Hi Chris,

I tried using CTE but not able to do.

Still not tried anything as busy on other task.

If u have any idea in the mind then pls share.

Thanks CELKO.

I will try this one.

Thanks

Abhas

Dwain the query as below.

select CustID fromcust_status

where EXISTS (select top 1 custid,EffectiveDate from cust_status

where status= 1 order by EffectiveDate desc)

data is as below.now i want to show only CustID =...

hi Sartori,

table structure is same as presented in below link.

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/c93b2856-76c4-4348-9d46-8a60612c3b23.mspx?mfr=true

and i want to display servernames as mentioned condition above post.

thank u

Abhas

Thank u Lowell

But i need avarage upon time not on date.and time is in miliseconds.So i have to find largest 90% avarage from table.How can we do?

Regards

Abhas.

Hi,

Thanks of your valuable comments

Regards

Abhas

I can't use 7zip as i don't have permission.

I want extract folders which are compressed using windows built in utility.So i don't know which exe extract these folders.

Regards

Abhas.

helo rashmi,

its working fine but if there are more than one files in folder.i.e. in test folder if more than 1 text files r there then it extract only one.why...

Thank you so much rashmi!!!!!!

It's great.:-)

I got exactly what i want.

Thank you once again.

🙂 🙂 🙂

Regards

Abhas,

Hi rashmi,Thank you so much for your replies.

Can u please send attachment in .zip format?

Also by checking travarce folder all data has been extracted in the one folder only.

also i...

Hi rashmi,

i already checked Traverse Subfolders but not working.

Hi Rashmi,

Thanks it works but not fit in my scenario.

Actually all files are loaded at root level only.

My source is:D:\FolderA

in the same folder there are other 4 sub folders say

D:\FolderA\test1

D:\FolderA\test2

D:\FolderA\test3

D:\FolderA\test4

and...

Thank you rashmi!

Its working now.

But can i do these by another way? Can i copy only those files from source to destination which are 90 days old only.

currently i am...