Well it's minimally logged so it can be rolled back... if you don't overwrite the datapages with new data.

That assumes that the lastest date has the max identity... this is assuming a lot in a real life environement .

Sure, here's a sample :

Stored proc :

CREATE PROCEDURE [dbo].[GetPkADP] @DBName as varchar(50), @ADPName as varchar(100), @PkADP as int output

AS

SET NOCOUNT ON

SET @PkADP = (Select PkADP from dbo.ADPS A...

This may help you :

http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp

http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

Can you share your findings with this community?

Here's some sample code... I can make a new simpler one if you don't understand this one :

sql code :

CREATE PROCEDURE [dbo].[SearchDependencies] @search as varchar(256), @PkDB as int,...

Select * from dbo.YourTable Y inner join

(Select City, max(tmpDate) as tmpDate from dbo.yourTable group by City) dtMaxTmp on Y.City = dtMaxTmp.City and Y.tmpDate = dtMaxTmp.TmpDate

Your employement or mine???

Run this 1000 times with set @BusinessDays = 10.

My version will be done along with my morning coffee before yours is over (ok, slight exageration).

Yes start a new post.

also

INNER JOIN <----- "What will work here"

(SELECT txtCategory, SUM(curAmount) AS CategorySubTotal

FROM tblEstimatesLineItems

WHERE (lngzEstimateId = @Compare2_lngzEstimateId)

GROUP BY txtCategory) Compare2 on compare1.id = compare2.id;

this is if you...

Just like a little discretion on the web... not wanna completly disappear .

You better document that because all searches on that column will be insensitive when the rest of the app is sensitive... that could cause some un-happy users.

Please post the solution so that everyone can benefit from it.

I agree that there should be a better solution, but untill Yukon I'm afraid you'll be stuck with this solution because the [n][var]char columns are limited to 8K width. ...

Why is it unacceptable for the app to do some work in sorting this out?

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=224123