Very slick try, but it doesn't seem to work:

USE tempdb

GO

CREATE TABLE tmp (a int)

INSERT tmp VALUES (1)

go

CREATE PROC pr_OrganicDissapearance AS

SELECT a FROM tmp WHERE a = 1

BEGIN TRY

;WITH...

You wanted a simple, definitive answer. Here it is: you cannot do what you want to do.

Must be frustrating (for all concerned) to be a consultant consulting on things you aren't qualified to consult on!! :ermm: How did that happen - did they bring...

Bummer that you had to uninstall it when it "was working fine"! Like others said this could be about a bajillion things, including just a bad reinstall or an...

you cannot manage TB-sized databases on crappy IO subsystems. Do a file IO stall analysis on all of the components hit during your backup and I am certain you...

Nearest stuff just plain SUCKS with sql server spatial. Search web for isaac kunen spatial. He has a slick power-of-2 query for finding stuff nearest to you. ...

I tried numerous permutations, including a CROSS APPLY, all to no avail. I also tried just a single hit on the view with an IN clause, thinking that if...

durai nagarajan (5/1/2012)

---

current deploying the archive stratergy in some tables and making the changes in report as i am moving it to different DB. this is an activity monitor table.

As...

Partitioning is a COMPLEX topic and I have seen LOTS of clients and forum posters get into trouble trying to implement it without truly knowing what they were doing or...

1) To the OP: if you aren't good with analysis and mathematics, why are you trying to do this VERY complicated stuff? And without regular computer access too?

2) Isaac...

dglane (4/30/2012)

---

Understood, KGB. This is not associated with an app. It pertains to a batch import. We would be receiving a table with some combination of attributes...

99.x% of the time you should jump through any hoop imaginable to avoid using scalar UDFs!! I wrote a chapter for the SQL Server MVP Deep Dives 2 book...

dglane (4/30/2012)

---

That was an interesting article indeed, Evil Kraig F.

I would be comparing two tables (vs. a set of variables or one row). Using my shoe example, I would...

With that reply, reading some prior stuff, and what Ninja said, I cannot...

Ninja's_RGR'us (4/25/2012)

---

TheSQLGuru (4/25/2012)

---

I didn't read the umpteen replies to the OP, but ANY TIME I see "ran slow the first time and very fast the second time" I IMMEDIATELY think...