Tag Archives: tsql puzzles

TSQL Challenge

On the series of TSQL Challenges, here is the next challenge. The requirement is to group the same parent when they have same child information. Below is the sample source records where the expectation is to merge the Usage by … Continue reading

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

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

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