Thanks Steve,

after googling, seems like this is exactly what I need !

Cheers,

Bruno

Hi GilaMonster,

thanks again for your help, it worked like a charm !

Bruno

Will do, thanks for the help !

Here is the sql plan, thanks for the hint on the left range right range, I must confess I used the wizzard and did not think about it

The partition function:

/****** Object: PartitionFunction [PositionPartitionFunction] Script Date: 02/07/2012 08:30:15 ******/

CREATE PARTITION FUNCTION [PositionPartitionFunction](datetime) AS RANGE LEFT FOR VALUES (N'2006-01-01T00:00:00.000', N'2007-01-01T00:00:00.000', N'2008-01-01T00:00:00.000', N'2009-01-01T00:00:00.000', N'2010-01-01T00:00:00.000', N'2011-01-01T00:00:00.000', N'2012-01-01T00:00:00.000')

GO

my...

Hi Matt Miller and The Dixie Flatline,

thanks for spending some time on my issue.

I actually dropped all my tables and started from scratch with the sample I provided in my...

Hi The Dixie Flatine

please find below what you requested.

1. Create Table :

USE [LOGSHEET]

GO

/****** Object: Table [dbo].[BOUNDARY] Script Date: 12/23/2010 07:57:29 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING...

Hi Falks,

It's getting even weirder ...

I just did the same kind of function, but to compute longitude this time.

Here are my results :

select Longitude, LOGSHEET.dbo.GetLonDFromLon(Longitude,100)

from LOGSHEET.dbo.boundary

where Longitude='1704142W'

Returns 170.69 (wrong...