Integration Services must be installed on any machine which runs a package via SQL Agent.

Try changing your GROUP BY:

GROUP BY col_date / 10000

Here's an example of how you might structure the underlying tables and then SELECT from them to return your dimension:

DROP TABLE IF EXISTS dbo.Date;

CREATE TABLE dbo.Date
(
 ...

• This reply was modified 5 years, 6 months ago by Phil Parkin.

The Google Maps API looks like it could do it, though it's going to be an RBAR solution, by the look of it.

Does this help?

PoSh is a good option, IMO.

Because it gives you the distance from every building to every other building.

Please note that this is a SQL Server forum. If your question relates to SQL Server, please make the connection clear and we will try to help.

If your file names always follow that consistent pattern, you could use something like this:

DECLARE @v VARCHAR(MAX) = 'O:\Z\P_Metrics\Inbox\07-13-20200702_abc_enroll.csv';
DECLARE @V1 VARCHAR(MAX) = 'O:\Z\P_Metrics\Inbox\07-14-20200702_abc_complete_enroll.csv';

SELECT LEFT(@v, PATINDEX('%[0-9][0-9]-[0-9][0-9]-%', @v) -...

OK, understood (though I would probably keep the date dimension table clean and have another table containing measure and measureno).

It therefore appears that your PK should be composite, comprising (theDate,...

I don't see 'YTD TY' or 'MAT TY' anywhere...

You might find this link helpful.

My thoughts exactly!

You can't use dynamic SQL in functions. But I think that dynamic SQL is the only way that you'll achieve this, so you probably need to rethink. Can you use...

Correct. To be honest, I just assumed that the OP had worded their question...

Your procedure contains at least 1 syntax error. Why do you refuse to format your code?