duplicate post. No replies please.

Please reply here: http://www.sqlservercentral.com/Forums/FindPost1116605.aspx

duplicate post. No replies please.

Please reply here: http://www.sqlservercentral.com/Forums/FindPost1116605.aspx

Please note this is the SQL 2K5 forum....

Or is the intention of your reply...

Oh, I forgot: an issue open since last Sunday is unlikely to be urgent. If it still is, you might want to consider calling a consultant in. Or you could...

What exactly is wrong with the approach posted by Jeffrey at the original thread?

The ROW_NUMBER approach is the right direction to dynamically calculate the StatusEndDate.

Please refer to the ROW_NUMBER solution...

The whole trigger is designed to only work with one inserted row.

The heavy use of NOLOCK hints provide a risk of dirty reads which might be the root cause.

Rewrite the...

Glad I could help 😀

I would prefer an inline-Table valued function over of a stored procedure.

The benefit: you can still use it like a view (e.g. SELECT * FROM your_function(param1))

What table is it, actually, you need to refresh?

If you don't consider adding proper indexes as an option, you could rewrite the query to create a temp table using the...

Did you realize the @x actually is a variable and not a column name?

Since we still don't know anything about your table structure we can't provide the correct (SQL Server)...

Ok, let's start from the beginning:

Please read and follow the instructions given in the first article referenced in my signature and provide ready to use sample data.

??????

Did you try to modify the solution I posted to work against your sample data?

A very basic example due to missing sample data:

DECLARE @x VARCHAR(50)

SET @x='Maryland<h2></h2>'

SELECT '<h2>'+ REPLACE(@x,'<h2></h2>','</h2>')

WHERE @x LIKE '%<h2></h2>'

ORDER BY CAST(SUBSTRING(CONVERT(VARCHAR(11), date, 113), 4, 8) AS DATETIME)

The major issue is this rather large join is not supported at all by non-clustered indexes leading to a monster of 26m rows before any filter is applied (in between...