Morning all, sincere apologies for the radio silence.

The function is as follows:

create function 
dbo.mydatefunction (@Date date, @DaysToAdd int)


returns Date as 
begin

     declare @Dates...

Hi chaps sorry it took a few days to reply.

the issue was that VS 2019 pro was showing the green tick on the insert task and then moving onto the...

I agree it’s hard to imagine a bug with update. I will try profiler and see what falls out the other end.

cheers as always,

Dave

Hi Phil,

Yeah its identical, I am simply executing the execute SQL task by right clicking on it in VS.

That works whereas running the package in its entirety causes the error...

Hiya Phil, I tried that but no luck.

it’s worth mentioning that other scripts using the same method are unaffected.

cheers,

Dave

Hi Phil,

thanks as always for your constructive reply.

Yes we are moving from TFS to Git with bitbucket. I have today found a way to at least lock files using this...

Yep, I don't like that either!

Cheers,

Dave

Hi Phil, thanks for replying. This is exactly what I thought.  This is all at a POC level so far.

I originally had my dimensional loads running in sequence but the...

Hi John, thanks for the reminder about SQL injection. I think we are ok in this case.

I have the following which works perfectly.

Cheers for the help everyone.

Dave

DECLARE...

I should add that testing the dynamic SQL gives the correct result to @@temp_inner.

Hi all, thanks for the replies.

I am writing the SPROC to replace the function.

The below is where I am up to but I am getting a null result from SELECT(@SQL_FINAL)

any...

Msg 557, Level 16, State 2, Line 3

Only functions and some extended stored procedures can be executed from within a function.

Hi John, thanks for the reply.

I have implemented it as follows:

but I am now getting this error when I call the function.

Will this go away if I got back to...

Apparently it should be possible to use global variables inside SSRS to get the info I need.

I should be able to use:  =Globals!ReportFolder + "/" + Globals!ReportName in a parameter...

Hi, cheers for the response.

Yes the locking is at the SQL level and yes I am trying to avoid no lock on 1000 reports.

The scraping of the URL is...