<div>
Wrap the select statement as follows -<br />
<br />
ISNULL( &lt;select statement&gt;, 0)
</div>


<div>
SELECT TOP 1 COUNT(PeopleID) AS [Count]<br />
FROM &nbsp; &nbsp;dbo.table<br />
GROUP BY PeopleID<br />
HAVING COUNT(PeopleID) &gt;&nbsp;1<br />
<br />
this is my querry..could you do it for me please
</div>


<div>
SELECT ISNULL(<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT TOP 1 COUNT(PeopleID) AS [Count]<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM &nbsp; &nbsp;dbo.table<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GROUP BY PeopleID<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HAVING COUNT(PeopleID) &gt;&nbsp;1<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, 0)<br />
<br />

</div>


<div>
I did the same and executed..the following the error message<br />
<br />
Msg 102, Level 15, State 1, Line 7<br />
Incorrect syntax near ','.<br />

</div>


<div>
The query parsed correctly..<br />
Thank you somuch for your quick answers and bearing with me
</div>


<div>
My pleasure, You are welcome..
</div>


<div>
<div class="content wysiwyg-content">
A variable is assigned in result set to get the no. of duplicate values in a sql execute task.But duplicates may not exist always,in that case sql execute task failing with this error message:[Execute SQL Task] Error: An error occurred while assigning a value to variable &quot;CheckDuplicateID&quot;: &quot;Single Row result set is specified, but no rows were returned.&quot;. How can i rectify it..could any expert solve my problem ASAP
</div>
</div>


A variable is assigned in result set to get the no. of duplicate values in a sql execute task.But duplicates may not exist always,in that case sql execute task failing with this error message:[Execute SQL Task] Error: An error occurred while assigning a value to variable "CheckDuplicateID": "Single Row result set is specified, but no rows were returned.". How can i rectify it..could any expert solve my problem ASAP

Resultset in execute sql task

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.