Category Archives: SQL Server

Selecting all unique rows from duplicate rows in table in SQL Server

Hi, This post will show how you can write a select query to select only unique rows from a table that has many duplicate rows. In other words, this post will show the query to select distinct rows from a … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , , , , | Leave a comment

[Question – Help required] SQL Server 2008 R2 installation missing “Integration Services” Shared feature in features selection step

Hi, I’m installing SQL Server 2008 R2 Enterprise Edition in my system. The installation process is working perfectly except that in one of the steps where we are supposed to select the features, I observe that “Integration Services” shared feature … Continue reading

Posted in .NET, General, SQL Server | Tagged , , , , , , , , , , | 4 Comments

[Error-Resolved]Could not find the database engine startup handle – SQL Server 2008 R2 installation

Hi, This post describes how to resolve the error that one might encounter while installing SQL Server 2008 R2 from an ISO. I had the setup for SQL Server 2008 R2 in an ISO file. I assumed that extracting the … Continue reading

Posted in .NET, General, SQL Server | Tagged , , , , , , , , , , , , , , | Leave a comment

Retrieving column values as a comma separated string in SQLServer

Hi, This post is quite the opposite of the previous post. That is, in the previous post, We inserted a comma separated string into separate rows. Here we will return a single comma separated string by concatenating values from separate rows.   … Continue reading

Posted in CodeProject, General, SQL Server | Tagged , , , , | Leave a comment

Adding items in comma-separated string into separate rows in SQLServer

Hi, In this post, I’ll show how to insert a items in a comma-separated string into separate rows in a table. Consider for example we have a comma-separated string such as “amogh, anish, anvesh, uday”. after inserting into the table, … Continue reading

Posted in CodeProject, General, SQL Server | Tagged , , , , | 1 Comment