Tag Archives: T-SQL Challenge

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

T-SQL : An Interesting Question – 2

Another interesting question that I have read recently, which involves some string operations. Question: The whole string given is a alphanumeric (for ex: AP1AA). The requirement is to Stuff ‘0’ before the single digit number (0-9) which is enclosed by … Continue reading

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