That sounds like your entire process.

Doesn't your SSIS package contain multiple steps?...

• This reply was modified 4 years, 4 months ago by Phil Parkin. Reason: Fix typo

Indeed, but there is no ELSE in there, so we have to make assumptions about what...

all this web service is to process each route one by one for stops and students, and street corners. After one route, process another one. It repeats same process...

Would agree - except the solution doesn't work for dates where month is greater than 4

I read the requirement several times and ended up shrugging my shoulders and sending in...

Have you analysed execution logs to determine where the slowness occurs?

If you are hoping for a coded solution, please take the time to provide your sample data in a form which we can paste into SSMS and execute.

Frederico provided some.

String Concat missing, ur trying to concat a string and an integer

DECLARE @frdate date = '01-01-2021'DECLARE 
@ytdfrDate date
if Month(@frDate) < 4begin
SET @ytdfrDate = '01/04/' + cast(dateadd(y,-1,@frdate)...

Can you provide some consumable data, please? That is, some CREATE TABLE and INSERT statements which we can paste into SSMS and execute?

Also, please explain the link between Invoice and...

I don't think that we are in a position to take you much further with this task....

It would help if you would provide consumable data next time (check my code to see how this is done).

DROP TABLE IF EXISTS #SomeTab;

CREATE TABLE #SomeTab
(
 ...

• This reply was modified 4 years, 4 months ago by Phil Parkin. Reason: Slight code improvement

You seem to be having trouble understanding what is being requested.

What Jeff is talking about is that you provide us with some sample code which we can cut and paste...

A lot of people here use SQL Prompt and to get the most help from it during query writing, it's best to have the FROM clause written, including all JOINs...

Why not just give the column a default value in SQL Server? Perhaps you want all of the entries in the batch being process to have the same value.

It is not easy to query the content of packages which have been deployed to SSISDB, because the deployment process also encrypts the package contents.

But assuming you have all of...