You were written a script suitable for my requirements. Thank you so much Drew for a quick solution.

Thank you Dixie for your support and written script for my query

A similar format required.

Can you please help me to get the result? Thanks in advance.

Thank you Drew for your support.

I understand you message. Going forward I should avoid to place multiple times the same post for different users.

Also, Really sorry to mentioned your name...

Thank you dear for your support.

I will validate and update the my comments.

Thanks & Regards,

Kanagarajan S.

Hi Parkin,

Thank you so much for looking my query.

I meant that matched value should be ABC & SILVER.  when name is ABC then show corresponding result else show previous row...

Hi Allen,

I have missed to attach Expected result in previous post. So, again attached for your reference. 

Hi Allen,

Thank you so much for looking my query.

There is available timestamp is as primary and use it for order by.

Herewith attached sample query for create table and insert data....

Hi Dew,

Thank you so much for looking my query.

I meant that matched value should be ABC & SILVER.  when name is ABC then show corresponding result else show previous row...

Hi Lowell,

Thank you for your response and given option to look
Let me try this option and update the status

Thanks
Kanagarajan S.

Thanks for your response.

How to degrade reports RDL from 2016 to 2012 servers? Is there any option to migrate from higher to lower version.

Thanks
Kanagarajan S.

Hi Sue,
Thank you so much your response.

I tried with alter table script. but, Its able to change only folder name. I have requirement need to use remote...

Thank you so much for your quick response, But,I took delay to view your response.
  
The files stream seems to occupying spaces in two places like physical files...

I have requirement we wants to show in cube browser window is yesterday sales data, , I have used time dimension table hierarchy is Year, month , week start date...

you can use SSIS packages...

---