Eirikur Eiriksson (5/26/2014)

---

This should get you started

😎

/* convert geometry to geography */

DECLARE @GEO1 GEOMETRY = geometry::STGeomFromText('POINT (-122.358 47.652)',0);

DECLARE @GEOG GEOGRAPHY = geography::Point(@GEO1.STY, @GEO1.STX, 4326)

/* Geography shape/poligon */

DECLARE @g geography...

Hi Johnny

Unfortunately I think you are going to have some issues here. By there nature Geometry and Geography don't really play nice together. Geometry is designed for a...

Hi Lynn

For a start I am no expert on these things.

I couldn't find anything overly specific regarding this, however given the amount of times I saw that using the /3GB...

So if I'm understanding this correctly, you would like the maximum occupancy at any point in the trip rather than the occupancy at the start of the trip?

Here's a revised...

Hi

Here's how I would do it, however there is likely to be better ways:-)

It doesn't return the expected results that you have posted, but they don't match the rules you...

Abhijit More (5/22/2014)

---

thanks guys you saved me!

addition to this I am also searching how many times the word has been repeated within the same column

below is the script

;WITH

CTE

AS(SELECTdistinct pattern

FROM...

Thanks Alan :blush: and then I see my spelling mistake 🙂

Hi

Here's another method using the same splitter and with the same conditions as Alan's. I thought a cube may give you the results you need

declare @string varchar(500) = 'Carborator...

Hi

Dwain did an article on Departures and Arrivals[/url], which if I remember correctly discussed the issues of calculating elapsed time between time zones, including daylight savings time, date lines etc.

Micky

Luis Cazares (5/14/2014)

---

Until you find that Gordon Abraham and Abraham Gordon (or any other combination of names)...

Thanks Sean I'll have to remember that.

Hi

I just cringe at the idea of joining on names in the first place. Having a reasonably common name I can see all sorts of problems and have...

You'll need to provide quite a bit more information before you will get any meaningful replies I suspect. My questions would be along the lines of:

Where is the spatial...

Luis Cazares (5/9/2014)

---

From what I can understand, you're trying to limit the upper value of type 1 to 24 and types 2 and 3 to 48.

This should do the trick.

Case...

Sorry ... of course we should ... I'll fix it up.