Tag Archives: sql puzzle

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 : Parent-Child view to Flattened view using cursors

I recently came across of this requirement from one of my friends, he wanted the following table data to be viewed in a different format. Take a look at the following table   Members Parent Bikes Wheel Steering Tires Parent … Continue reading

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