Monthly Archives: February 2019

TSQL Challenge

On the series on SQL challenges, below is the next puzzle/challenge and the requirement is to find out the person name who has both mango and apple Table 1: @Person contains Person NameTable 2: @PersonFruits contains the available fruits per … Continue reading

Posted in SQL SERVER 2008, T-SQL | Tagged , , , , , | Leave a comment

Best Practices in Business Objects

In this thread, I am trying to collect all the best practices as much I can. If you can contribute your own best practices for Business Objects, it would be really good to share with all. Have a look at … Continue reading

Posted in Business Objects Administration, Business objects Web Intelligence, Universe Designer | Tagged , , , , , , , | 1 Comment

TSQL : Update columns with different values randomly

Continuing the series on SQL challenges. I came across a requirement from an online Tech forum where the request was to perform an update on a table column with a sequence of values randomly I have tried to write a … Continue reading

Posted in SQL SERVER 2008, T-SQL | Tagged , , , | 1 Comment