Hi Erikiur,

Your Solution was indeed a great and quick way to achieve , however there is an issue with the code . Please find the Details Below :

Sample Table ...

Hi Hugo Kornelis,

Apologies for wasting your time , I have given the wrong table and insert statement i have Now corrected them in the below queries :

As i do not...

Hi Asita ,

what is the benefit you are getting out of it can you be more specific please , the update statement using a case statement would hamper the performance...

Hi Hugo Kornelis,

Apologies for delay in getting back to you, please find the details of business context and implemented solution Below : find the Table and Query used Below :

Source...

Thanks a lot 🙂

But the measure values needs to be sequential . Like 17.4 in the example has to be repeated more than 8 times in sequence and then mark only those .

Here...

Want to flag all the occurrences which are in sequential order and then delete them in later stages for count Greater than or equal to 8

Hi ,

I have even tried with Package configurations to update the connection string of a Analysis Services task , but it is not updating the connection string , please let...