Yes, it is a bit suspenseful... 😛

Well, it's not like I have anything else to do... 😀

turn the page ...

The Dixie Flatline (12/12/2009)

---

9988 .... The entire stadium rises to its feet. Men are screaming.... mothers throw small children high into the air... it's neck and neck and...

Heh, definitely not.

We're pacing ourselves. 😀

Like this:

CREATE...

You mean from a program? The SOP way is to just try to connect to it. If you're changing the code tha I would recommend setting your service...

-- An XOR Aggregate function

-- Several text parsers

-- some CLR functions for pipeline summation

-- CLR proc to send message/records from SQL Server Service Broker to Berkley databases

I thinks theres a...

I notice that you already eliminated the Cursor in the outer function, so combining these should eliminate all of the Cursors. I suggest that you try that and let...

OK, here's how to implement your inner function without Cursors:

CREATE function [dbo].[InsidePolygon] (@vertices xml, @x float,@y float) returns bit

begin

DECLARE @b-2 BIT

...

joebadguy0000 (12/10/2009)

---

Thank you so much guys. Without checking your replies, I went on to use cursors. ...

...It is taking crapy amount of time. Please suggest me how I can improve...

If you could put the checking method into SQL or some kind of English-based pseudo-code, I would be happy to show you how to do it without any cursors at...

Can you? Yes.

Should you? No.

Please read these two articles:

http://www.sqlservercentral.com/articles/T-SQL/66097/

http://www.sqlservercentral.com/articles/T-SQL/66494/

Please edit your post and use the [ code ] tags.