Mohammad Rubol

Purpose : To modify stored procedure  scripts to combine data between MITECS + CAMSTAR to support SSRS report   Report name                                    Description                                         Stored procedure name HGA_WIP_FG_Inventory_Report                    HGA WIP summary Finish good inventory report        REP_HGA_WIP_FG_REPORT LotInformation_SubReport (sub report)          Drill down to see detail                            REP_HGA_WIP_FG_SUB_REPORT Option select data to generate report    1. CAMSTAR   2. MITECS   3. CAMSTAR + MITECS SQL Server Information : WDTBMITECSDEV01.tb.asia.wdc.com\WDBMITECS3TRAIN DB : User_datatemp User : repuser P/W : rep27090* Link server to get data from CAMSTAR : DV_THO_DEV Example : to query camstar inventory status from DV   select * from openquery (DV_THO_DEV,'SELECT TOP 10 * FROM CAMSTAR_INVENTORY_LOT_STATUS') require to show existing report compete get data from DV  Note... Pls. donot del

https://www.youtube.com/watch?v=No7QqSc5cl8 kudvenkat https://www.youtube.com/watch?v=qYqZZWNn-4Y My Google Drive:  https://drive.google.com/drive/folders/1q2xGOxhFmQZ6Ky3BdfsjVCb2XGtgmsNh https://github.com/smartsheet-samples/csharp-read-write-sheet Main()=>Calculate()=>GetProcess(double duration,string currentDate)=>DoTalking(object duration,string currentDate)=>CycleFirst(string currentDate) https://www.faceclips.net/video/r1FbKiHYHcw/parallel-prog.html https://marketplace.visualstudio.com/items?itemName=ComponentPro.TelnetComponentControlforNETCVBNET https://www.arclab.com/en/kb/csharp/read-write-text-file-ansi-utf8-unicode.html https://code.msdn.microsoft.com/Operate-UNIX-Secure-Shell-294e37b1 Remotely executes commands on Windows/Unix server over Telnet channel  establish a connetcion from C#.net to UNIX Shell