<div>
Hi,<br />
<br />
Please use below query on your test environment.<b>QuoteId, QuoteNumber are the column names from your table FILTEREDQUOTECLOSE. If they are incorrect replace them with the actual ones.</b><br />
<br />

<pre><code id="code-20-41929360-1">--
SELECT * FROM
(
   SELECT * , COUNT(*) OVER (PARTITION BY QuoteId, QuoteNumber) cnts FROM FILTEREDQUOTECLOSE
)k
WHERE cnts &gt; 1
--</code></pre>
<br />
Note- The above query will give the duplicate Quote ID and Quote Number with the other columns. If you want only duplicate QuoteId then remove column QuoteNumber from the PartitionBy Clause.<br />
<br />
Hope it helps!
</div>


Hi,

Please use below query on your test environment.QuoteId, QuoteNumber are the column names from your table FILTEREDQUOTECLOSE. If they are incorrect replace them with the actual ones.



--
SELECT * FROM
(
   SELECT * , COUNT(*) OVER (PARTITION BY QuoteId, QuoteNumber) cnts FROM FILTEREDQUOTECLOSE
)k
WHERE cnts > 1
--


Note- The above query will give the duplicate Quote ID and Quote Number with the other columns. If you want only duplicate QuoteId then remove column QuoteNumber from the PartitionBy Clause.

Hope it helps!

<div>
This looks promising, I will try it out and get back today<br />
<br />
Thanks
</div>


This looks promising, I will try it out and get back today

Thanks

<div>
Thanks for the query, can you provide a way to update Quoteid and Quotenumber in FilteredQuoteClose to the same value?
</div>


Thanks for the query, can you provide a way to update Quoteid and Quotenumber in FilteredQuoteClose to the same value?

<div>
<div class="content wysiwyg-content">
We have a highly customized CRM 2011 system that has two quotes with the same quote id and the same quote number in FILTEREDQUOTECLOSE table on our Production system.<br />
<br />
We are trying to replicate this in our TEST environment to determine how it occurred<br />
<br />
Thanks
</div>
</div>


We have a highly customized CRM 2011 system that has two quotes with the same quote id and the same quote number in FILTEREDQUOTECLOSE table on our Production system.

We are trying to replicate this in our TEST environment to determine how it occurred

Thanks

CRM 2011 How to Create a Quote with same QuoteID and QuoteNumber

Simple Object Access Protocol (SOAP) is a protocol specification for exchanging structured information in the implementation of web services. It uses the XML Information Set for its message format and uses other protocols, notably Hypertext Transfer Protocol (HTTP) and the Simple Mail Transfer Protocol (SMTP) for message transmission.

SOAP Protocol

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.

Microsoft SQL Server 2008

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.