Ahh...I think the namespace is messing you up. try this on...

http://www.sqlservercentral.com/Forums/Topic483834-21-1.aspx#bm483865

Brandie - you're going to need to run a "find/replace" on the < and > sign's. SSC is "eating" your XML snippet.

Replace them with &lt; and &gt; respectively.

Mike - when you say "after" 9, do you mean after the "9" element in the set? or after the nine in the ORDERED version of the set?

As in:

1;2;3;4;11;18;17;10;9;8;7;14;15;16;21;22;23;24;25;30;29;28.

or

1;2;3;4;11;18;17;10;9;8;7;14;15;16;21;22;23;24;25;30;29;28.

So what IS the data type of TimeDifference? When you said is was "in minutes" I was thinking you mean it was INT - is that not the case?

the modulo would work, yes. But in order to perform the division and end up with a numeric or decimal value,...

Gus' statement is missing a JOIN clause right before that table name. Not sure which one he had in mind, but it kind of looks like a CROSS JOIN...

Having done some amount of testing on this - while this scenario is certainly convenient in some scenarios, it has a tendency to perform on par with CSQ's, so it...

I can't help but think that you're "overthinking" the problem. There's nothing special about expressing a query that happens to have a many to many. Just join the...

Jeff - I will post my own script later. I kind of got busy yesterday and didn't get a chance to come back and finish the thought so to...

TheSQLGuru (6/16/2008)

---

Wilfred van Dijk (6/16/2008)

---

I agree with Bob. Why write some unreadable code in order to avoid cursors? To my opinion, cursors are easy to implement, very straightforward and the...

hmm...needle in the haystack time. The best I can offer up would be to start commenting sections out to isolate where the error might be. The second...

samir (6/16/2008)

---

Using this method, the SELECT query is executed 'n' number of times, where n is total number of records in the table. I dont think this is optimized...

Here's the CLR stored proc:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Partial Public Class StoredProcedures

<Microsoft.SqlServer.Server.SqlProcedure()> _

Public Shared Sub CLRCursorSP(ByRef Total As SqlMoney)

...

As requested - here's the CLR code I used. First the function:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction(DataAccess:=DataAccessKind.Read, IsDeterministic:=True, IsPrecise:=True)> _

...

Absolutely nothing. The two solutions are a bit of a toss-up from what I...