C#

<br />
CREATE VIEW titles_view<br />
AS<br />
select A.transID,A.Machine,Qlityno,batchnno,b.BTDes,color,startime,endtime,Cast((datediff(n,startime,endtime)-<br />
(SELECT ISNULL(SUM(DATEDIFF( n , TStoptime , Restarttime )),0)<br />
FROM FINTransTempstops B<br />
WHERE B.tranid = A.transid and B.TStoptime is not null))as integer)  as cf_TimeTook,exp_weight,actual_meters,specspeed,isrefish,next_process<br />
from finbatchinfo A left join FINTransTempstops c on A.transID = c.TranID <br />
left join FINBatchType B on A.BTID = B.BTID<br />
where endtime is not null --and startime >=convert(datetime,'2006-08-21',121) and<br />
--startime <= convert(datetime,'2006-08-31',121)<br />
group by A.transID,A.Machine,Qlityno,batchnno,b.BTDes,color,startime,endtime,exp_weight,actual_meters,specspeed,isrefish,next_process<br />
--order by A.machine<br />
GO<br />

ConnectionOptions options = new ConnectionOptions();

          ManagementScope scope = new ManagementScope("\\\\" + sRemoteMachine + "\\root\\cimv2", options);
          scope.Connect();
          ManagementPath mp = new ManagementPath("Win32_Product");

          ManagementClass classInstance = new ManagementClass(scope, mp, null);

          // Obtain in-parameters for the method

          ManagementBaseObject inParams =  classInstance.GetMethodParameters("Install");

           inParams["AllUsers"] = true;
          //inParams["Options"] = installationParameters;  // problem lies here
          inParams["PackageLocation"] = sourceFilePath ;  //source file must be on the remote machine


          // Execute the method and obtain the return values.

          ManagementBaseObject outParams =  classInstance.InvokeMethod("Install", inParams, null);