It says the problem with converting the expression to int.

I see only the date expression in this query, do you use any other expression also?

Also you can rewrite date_begin >=...

I believe its not a replication issue.

Please check with your admin team to investigate the issue with this VM.

Please check the SQLAgent whether its running or not on the server.

If its running, then it seems the required replication job is already running from previous execution ; restart it...

please share the error description and screenshot(s).

Let us know the work you have already completed and where exactly you've struck so that we can help you.

I think implementing the solution with CTE's is the best possible one; if not this, we need to think of using window functions if possible.

What's the final result you are expecting after combining the queries?

Please Ignore my previous clarification as its based on your first solution.

Can you explain why you are adding QtyDemand here?

My doubt is since for 1st row the demand is supplied using the quantity in that row, then why should we SUM...

;with cteSampleData

as

(

select id,name,parentid

from sampledata

where parentid is null

union all

...

use recursive CTE (Common Table Expressions) concept to build the query.

Thanks for correcting me.

SQL Agent Jobs information is stored in msdb databases.

But In latest version of SQL Server say SQL 2012 on wards, the SQL Agent Jobs info is directly saved into SSISCatalogue...

Few tables couldn't be dropped because of SCHEMABINDING in dependent views and functions etc.

Can you explain little more, the question is unclear.