Refreshable Excel direct connection with SQL Server

Refreshable Excel direct connection with SQL Server

Convert JD Edwards Julian date to calendar date PL SQL

Convert JD Edwards Julian date to calendar date SELECT TO_CHAR(TO_DATE(Y$CKDT+1900000, 'YYDDD'), 'MM/DD/YYYY') as CheckDate, F1.* FROM PRODDTA.F0719 F1

Checkbox Click Event Sencha Ext JS

{

                        xtype: 'checkboxfield',

                        boxLabel: 'All Municipal',

                        name: 'AllMunicipal',

                        margin: '0 0 0 0',

                        listeners: {

                              change: function (checkbox, newVal, oldVal) {

                                  if (newVal == '1' && oldVal == '0') {

                                      var allCheckBoxes = checkbox.up('checkboxgroup').items.items;

                                      for (var i = 0; i < allCheckBoxes.length; i++) {

                                          allCheckBoxes[i].setValue('1');

                                      }

                                  }

                              }

                          }

                    }

 

 

https://forum.sencha.com/forum/showthread.php?137463-Checkbox-Click-Event

 

Recordset RecordCount VBA C# .net

Sometime we have to count record set and take decision wheather to show result in excel or not. If count is too much excel can crash. for that people are running same query two times, one time count and another time display record. In order to avoid this run query onece and take decision. like following:- If Recordset.RecordCount > 20000 Then Response = MsgBox(WorksheetFunction.text(Recordset.RecordCount, "_(* #,##0_);_(* (#,##0);_(* ""-""??_);_(@_)") & "Records......Continue?", vbYesNo) If Response = vbNo Then GoTo CleanUp_Exit End If https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset-recordcount-property-dao

Adaptive Insight Data Integration & Connection API

Adaptive Insight Data Integration & Connection API

Web Services API
• Design and implement your own automated integration to Adaptive products
• Access data within your Adaptive application with a lightweight interface
• Adhere to RESTful Web Services principles
• Accepts and returns requests in the form of XML documents

http://cloud-erp.com.au/wp-content/uploads/2014/08/ap_data_integration_screen.pdf

Convert JD Edwards Julian Date to Calendar date in Excel Formula

JD Edwards Julian Date Converter in EXCEL Formulas

Formula to convert a Calendar date to JDE Julian date:
 =CONCAT(YEAR(A1)-1900,RIGHT(CONCAT("000",DAYS(A1,DATE(YEAR(A1),1,1))+1),3))

Formula to convert JD Edwards Julian date to a Calendar date:
=DATE(LEFT(A1,3),1,1)+(RIGHT(A1,3)-1)

QTD quarter date from and to

DECLARE @tDate DATETIME

SET @tDate = GETDATE()

 

SELECT @tDate AS 'Input Date',

  DATEADD(q, DATEDIFF(q, 0, @tDate ), 0)

                        AS 'frmDate',      

  DATEADD(d, -1, DATEADD(q, DATEDIFF(q, 0, @tDate ) + 1, 0))

                        AS 'toDate'




Get the size of all database in a SQL-Server

    SELECT DB_NAME(database_id) AS DatabaseName,
           sum((size * 8.0) / 1024.0) SizeMB
    FROM sys.master_files
    WHERE DB_NAME(database_id) in(SELECT name FROM sys.databases )
group by DB_NAME(database_id)
order by 1

Godaddy Comma Delimited load CSV file

select  
'Select '+
''''+ cast(SrNo as varchar) +''','''+ StateName+''','''+ cast(TINnumber as varchar) +''','''+ StateCode+''''+' Union '
      from  [dbo].[TblJA_StateCode]

Fw(%RNDDIG,1,2): .

Click here!

CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE

--SELECT UserName,BankName,AccessType  FROM [BUDGET].[dbo].[TBLBNK_ACCESS]
drop table #temp1
SELECT UserName ,BankName,
      AccessType =
              STUFF ( ( SELECT ','+InrTab.AccessType
FROM [TBLBNK_ACCESS] InrTab

WHERE InrTab.UserName = OutTab.UserName AND  InrTab.BankName = OutTab.BankName

ORDER BY InrTab.AccessType
FOR XML PATH(''),TYPE
   ).value('.','VARCHAR(MAX)')
  , 1,1,SPACE(1)) into #temp1
FROM [TBLBNK_ACCESS] OutTab
GROUP BY OutTab.UserName , OutTab.[BankName] ;

select * from #temp1

Send Receive SMS in C# MVC

https://www.youtube.com/watch?v=ndxQXnoDIj8  

Gridview Save as excel without dropping leading 0's (zeros) C# sap.net

 protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=ForecastData.xls");
        Response.Charset = "";
        Response.Write(" ");
        Response.Write("ForecastData");
        Response.Write("

");
        //Response.Write("Date:-  " + DateTime.Today.ToShortDateString());
        Response.Write("

");


        // If you want the option to open the Excel file without saving then
        // comment out the line below
        //Response.Cache.SetCacheability(HttpCacheability.No Cache);
        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new
        HtmlTextWriter(stringWrite);
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            GridViewRow row = GridView1.Rows[i];
            //Apply text style to each Row
            row.Attributes.Add("class", "textmode");
        }
        GridView1.RenderControl(htmlWrite);
        string style = @"";
        Response.Write(style);
        Response.ContentType = "application/text";
        Response.Write(stringWrite.ToString());
        Response.End();

    }

code by Neha

AR Statistics History Update program

This section provides overviews of the Statistics History Update program, periodic statistical calculations, and aging information on periodic statistics, lists prerequisites, and discusses how to:

• Run the Statistics History Update program.

• Set processing options for Statistics History Update (R03B16A).

https://docs.oracle.com/cd/E16582_01/doc.91/e15085/updatearstatscustomer.htm#EOAAR00132

AS of file build in JD Edwards

https://www.jdelist.com/vb4/showthread.php/32156-AR-as-of-File-Can-someone-help-me