On CNET: Pristine HDTV picture quality costs
2 Resources for

rumanapunawala@...

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Optimization of sql statements
SELECT NOTIFICATIONID, a.STATUS, NOTIFICATIONREFNO,(SELECT COUNT (*) FROM COMPANY com WHERE a.forcompanyid=com.parentcompanyid)AS PARENTINDICATOR, c.companyname as companyname, TRANSACTIONID, REFAMOUNT, REFCURRENCY, NOTIFICATIONDATE, FORUSERID, FORGROUPID, FORCOMPANYID, NOTIFICATIONHEADER, NOTIFICATIONMESSAGE, BANKACD, FORCOMPANYID, NOTIFICATIONHEADER, NOTIFICATIONMESSAGE, BANKACCOUNTID, b.NOTIFICATIONTYPEID, NOTIFICATIONTYPE, DESCRIPTION, REPLYREQ, TRXTYPE, CATEGORY, DECODE(CATEGORY, 'System', '1', CATEGORY) CATORDER FROM NOTIFICATION a, NOTIFICATIONTYPE b, COMPANY cWHERE (FORMATCODE NOT LIKE...
Tags: Category, BANKACCOUNTID, FORCOMPANYID, rumanapunawala@..., programming, SQL
Q&A 2006-05-01
Optimization of sql statements
SELECT notificationid, a.status, notificationrefno, (SELECT COUNT (*) FROM company com WHERE a.forcompanyid = com.parentcompanyid) AS parentindicator, companyname, transactionid, refamount, refcurrency, ...
Tags: Category, IS NULL, b.NOTIFICATIONTYPEID, rumanapunawala@..., programming, SQL, DESC, notificationType
Q&A 2006-05-01
  • << Previous
  • page 1 of 1
  • Next >>

TechRepublic's Data Protection Policy
Your organization is subject to a mix of strict legal, ethical, and self-imposed mandates that protect all of the organization's information, records, ...
Buy Now
Windows XP vs. Mac OS X
This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...
Buy Now