Last week we were running contest Identify the Database Celebrity and we had received a fantastic response to the contest.
SQL SERVER – Select Columns from Stored Procedure Resultset
It is fun to go back to basics often. Here is the one classic question: “How to select columns from Stored Procedure Resultset?” Though Stored Procedure has been introduced many years ago, the question about retrieving columns from Stored Procedure is still very popular with beginners. Let us see the…
Read More
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 4
This is the fourth post in the series of finding previous row and next row value in SELECT Statement. Read all the blog post before continuing reading this blog post for complete idea.
In the very first part I discussed that performance with the help of CTE is very poor and I encouraged users to use LEAD and LAG function of SQL Server 2012. My friend and SQL Server Expert Szymon Wojcik have written a fantastic post about this subject. I encourage everyone to read that blog post. He has demonstrated that with the help of numbers table, we can further improve the performance of the query.
SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 3
Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? and SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2. In part 2 of the blog post, I wanted to write…
Read MoreSQL Contest – Hint for Identify the Database Celebrity
Earlier week I have posted a SQL Contest about Identifing the Database Celebrity over here Identify the Database Celebrity – Win USD 100 Amazon Gift Card. We have got fantastic response to the blog post however, there are quite many readers have requested Hint to the contest. In the world…
Read MoreSQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement? – Part 2
Earlier I wrote a blog post SQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?. Right after the blog post was published I received an email from SQL Server users who have no access to CTE and wanted me to help him out…
Read MoreSQL SERVER – How to Access the Previous Row and Next Row value in SELECT statement?
The first email I read this morning had only one statement in it, and it gave me an idea to write this blog post. “How to access Previous Row Value and Next Row Value in SELECT statement?” Very interesting question indeed. The matter of the fact, I have written about this…
Read More