DDL, sample data and expected results will be helpful and get you the results you need

This is too long and not enough information is provided.  Can you please provide DDL and sample data as well as your expected results.  The query you have won't work...

how does date value 737060 to 1/1/2019 ?   Are you storing in Excel or SQL Server?  What is the datatype in SQL Server? Why are you doing this?

I tried with CTE and cross apply, but cross apply may need to be changed to full outer join on animal id

CREATE TABLE #kennel_history(kh_identity int NOT NULL,

What  are the expected results?  Try this, just a wild guess

SET @sqlquery =
N'SELECT [week],' + @PivotColumns + '

...

Do you have an calendar table?  Otherwise, you'd have to 'generate' one.  I used Jeff Moden's tally table (attached) to generate the dates for 2019 and modified your data to...

why are you doing all the subqueries instead of joining to the tables themselves?  Every row is running 9 select statements to get data.  What is the purpose of the...

There is no sample data, so I'm not going to generate any, but have you tried Round(AVG([TaktTime],1) instead of AVG([TaktTime]?

I got this to work by removing Format from the insert and the format file looks like this

BULK INSERT dbo.test
from 'C:\work\data\test\test.csv'
WITH ( FIRSTROW...

This is a MSSQL forum.  Convert it a MSSQL function.  Try cast:

SELECT MONTH(start_date) Month,
   DAY(EOMONTH(start_date)) DaysInMonth,
   COUNT(*) AS TripsInMonth,
   cast(COUNT(*)/(DAY(EOMONTH(start_date))+0.0) as decimal(9,2))...

just a stupid guess, but what sql version do you have the VSTS Project set to?

Not sure what this table is for, you could use Sequences

declare @i int
insert into [dbo].[tblOrderNumberLog] default values

set @i = SCOPE_IDENTITY()

select @i

Why do you need either approach?  What are you trying to do?  If keyColumn is the PK, then any grouping on it will return 1 row and the count will...

Have you done any testing?  I'd be concerned about your assumption as well.  If that doesn't prove true or you delete runs and fails (i.e. blows out the log), then...

One way is to use Row_Number

select * from (
select *, Row_number() over (partition by ServiceTypeCd order by ServiceTypeCd) RowNum
from [TableOfData]
where SERVICE_TYPE_CD...