<div>
please post the actual query you are using ... you've only posted the cte
</div>


please post the actual query you are using ... you've only posted the cte

<div>
also post the definition of dbo.fnOriginalPolicyID
</div>


also post the definition of dbo.fnOriginalPolicyID

<div>
is this a cross database query?<br />
<br />
or are the policy tables actually the same one?
</div>


is this a cross database query?

or are the policy tables actually the same one?

<div>
sorry, forgot the ; &nbsp;before the WITH
</div>


<div>
<div class="content wysiwyg-content">
WITH ISO_DR(PolicyID, &nbsp;CompanyID, Persistency) AS<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT P.policyID, P.companyID, (SELECT effectiveDate from dbo.Policy where policyID =(select dbo.fnOriginalPolicyID(@po<wbr />licynum)))<wbr /> as PERSISTENCY <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM Hallmark..Policy P WITH (NOLOCK))<br />
<br />
Is there a better way to write this?
</div>
</div>


WITH ISO_DR(PolicyID,  CompanyID, Persistency) AS
		(SELECT P.policyID, P.companyID, (SELECT effectiveDate from dbo.Policy where policyID =(select dbo.fnOriginalPolicyID(@policynum))) as PERSISTENCY 
			FROM Hallmark..Policy P WITH (NOLOCK))

Is there a better way to write this?

query taking a lot of time

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.