I am not serious It does not mean I am joking, If you wish to prove mettle, you can share such a solution, I would be grateful to you..

Regards

Ashok

This can only be possible with two file system tasks..

Hi,

This is not possible with Single file system task beacuse move file operation do not include file name thats file you will have to use two file system tasks one...

patla4u (6/29/2011)

---

I have 10 different File with Diffetent Name.

I want to move that file from download folder to archive folder with current month and Year Information.

How can I move and...

Can you please share tables creation script so that same can be simulated on my workstation and for better understanding your requirement.

Regards

Ashok

Hi,

There is no harm in usung this

select datename(dw,getdate())

and can check for Sat or Sun accordingly.

Regards

Ashok

Thanks a lot , I would like to feel regretted if you felt bit pain, I am really sorry for that.

Thanks a ton, I got the point... 😎

Hi ,

Please explain then why execution plan is index seek for the below query in the same situation ,index created on the table is still non clustered :

select name,id from...

Thanks all for their valuable comments,

Hi Syed Jahanzaib Bin hassan,

Can you please share logic behind it, why it happens, I mean different execution plan for non clustered and clustered index...

Hi lulian,

I am waiting for your reply, I hope you will come back, Please help..

Regards

Ashok

Hi heb1014,

This is because, both records are not consecutive.

Regards

Ashok

Hi lulian,

You are absolutely understood the problem, Please go ahead and may you get the success and don't forget, cursor usage is not allowed.

Regards,

Ashok

Hi lulian,

Thanks for your efforts, the three rows left outside from the result because :-

for attrib 100 begda should be 3/10/2010 and endda should be 4/10/2010 for first two...

Hi lulian,

Thanks for your efforts, the rows left outside from the result because :-

for attrib 100 begda should be 3/10/2010 and endda should be 4/10/2010 in first two records...

Hi,

usage of cursor is avoided...