Thanks for the suggestion. I informed to my colleague and he said he is executing this script in an OPENROWSET. And it is going to execute in different servers. He...

I have attached the execution plan here...Please take a look at that.

Hi Friends

First of all, thank you so much for all your suggestions. I really appreciate it.

I got this script from my colleague. I tested this script on the environment. I...

Thanks twin.devil.

well, I tried with cte but the result are not similar. Is there any better way to do this? Just curious..

SELECT er.rowid, er.CurrencyId

,er.Rate, er.DateEffective

FROM (SELECT er.rowid,er.currencyid

,Rate

,ROW_NUMBER()...

Thank you Mike, your coding has helped me to get things done. Actually why am I generating hash value is to check whether any changes has been made in the...

Thank you Mike, I will try this one.

But Mike , about the FileSpec Expression, Can you tell me how does it work? Just curious.

okay..Thank you John. I really appreciate your help

I thought of making two containers like you said determine using constraints. I was not sure of it if this is the only method or we still can be able...

Hi John,

We know the path of the file. But I want to process only the file that I pass instead of processing all the files in the folder.

In the foreach...

Hi Jayanth,

The URL tells us how to do looping in the directory by dynamic path....but I also need dynamic file . Like it should process only the file that I...

Mike, I think my Network team has restricted the access of running PS . Even after I use admin account to run the PS, I am not able to do...

Mike, I executed the script and it asked me YES or SUSPEND and I said YES. but it says access is denied.

For your reference, screens hot is attached. please take...

Mike...thanks..it helped. executed successfully but not getting the output. when I tried running through ISE..it throws me this error....

cannot be loaded because the execution of scripts is disabled on this...

okay Mike,

tell me Where do I have to add that? let me try

Hi Mike,

I am still getting the same issue. Well, I saved the powershell script in a text file. Does this need to be in .ps format? or could be any...