One more option is to use CTE to generate dates
Declare @StartDt as Date,
        @EndDt as Date

Set @StartDt = '2017-07-01'
Set @EndDt= '2017-07-31'

;WITH CTE_DatesTable

CTE and cross apply looks good option

with CTE as
(
SELECT
GroupVal,
(
SELECT MAX(v)
FROM (VALUES (Val2), (Val3), (Val4)) AS VALUE(v)
) val
FROM #Temp
)
select...

BCP error output file (.err) is the best place to start the analysis.

Friday 🙂

My understanding is you need to aggregate data and then do some calculation on top. 
You can use CTE for your below group by query. this will not optimize your...

Did you ran that script in all DBs? your proc may in different DB .
you can search in SQL jobs

select * from msdb..sysjobs j
inner join...

You can use variable as numeric number and it should work, and for else part use some higher number. With this you can avoid dynamic query

declare @i int...

You can use STRING_SPLIT function to split the values and use outer apply to join with function. I have used 100 in the FieldVal column to parse to avoid one...

use TRY_CONVERT. for invalid date, you'll get NULL

There are 2 issues
1. You can not create a function with SCHEMABINDING which reference function which is not SCHEMABINDING. so function 2 cant be created since function 1 is not SCHEMABINDING.

Nice one... Initially I thought it is true, but good one the way you turned it down. But of course hope will get something similar in near future. It...

Tricky one.

But answer should be raleatd to either Login created or fail. we can not have both. like falied, but if created policy would ignore.

if both differnt sessions/ activities are going to update both tables TableA and TableB, then ofcourse locking will heppan. based on number of rows, DB isolation level, processing time of...