Yep both the abov workd for me too

Can you confirm the row terminator through something like Notepad++?

The code seems ok but it does depend a lot on the actual import file formatting which we can't see.

You can install it anywhere you want.

You have no T2 table

from T1 join on

should be

from T1 join T2 in

Temporal tables allow a table history but that’s the whole table. Shadow tables can be created with insert/update triggers and you can configure for the coins you want.

Hi,

Depends on what you trying to achieve. If you just want a dev installation you can install locally. If you have a server on a lan you can install there...

Depends what your trying to achieve long term. There are a number of different ways this could be set up-local, azure/aws(cloud), local server. It all depends on your end requirements...

How long should the query take to run? Does it error straight away. I’d look at command timeout as well as connection.

Is the Winforms app local (same machine) as the...

Hi,

Assume this is something that is live and you are trying to work around?

Obviously only seeing a snippet but if Stakeholder was a table and Stage was a...

Not tested but is something like this what you are after:

DECLARE @WKSTARTDATE DATETIME = '2016-01-04'; -- for example first Monday of Jan 2016

DECLARE @NUMBEROFWKS INT = 10; -- number...

"If I could directly assign postcodes to a police force it would be much easier but as I said above I would end up with other problems."

Ok, scrap my idea...

It's easy for me to sit from a far and make comments on a topic area I have very little knowledge on but this is what I was thinking.

The...

I only have a small insight to what you need to do but why can't you allocate the postcodes against the Account (police force) as this is where the actual...

If this is recording the amount of time allocated as opposed to the actual time of day wouldnt you be better to look to use a numeric field?

If the hour is 00 the datepart returns 0, 0 -1 = -1.

cast(datepart(hh, @date) - 1 as varchar(2))