December 2013 - Technology with Vivek Johari

Happy New Year 2014

December 31, 2013April 27, 2018 vivekjohari31 Comments

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

December 29, 2013January 28, 2019 vivekjohari26 Comments

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

December 28, 2013April 27, 2018 vivekjohari27 Comments

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

December 28, 2013April 27, 2018 vivekjohari32 Comments

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

December 25, 2013April 27, 2018 vivekjohari31 Comments

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

December 25, 2013February 1, 2019 vivekjohari30 Comments

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 […]