GilaMonster (1/8/2013)

---

It's a seek because you have a SARGable predicate (Col1 > 60 ) on a column that is the leading column of the index.

Scan is when you have nothing...

I don't think that its a triangular join - no subquery really.

It looks like a moficifation of the...

@Lynn.Pettis & @drew.allen

I can't believe I didn't understand it when drew.allen posted it.

Thank you for clarifying 😀

@joe

Thank you for the explanation!

drew.allen (8/3/2012)

---

As Joe alluded to, there is a much simpler method of calculating intersections. The standard uses only two dates, but it easily be modified to account for multiple...

@joe; I didn't know that. Will look around for info.

What arguments does it accepts?

@Capn; Sorry I missed your question in the post.

All...

Hi,

I've solved a problem similar to this before, and I can't for the life of me figure out how I did it.

Maybe the code below will put you (or someone)...

Very cool, thank you for the pointers and the link to Jeff's article capn.hector!

Will run some tests in the morning 🙂

I may be a little presumptuous in saying that I think that the problem stems from trying to build a SQL solution to a very complex problem that is currently...

Thank you 🙂

Very cool approach!

Unfortunately, time was a worry, so I have re-written my code in to a while loop, and am inserting row-by-row.

While inside the loop, I can query...

Not sure if this approach would be useful?

This method can also be used to determine which columns are alike.

IF OBJECT_ID('tempdb..#mysourcebitwise') IS NOT NULL DROP TABLE #mysourcebitwise

IF OBJECT_ID('tempdb..#mytargetbitwise') IS NOT NULL...

My guess is that failure is occurring at evaluation of

(VAR <> ROUND((((COST-PRICE)/COST)*100),0))) O

In the WHERE clause.

But its just a guess without sample data.

PS.

That evaluation seems a little redundant?

Another way of doing it if you never have spans exceeding 24hr:

SELECT CAST(DATEADD(MILLISECOND, (DATEDIFF(MILLISECOND, '2011-11-11 15:25:26.680', '2011-11-11 15:25:48.957')),CAST(0 AS DATETIME) ) AS TIME)

There are probably simpler ways to do this...

CELKO (9/29/2011)

---

No. we usually insert a PRINT statement in the right place. Since procedures in T-SQL should not be over 50 lines and mostly pure SQL code, why would...

I assume you want to be able to step through the code?

http://blogs.msdn.com/b/billramo/archive/2009/04/11/transact-sql-debugger-for-sql-server-2008-part-1.aspx