Sunday, March 27, 2011

System Run time Error

›
System Run time Error LD is not able to open use ? D:\LD\SYSUSER\lderror.dbf check error Index does not match the table. Delete the index fi...
Thursday, March 24, 2011

GLOBAL(NET OUSTANDING DETAILS)

›
Select Sauda.Oowncode as Oowncode, Sauda.Compcode as Compcode,' ' as Ndel, Rpad(' ',20) as Companyname, Sauda.Exchcode as...

Word cannot start the converter mswrd632

›
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Text Converters\Import\MSWord6.wpc # On the Edit menu, click Delete. # Click Yes. # Exit ...

Outlook Delivery report

›
1. On the Tools menu, click Options. 2. On the Preferences tab, click E-mail Options, and then click Tracking Options. 3. Under For al...

Auto Run disable

›
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer NoDriveTypeAutoRun 0xFF

LD Digital socket error 10054

›
This error happens when a connection is started (and working), but then closed by the other side of things before the SMTP conversation is c...

VBScript Email with authenticated SMTP User

›
Set wshShell = WScript.CreateObject( "WScript.Shell" ) strComputerName = wshShell.ExpandEnvironmentStrings( "%COMPUTERNAME%...
Wednesday, March 23, 2011

Branchwise Turnover

›
select distinct Brcode, sum(Grosspurch) Purchases, sum(Grosssales) Sales, sum(Totalvol) GrossTurnover, sum(Netpsvalue) NetTurnover, sum(Bro...

JV for specific code

›
Select journal.jvdate as jv_date, ' ' as jvdate,Journdc.Jvoowncode as oowncode, journal.jvnumber as jvnumber,journal.jvnum...

Sebi Compliance

›
Select tblCldata.cClientcode as Oowncode, Ldfibs.Fibsacct as Fibsacct,tblCldata.cClientcode as cTermcode, to_char(Accountgensplit.dOpeningda...

Acounts Brokerage

›
----------------JOBBING Brokerage----------------------- select ACCOUNTDETAIL.OOWNCODE , cljobb.brokcode, cljobb.DVALIDUPTO from ldbo.cljob...

Client Wrong Email ID

›
select distinct trim(accountemaildetail.oowncode),trim(accountemaildetail.email) from accountemaildetail,accountdetail where email like ...

Client Details

›
-----------Client complete details-------------------- SELECT distinct ACCOUNTS.OOWNCODE "CLIENT ID", TRIM(ACCOUNTS.FIBSACCT) ...

Daily Client Brokerage with Branch

›
---------------------Daily Client Brokerage with Branch---------------------------------- select distinct ClientCode,Brcode,Dtoftran, sum(Gr...

Trade Confirmation Query

›
---------------------bse------------------------- XLODBC 1 DSN=sns1011odbc;UID=;Pwd=;ConnectString=sns1011srv; SELECT sauda.exchcode, sauda...

CLIENT NONTRADING DAYS CASH

›
Select Ldfibs.Oowncode as Oowncode,Ldfibs.Fibsacct as Fibsacct,Ldfibs.cTermcode as cTermcode,Ldfibs.Brcode as Brcode, Accountgensplit.Dopen...

LTM Monitoring

›
select distinct cexchcode EXCHANGE, ------max(nordertime) OTIME, max(ntradetime)TTIME from TBLRKTRANHISTORY where trim(dtransactiondate)=tru...

Kill DLLhost from task Manager

›
When memory leaks occur in IIS scripts, you will find DLLHost.exe eating up a lot of memory and ultimately reaching a point where you will n...
Monday, March 21, 2011

DataBase Template FY 11-12

›
...
Saturday, March 19, 2011

LD Branch Change Process

›
Branch Change Process --------------------------------- File Code Branch 22500T001|2760 22500T002|2760 22500V001|2760 22500V002|2760 58...