Maybe we could use the google geocoding web service with a clr object to normalize an address.

https://developers.google.com/maps/documentation/geocoding/#Geocoding

According to this link, we can sent an address and get the coordinates. After...

I think it's ok that you write queries fast, but just remember that quickfixes sometimes end up stablished as final solution when there is better options available.

What's up,

I did not understand completely the trhead , but is this something similar to what you want?. If it is, then we can make it perform you...

So what is the point of being the "Super Sql Author", if you "copy & paste" comments that does not answer the interrogant of the fellow posters?.

You once commented one...

You project is nice,

how does your ERP gets your data?.

By the way , im kindof Arduino fan, i like machine things too =D, but im not a master.

Thank you Valkeri =D

Hey Valkerie,

It looks like we are really late =S, the post is from 2009 ha ha ha

What's up !

I used GSquared tables for a solution like this:

-- This is just to create the table for testing.

create table #MachineStatus (

ID int identity primary key,

Time_stamp datetime,

Machine_state int);

insert into...

Maybe it would be nice to add something like

Id = DENSE_RANK()() OVER (ORDER BY s.value('@PrecedenceIndex','int') )

Hi Mr. Celko,

I would like to know your opinion on handling different bussines week configurations for services we use.

The concrete example is Fedex services. The following options have different bussines...

So, i figured that if I base the calculation on the julian_business_nbr field of the calendar table, the desired value would be obtained with something like:

SELECT CalendarDays = DATEDIFF( DAY,...

I will look deeply into the calendar table you told me ,and try to find a solution for the package transit problem.

Thanks again.

Hi Mr. Celko, i really appreciate your time and enlightenment. The method you proposed is really good, but you missed the point of the problem I speak of. The idea...

Ha ha i haven't noticed it. Parajuli and I have some homework to do =).

Public Function LoadPrintersByType(ByVal pType As ePrinterType) As ADODB.Recordset

' this should work, but doesn't yet

Dim sSQL As String

Dim co As ADODB.Command

Dim rs As ADODB.Recordset

If OpenPrinterDB Then

...