Happy New Year 2014

HAPPY NEW YEAR 2014 Wishing all of the readers of this blog a very happy New Year. Thanks for supporting me and my blog last year 2013. I hope this support will continue this year too. May God bless all […]

Deleting Duplicate rows using CTE

Deleting Duplicate rows using CTE Many times we caught in a situation where we have a table where there is no primary or unique column defined in it and rows with duplicate data inserted in the table. In this example I will tries to show how to delete the duplicate rows using CTE. Suppose we […]

Answer -Question of the Week – 25/12/2013- Question 1

Question:- Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid  Studentname 1               Vivek Johari 2               Chandra Singh 4           […]

Question of the Week – 28/12/2013 – Question 2

Question:- Suppose we have a table named tbl_charactername have only one column say “charactername”. It contains 10 rows. First 5 rows contains “Vivek Johari” and the next 5 rows contains “Abhinav Golwalkar” tbl_charactername ——————— Vivek Johari Vivek Johari Vivek Johari Vivek Johari Vivek Johari Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Abhinav Golwalkar Now […]

Question of the Week -25/12/2013- Question1

Suppose we have a table says tbl_students whose structure is given below:- Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150)) Suppose it contains the following data:- Studentid   Studentname  1               Vivek Johari 2              Chandra Singh 4             […]

Ranking Functions in SQL Server

Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition. For example, suppose we want to give rank to sales man according to their sales amount in a particular month/year. For this purpose, SQL server provides us Ranking functions. Ranking functions are used to provide […]