Articles by Costica U (Tip/Tricks: 2)

No articles have been posted.

No blogs have been submitted.

Database Development
SQL Server	How to remove duplicate rows in SQL Server 2005 when no key is present [Tip/Trick] 22 Feb 2011 Updated: 22 Feb 2011 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 14,353 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Here is another solution:IF OBJECT_ID( 'tempdb..#TestTable' ) IS NOT NULL BEGIN DROP TABLE #TestTable ENDCREATE TABLE #TestTable ( Column1 varchar(1), Column2 int )INSERT INTO #TestTable VALUES ('A', 1);INSERT INTO #TestTable VALUES ('A', 1); --...
	nth Highest Salary in SQL Server 2005 [Tip/Trick] 22 Feb 2011 Updated: 18 Apr 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 10,010 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. The original solution has some issues. Check the following script:IF OBJECT_ID('tempdb..#salary') IS NOT NULL BEGIN DROP TABLE #salary ENDCREATE TABLE #salary ( Salary INT )INSERT INTO #salary(Salary) VALUES(5) -- 1INSERT INTO #salary(Salary)...