http://msdn.microsoft.com/en-us/library/bb964740.aspx

"You can create up to 249 spatial indexes on any of the spatial columns in a supported table."

you can have more than one spatial column therefore 249 * the spatial...

Ian Massi (9/3/2008)

---

My wife wants a laptop, maybe the next time we're near a major airport, we'll just go up to the counter and say we lost a laptop. ...

65% of 600,000 at $400 dollars a pop = $156,000,000

Wow! No wonder laptop sales are a lucrative market!

Ok lets start a business - the public pay us $100 dollars per...

Not exactly, but thats another story......(read the thread fully).

Please don't necro dead threads (17th July - 28th August is a...

:D:D:D:D:D:D

Still going kev!

:D:D:D:D:D:D

necro.............................................................;)

Ah maybe the Sex column no - longer contains M or F for the subsequent identical rows

but M/F + 1 and M/F + 2 for second and third respectivly.

then...

John I agree with your concerns and general comments - I was just making the point that duplicate elimination was not what was required. 🙂

John - you missed the whole point - its to keep the duplicates 🙂

I think you may have a conceptual design flaw.

How is your customer/business represented in the application connecting to the data?

Is it a Customer object which has a departments collection attribute...

Thats not a grenade its a nuke......:D

Think? We are God's gift to the whole world - our ancestors made it what it is today! 😛

From my post before yours Jeff I totally agree.

--Shaun

skyline666 (8/15/2008)

---

Whoops! Don't worry though, when I answered it the first time last month I got it wrong, and then the...

Damn I got it wrong again! 😀

ryan.leuty (8/12/2008)

---

I don't know:hehe:

......

Is it better [faster, more reliable, more secure] to send a complex statement to SQL via the web app, or use a sproc?

Should a sproc handle the...