Please do not post to multiple forums.  It fragments the conversation.  Please respond on https://www.sqlservercentral.com/forums/topic/update-start-date-using-end-date-3

Drew

I've also used values like the package StartTime which aren't going to change within a single execution of a package.

Drew

May i know the reason why i get this error The data types varchar and datetime2 are incompatible in the add operator. when i changed variable from date time...

People are hesitant to open Excel files posted on the Internet.  You should post the expected results the same way that you posted the sample data: create a temp table...

It would also really help if you gave expected results.  I guessed at what you were looking for.

This is a variant on the packing intervals problem.  The time that each...

If you are only interested in the DATE part, why did you define it as a DATETIME parameter instead of a DATE parameter?

Drew

Why are you cramming Students, Departments, and Orders into the same table without any way to differentiate them?  They're completely different objects with completely different details.

Drew

I believe that the # are from MS Access SQL.  That's why I didn't comment on them.

Drew

When you use a GROUP BY everything in the SELECT clause has to be a property of the group.  You can achieve this by using the expression to define the...

SELECT Date,
       SUM([101]) OVER (ORDER BY Date) Acct#1,
       SUM([201]) OVER (ORDER BY...

Frames were introduced in SQL 2012.

Drew

SELECT Date,
       SUM([101]) OVER (ORDER BY Date) Acct#1,
       SUM([201]) OVER (ORDER BY Date) Acct#2,
...

I also realize that this post is really old but below is a script I put together that could be helpful to others running across this post. This script...

He mentions importing from Excel, not from a CSV.  I think it should be fairly straightforward to import from Excel, but it's been a long time since I tried it.

Drew

You may be right, but it's certainly not obvious how you would use it without hard-coding values.  Would you care to elucidate?

Drew