Your wish is my command 🙂

Happy to be proved wrong , evidence either way is good in my book.

You just need to manually update the acct value ,

and keep ...

1st off apologies to the...

I did something very similar yesterday , try this link

http://www.sqlservercentral.com/Forums/FindPost789655.aspx

Try this link

http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

How about a recursive...

Well , the challenging part is sorting out the missing data ranges.

Its an extension on this technique.

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/sql-and-contiguous-data-ranges.aspx

I love a CTE ... 🙂

with cteGaps(Date,Service,yield,Rown)

as

(

Select Date,Service,yield,row_number() over (partition by service ,case when yield is null then 1 else 0 end order by date desc)

...

app lock could work for you

http://msdn.microsoft.com/en-us/library/ms189823.aspx

Never , ever ,ever hold a lock whilst waiting for user interaction. That is a very easy way to lock your system solidy.

Your best option may be to implement...

As ever , it depends. Personally ive never used snapshot isolation , so cant comment further really.

Try this link though

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic11164.aspx

As to wheater its acceptable in your environment with your...

You could do , i believe that SNAPSHOT has a fairly high overhead.

Arguably this could be better

SELECT id

into #IdsToupdate

FROM sometable

WHERE columnA = 1

UPDATE sometable

SET someothercolumn = someothervalue

from #IdsToupdate

WHERE #IdsToupdate.Id...

It depends on your transaction isolation level,

http://msdn.microsoft.com/en-us/library/ms173763.aspx.

The question is what do you want to happen ?

Do you want the other process blocked ?

Do you want the update to see...

Jonathan (9/15/2009)

---

Dave Ballantyne (9/15/2009)

---

This is the output i get from set statistics io on .

Non Cte

Table 'SalesOrderDetail'. Scan count 31466, logical reads 103081, physical reads 0, read-ahead reads 0, lob...

Jonathan (9/15/2009)

---

SELECT SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty, ProductID, SpecialOfferID, UnitPrice,

UnitPriceDiscount, LineTotal, ModifiedDate

FROM Sales.SalesOrderDetail d

WHERE LineTotal IN

(SELECT MIN(LineTotal)

FROM Sales.SalesOrderDetail

WHERE SalesOrderID = d.SalesOrderID)

ORDER BY SalesOrderID, SalesOrderDetailID;

------------------------------------------

WITH cte AS (SELECT SalesOrderID, SalesOrderDetailID,...

If you want to use nolock , understand the consequences

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx