Here's a test script. You'll notice that it doesn't actually delete any rows when executed with FMTONLY ON.

USE tempdb

CREATE TABLE Test( TestIntint)

INSERT INTO Test(TestInt) SELECT 1

GO

CREATE PROCEDURE TestSP

AS

DELETE FROM...

Matt Whitfield (9/29/2009)

---

with SET FMTONLY, it doesn't do any data changes, just gives you the schema of the result. So passing in any old default value for the parameters will...

Pradeep's method can also use...

;WITH Filter AS (

SELECT TOP 500 Convert(money,SubString(strrow,8,5) amount

FROM tComments

where strrow like '%Value:%'

ORDER BY DateStamp DESC)

SELECT SUM(Amount) Amount FROM Filter

Or if you prefer the 2000 version:

SELECT SUM(Amount) Amount

FROM (

SELECT...

This is what cursors were made for. This is a basic gist because I never remember the exact cursor syntax off the top of my head. (And make it...

Need more information. What precisely is your question? What does that query return?

Also, is there a reason you're converting dates to varchars in your case statements?

Can you be a little more specific about what 'didn't work' means?

SELECT SUM(Convert(money,SubString(strrow,8,5)))

from tComments

where strrow like '%Value:%'

should work. If it doesn't, post the error/result.

While updating the view is an interesting addition, it does not necessarily prove anything in regards to the 3 part update. Your examples use only a 2 part update....

I realized after the fact that it might have been a little unclear as to why I didn't believe Barry's solution didn't *beat* the quirky update, as the quirky takes...

Ok, so I had some time back at my machine to test your solution Barry. It comes very close to tying the quirky update, but doesn't *quite* manage it....

Dave Ballantyne (9/28/2009)

---

Well , just that on your base table , you dont ( disclaimer More testing needed) need a clustered index in the...

Sorry, I just got back from a cruise to the Bahamas, have been completely unplugged from the world for 4 days now. May take today to 'recover' from my...

Is there any reason you have to use openquery instead of just a linked server query?

This is true...

From your sample data, it looks like you have two issues. The first is how to identify which is the first, second or third color. Not sure if...