Facebook Sign in | Join
Getting Started with Adobe After Effects - Part 6: Motion Blur
  • TSQL Challenge 15 - matching data between rows and columns

    Submit A Solution This challenge is derived from a realistic reporting scenario that requires the transformation of rows into columns. This is commonly known as a matrix, pivot, or crosstab query. This challenge involves two primary tables @Row and @Cols...
    by Adam Haines on 10-19-2009 | 4,477 Views

TSQL Challenge 5 - Solution by Divya Agrawal

Divya is a new challenger that sends us a very interesting solution. She show us that it can be done without CTE in one very short and simple query. We really enjoyed her solution not only because it is a completely different solution but also because...

TSQL Challenge 5 - Solution by Leonid Koyfman

There were a lot of different solutions for this challenge but globaly the key point to release the split in line in an unique query was to use CTEs. As most people send us valuable queries with CTEs, we took in consideration also other notation points...

TSQL Challenge 5 winners

I spent a lot of time reviewing all the solutions and regarding the key points of our current notation for the challenge this is the list of the winners: Leonid Koyfman which is a many times winner of the challenge and provide as usual a clean and very...

TSQL Challenge 6

Submit A Solution The context For this challenge, you will have to analyse logs on the web server of your company. Here is the sample data you have to work with: ID VisitDate Page NbVisitors --------- -- ----------------------- --------------- ------...

TSQL Challenge 4 – Solution by Antoine Gémis

So far, we have seen two solutions for TSQL Challenge 4 . Leonid wrote the shortest code and Pinal created the second shortest code. The entry submitted by Antoine won the third place for this challenge.   This is the second time Antoine winning...

TSQL Challenge 4 – Solution by Pinal Dave

Yesterday, we saw the solution for TSQL Challenge 4 by Leonid Koyfman . Another winner of TSQL Challenge 4 is my MVP friend Pinal Dave . Pinal used a very interesting logic in his solution. What I find very interesting with these challenges is that, it...

TSQL Challenge 4 - Solution by Leonid Koyfman

After scanning through the entries whole night, I have identified the best solutions for TSQL Challenge 4 . Since the challenge is to write the shortest TSQL Code, I have identified the entries that produced the correct result and sorted them by the length...

Contact US

Copyright © Rivera Informatic Private Ltd.