Technical Corner

Gridview remove column

2012-02-05T14:45:00.001-08:00

GridView1.Columns.RemoveAt(2);

Getting result

2012-01-13T13:58:00.001-08:00

select WWMLNM,* from crpdta.F0111 a left outer join crpdta.f0101 on wwan8=aban8 where WWIDLN=0 and ABTAXC in('N' , 'P','1' ) and wwan8 in(select a6an8 from crpdta.f0401) and WWMLNM like '%,%' and upper(WWMLNM) =WWMLNM COLLATE Latin1_General_BIN

Convert datetime with 00 time - sql-server

2012-01-04T20:00:00.000-08:00

select cast(convert(char(11), getdate(), 113) as datetime)

UpdateParameters Session variable Gridview

2011-12-13T22:23:00.001-08:00

<%@ Page Title="" Language="C#" MasterPageFile="MasterPage2.master" AutoEventWireup="true" CodeFile="ownerdet.aspx.cs" Inherits="ownerdet" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <form id="form1" runat="server"> <center> <br /> <b>Insert Owner</b> <br/> <table style="width: 60%"> <tr> <td

Load data in Account balance file F0902 - JDE

2011-12-13T15:03:00.001-08:00

create proc fteupload as select * into #FTE from dbo.BudgetData where obj_desc like '%FTE%' declare @edtn integer select @edtn=max(gbedtn) from JDE_CRP.CRPDTA.F0902Z1 INSERT INTO JDE_CRP.CRPDTA.F0902Z1 (GBAID,GBCTRY,GBFY,GBLT,GBCO,GBEDUS,GBCTID,GBEDTN,GBAN01,GBAN02,GBAN03,GBAN04, GBAN05,GBAN06,GBAN07,GBAN08,GBAN09,GBAN10,GBAN11,GBAN12,GBMCU,GBOBJ,GBSUB,GBUSER,GBPID,GBUPMJ,GBJOBN,GBUPMT,GBCRCX,

Upload Budget Data in F0902 JD Edwards

2011-12-13T14:17:00.001-08:00

Upload budget data in F0902Z1 Verify in P0902Z1 Run R14110 to Upload data in F0902.

JD Edwards - Get max sequence in role -security

2011-12-08T19:36:00.001-08:00

select distinct FSUSER,FSOBNM,RLTOROLE,AUSEQNO ,FSSETY,FSINSL,FSRUN into #temp_03 from SY900.F00950 left outer join SY900.F95921 on fsuser=RLFRROLE left outer join SY900.F00926 on auuser=fsuser where RLFRROLE is not null and FSUSER not in('ESS','MSS','SYSBLOCK','ERREQ') AND AUSEQNO is not null AND FSOBNM<>'' AND FSSETY='3' order by 1 select distinct FSUSER,FSOBNM,RLTOROLE,AUSEQNO ,FSSETY,FSA

Copy Sql-server database

2011-12-02T06:03:00.001-08:00

very simple....Pick a source and destination server.Select databases to copy.:- must see this step http://msdn.microsoft.com/en-us/library/ms188664.aspx

Employee History by Job tile and salary JD Edwards

2011-11-29T17:00:00.001-08:00

distinct jwan8 Emp#,yaalph Name,yahmcu BU,abalph Supervisor,jmdl01 Title, DATEADD(dy, cast(jwefto as varchar(10)) % 1000, DATEADD(yy, cast(jwefto as varchar(10)) / 1000,-1))EffDate ,yesal/100 Salary,DRDL01 JobCategory fromjde_crp.crpdta.F08042 leftouter join jde_crp.crpdta.F08001 on ltrim(jmjbcd) = ltrim(JWHSTD) leftouter join jde_crp.crpdta.F060119 on jwan8=yean8 and jwefto=yeefto leftouter

JD Edwards EnterpriseOne Create BI Report

2011-11-12T22:07:00.000-08:00

Introduction to LDAP

2011-10-15T21:55:00.001-07:00

Introduction to LDAP What is LDAP Lightweight Directory Access Protocol Based on X.500 Directory service (RFC1777) Stores attribute based data Data generallly read more than written to No transactions No rollback Hierarchical data structure Entries are in a tree-like structure called Directory Information Tree (DIT) http://quark.humbug.org.au/publications/ldap/ldap_tut.html

SQL Trigger Error - The row value(s) updated or deleted either do not make the row unique or they alter multiple rows (2 rows).

2011-10-14T17:57:00.000-07:00

The row value(s) updated or deleted either do not make the row unique or they alter multiple rows (2 rows). Put SET NOCOUNT ON as following:- Create TRIGGER [dbo].[OBIEE_USERSTRI_DEL] ON [dbo].[WC_OBIEE_USERS] FOR DELETE AS SET NOCOUNT ON BEGIN DECLARE @USERNAME1 VARCHAR(100) DECLARE @GROUPNAME1 VARCHAR(2000) SELECT @USERNAME1 =USERNAME,@GROUPNAME1=GROUPNAME FROM Deleted insert into

TRIGGER Sql-server on OBIEE user table insert and delete

2011-10-12T17:08:00.001-07:00

CREATE TRIGGER [dbo].[OBIEE_USERSTRI_INS] ON [dbo].[WC_OBIEE_USERS] FOR INSERT AS BEGIN DECLARE @USERNAME VARCHAR(100) DECLARE @GROUPNAME VARCHAR(100) SELECT @USERNAME = (SELECT USERNAME FROM Inserted) SELECT @GROUPNAME = (SELECT GROUPNAME FROM Inserted) insert into WC_OBIEE_AUDIT(USERNAME,GROUPNAME,USERID,DATEUPD,WORKSTN,[ACTION]) select @USERNAME,@GROUPNAME,SYSTEM_USER,getdate(),host_name()

no Forms Authentication Login Page Redirect When You Don’t Want It

2011-10-09T21:56:00.001-07:00

In an ASP.NET web application, it's very common to write some jQuery code that makes an HTTP request to some URL (a lightweight service) in order to retrieve some data. That URL might be handled by an ASP.NET MVC controller action, a Web API operation, or even an ASP.NET Web Page or Web Form. If it can return curly brackets, it can be respond to a JavaScript request for JSON. http://

Coupa API

2011-10-07T22:16:00.001-07:00

http://www.coupa.com/general/pain-relief-in-the-cloud-integration-part-1/

Create Trigger JD Edwards Table

2011-09-30T13:01:00.001-07:00

Create Trigger JD Edwards 1.Check out the table to which you want to attach event rules and click Design. 2.On the Table Design form, select the Design Tools tab and click Start Table Trigger Design Aid. 3.Select an event from the Events list. 4.On Event Rules Design, click one of the event rule buttons and complete the event rules. 5.Click Save to save the event rule specifications and then

IDENTITY column in sql-server in select into

2011-09-29T14:10:00.001-07:00

select IDENTITY(INT, 10, 1) idnt ,* from testdta.F5510004

my first TRIGGER ever sql-server

2011-09-28T14:44:00.001-07:00

ALTER TRIGGER testTRIGGER ON dbo.QTD_HOURS1 FOR INSERT AS BEGIN insert into QTD_HOURS1Trg select a.* from QTD_HOURS1 a left outer join QTD_HOURS1Trg b on a.[column 0]=b.[column 0] and a.[column 1]=b.[column 1] where b.[column 0] is null END

Convert Date range into month

2011-09-26T22:21:00.001-07:00

select --startdate,enddate,datepart(MM,startdate),datepart(MM,enddate),enddate, case when (datepart(MM,startdate)<='1' and datepart(MM,enddate)>'1') then 1 else 0 end Jan, case when (datepart(MM,startdate)<='2' and datepart(MM,enddate)>'2') then 1 else 0 end Feb, case when (datepart(MM,startdate)<='3' and datepart(MM,enddate)>'3') then 1 else 0 end Mar, case when (datepart(MM,startdate)<='4'

Fusion Middleware Developer's Guide for Oracle SOA Suite

2011-09-20T21:25:00.001-07:00

Fusion Middleware Developer's Guide for Oracle SOA Suite 11g Release 1 (11.1.1.4.0) Business Process Execution Language (BPEL), short for Web Services Business Process Execution Language (WS-BPEL) is an OASIS[1] standard executable language for specifying actions within business processes with web services. Processes in BPEL export and import information by using web service interfaces

JD Edwards OBIEE Time dimension

2011-09-18T21:18:00.001-07:00

Very good sample on Julian date time dimension to create sales report check this out sample.http://www.youtube.com/watch?v=IsNTTweoZ4s

OBIEE development document

2011-09-18T09:24:00.001-07:00

http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/e12187.pdf

OBIEE 11g installation Windows

2011-09-18T07:12:00.001-07:00

OBIEE 11g installation for windows... http://debaatobiee.wordpress.com/2011/02/13/oracle-business-intelligence-enterprise-editionobiee-11g-installation/ http://www.adivaconsulting.com/adiva-blog/item/10-obiee_installhttp://www.oraclenerd.com/2010/08/obiee-11g-install-part-i.html

UBE0000084 ERROR: Function: PDFDocGen_Save, Code: 3, Message: Bad parameter.

2011-09-17T08:52:00.001-07:00

The issue is that in tools release 8.98.4.4 if a batch job is suppose to produce print output that is just a single blank page, no PDF file is generated for thebatch job and the batch job ends in an 'E' (error) status. Bug# 12977338 The fix will go in tools release 8.98.4.6.

POC fix JD Edwards

2011-09-17T08:41:00.001-07:00

A POC fix is an untested fix that you can apply to your tools release to test with to see if it works or not.