How to run multiple setup file in one setup file click

SELECT [Year], January,February,March,April,May,June,July,August,September,October,November,December,

SUM(January+February+March+April+May+June+July+August+September+October+November+December) as Total

FROM

(SELECT YEAR(DateTime) [Year], CASE MONTH(DateTime) WHEN 1 THEN 'January' WHEN 2 THEN 'February'

WHEN 3 THEN 'March' WHEN 4 THEN 'April' WHEN 5 THEN 'May' WHEN 6 THEN 'June' WHEN 7 THEN 'July' WHEN 8 THEN 'August'

WHEN 8 THEN 'September' WHEN 8 THEN 'October' WHEN 8 THEN 'November' WHEN 8 THEN 'December'

END as [Month],ID

FROM TransactionDetails

where dateadd(dd,0,datediff(dd,0,DateTime))>='2016-01-10 21:50:12.000' and

dateadd(dd,0,datediff(dd,0,DateTime))<='2017-01-16 21:50:12.000') TableDate

PIVOT(Count(ID) FOR [Month] IN ([January],[February],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December]))

PivotTable group by January,February,March,April,May,June,July,August,September,November,December,October,YEAR

select MonthNo as Month,

SUM(TotalTrans) AS TotalTrans,SUM(CAST(TAmount as numeric) )as TransacAmount,SUM(CAST(PagePrint as numeric) )as PagePrinted,SUM(CAST(TWallet as numeric) )as WalletBal

from (select DATENAME(Month,DateTime) as MonthNo,CASE MONTH(DateTime) WHEN 1 THEN 'January' WHEN 2 THEN 'February'

WHEN 3 THEN 'March' WHEN 4 THEN 'April' WHEN 5 THEN 'May' WHEN 6 THEN 'June' WHEN 7 THEN 'July' WHEN 8 THEN 'August'

WHEN 8 THEN 'September' WHEN 8 THEN 'October' WHEN 8 THEN 'November' WHEN 8 THEN 'December' END as [Month],

COUNT(ID) as TotalTrans,SUM(CAST(WalletTransactionAmount as numeric) ) as TAmount,

SUM(CAST(PagePrinted as numeric) ) as PagePrint,SUM(CAST(WalletCurrentAmount as numeric) ) as TWallet

from TransactionDetails

where MachineID in(2) and dateadd(dd,0,datediff(dd,0,DateTime))>='2017-01-10 21:50:12.000' and

dateadd(dd,0,datediff(dd,0,DateTime))<='2017-12-16 21:50:12.000'

group by DateTime) as v1 group by v1.MonthNo order by v1.MonthNo asc

Krishna,

 

Glad that you were able to solve your problem.

 

Thanks and regards,

Chetan Ranpariya 

Hi,

Its Work

 

Krishna,

 

Whether to run in parallel or sequential that depends on your use case. 

 

I can think of two approaches to run the exes sequential.

 

1. You execute first setup file one click and invoke second setup file from the first one then third setup file from the second one and so one.

 

2. Another approach would be to control all the exes from the first setup.

First setup will invoke second setup, once that is completed it will come back to first one so first one will start the third setup, one that is completed it will come back to first one so first one will start the fourth setup and son on. 

 

As Vineed mentioned, it would be helpful to explain the use case and the functionality which you are trying to solve.

 

If you have the MSI files which you can not modify then you can create an exe in C# and write code to invoke MSI files one after another. (2nd approach).

 

You also can leverage Setup Project template of Visual studio to create setup project and invoke MSI files from there.

 

Thanks and regards,

Chetan Ranpariya 

Thanks for understand my Query but i have no any one idea How to implement this, i have multiple .msi file ..How Could we Execute one by one.Give me any one Example.Thanks in advance

 

Thanks & Regards

Krishna