Question: Is there a way to make a program which executes other programs?
I was creating a project for school then I had an idea of creating a main program which will run different program according to my choice.
I am using VS code and I created 2 programs in same folder(Here is the screenshot in case you are confused):

[![enter image description here](https://i.stack.imgur.com/rjX2C.png)](https://i.stack.imgur.com/rjX2C.png)

Here as you can see I have 2 programs(one is rockpaper.py and other is pass.py) inside of a folder named (ROCKPAPER) is there a way I can run both of these program by making another program inside of this same folder(ROCKPAPER)????
Is there a module for this?

Answer: 
Use this query :

```
select *,case when Actual<=DATEADD(HOUR, 10, CAST(CAST(DATEADD(day, 1, GETDATE()) AS DATE) AS DATETIME)) then 0 else 1 end as '1/0'  from #tmp      

```

today date is 2022-01-07 and my result is:

```
ID  Actual                     1/0
1   2022-01-06 13:55:29.340     0
2   2022-01-07 13:55:29.340     0
3   2022-01-08 13:55:29.340     1

```

If you want to compare with today then:

```
select *,case when Actual<=DATEADD(HOUR, 10, CAST(GETDATE() AS DATE) AS DATETIME)) then 0 else 1 end as '1/0'  from #tmp      

```

Output:

```
ID  Actual                     1/0
1   2022-01-06 13:55:29.340     0
2   2022-01-07 13:55:29.340     1
3   2022-01-08 13:55:29.340     1

```
```
Select *
     , Flag = iif(Actual < dateadd(day, datediff(day, '10:00', getdate()) + 1, '10:00'), 1, 0);
  From #tmp

```