Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
- Exch5.5 - major dramas
- Hi all,My Exchange 5.5 server today completely baffled me when it began spitting the following error into the App log on Win2k server (9 times per second):Source: ESE97Categ: PerformanceEvt ID: 0Desc: MSExchangeIS (2580) Unexpected NT API error:0xC0000054I rebooted it and saw that it needed to initiate extensive...
- Tags: database, e-mail, General Evt ID, information store, MSExchangeIS Categ, sake, server, Source
- Q&A 2006-01-09
Additional Resources
- Five ways Cisco Network Assistant 5.2 can make your life easier
- WYSIWIG is for wimps?I was a pure CLI guy for our Cisco devices. (73 buildings to manage)I decided to impelement port-security. Naturally, your going to miss some machines, like printers go to sleep and don't show up on a scan, so later you have to figure out where the are,...
- Tags: PRODUCTIVITY, bdmeyer@..., CLI, WYSIWIG
- Discussion threads 2007-09-07
- Viewing customer ledger
- i'm a beginner in vb using crystal rep 8.5 when i want to view a customer ledger report should be date wise pertaining to just one specified customer selected from a vb form eg:frmCustLedger. The report shd be like this date----Desc----Debit----Credit---Balance. Wherein the desc column...
- Tags: Operational accounting, speak2aarti@...
- Discussion threads 2007-10-05
- Convert MSAccess Query to MSSQL
- I am looking to report the last 6 months Gross Total Sales on a website using ASP VbSCript. eg. Jan|Feb|Mar....eg. 10000|5000|32445...I have successfully create a monthly mapping table in Access with 2 columns of static data MonthNo (1-12), MonthName (Jan-Dec). Then i wrote a quick Query in Access called 'Monthly'...
- Tags: Databases, bkirk@..., MonthNo
- Discussion threads 2007-08-22
- WebSubmitter (exe)
- This software submits your Web site to many search engines and thousands of directories. Easy to use. Automatic submission. Just introduce your Web site desc, title, URL. You can use it many times as you need. This version is the first release on CNET Download.com.
- Tags: Web, Web Site, Web Site Development, Web Technology, Channel Management, Internet, Marketing
- Software downloads 2008-04-28
- wanted links to engineers desc of the chipset in f i c mbrd 2megcache550cpu
- wanted engineering description of the chipset in F i C mbrd that has 2meg cache 550 mhz cpu and bios to drive 6 g of memory HOW TO FANAGLE A CHIPSETplease ?????????????????????????????????????????
- Tags: Chipsets, Semiconductors, chipset
- Discussion threads 2005-07-13
- Control null data in Oracle using the ORDER BY clause
- NULL data, which is sometimes called "absent" data, can be difficult to work with in relational databases. When a query contains the ORDER BY clause to sort the output, NULL data will sort to the bottom if the sort is in ascending order ASC and to the top if the...
- Tags: oracle, databases
- Blog posts 2007-06-19
- MS Acess Dlookup, checkboxes and dates
- I've created a MS access database to keep track of traffic thru a gate using a scanner. If a person comes in a chk box is marked, if out the "In" box is unchecked and the "out" box checked and so on back and forth. I also want to maintain...
- Tags: ecampos, Me.chkIn, Microsoft Corp., software, Surname
- Q&A 2005-08-16
- 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
- The Ideal Number of IT Staff for My company
- Hi,...Recently I got promotion to be IT Head. The old one move to other country.Basically there are only 3 people in the team including me.I've been working as Analyst Programmer for several years. The other two : one has a strong knowlegde about network and the other is a fresh...
- Tags: NETWORKING, yuan@..., IT-staff
- Discussion threads 2007-09-19
- summarize by date in a sql statement
- I am trying to write a report in Excel, I am using 3 tables from a sql server database, one table has tech labor by invoice which I want to sum by date, the 2nd table is Tech name and id #,the 3rd table is time clock entry by date....
- Tags: Char, INSTHIST.DATESTAMP, INSTHIST.DATESTAMP,121, INSTHIST.LABOR_TIME, MECHANIC.MECHANIC_NAME, programming, sparkee16@..., SQL
- Q&A 2005-12-23
- VB.Net 2005 DataGridView problem
- I am still very new to the .net 2005, I have used vb6 for so many years it is getting dificult switching over to .net. ok here is my problem I am trying to show info into a datagridview via SQL querry. I have figured out how to...
- Tags: .NET, Programming languages, Microsoft Visual Basic.Net, cwarley
- Discussion threads 2007-04-13
- name and desc. in XP Security box
- Does any one know how to include the Computer Name and Description in the title of the XP Windows Security dialog box that comes up when you press CTRL ALT DEL?Either that, or some way of customising the title of the Windows Security dialog box? I know it can be...
- Tags: Microsoft Windows XP, security, stuart_at_oz, Thanks!, Value, Value at Risk, Value Data, windows
- Q&A 2005-07-06
- My Windows XP workgroup act unpredictive
- HIi have windows XP workgroup with one professional and 4 home editioni have 3 share on the xp professional machineDESCfirst share is c drivesecond share is y drivethird share is z driverunning norton ghost for backup on y and z driveand one accounting programm working from the c drive sharePROBLEMon...
- Tags: Operational accounting, Financial services, Backups, Microsoft Windows, k2patel98@..., Z-Drive, accounting, C-drive, Microsoft Windows XP
- Discussion threads 2007-08-23
- VB.NET Access DB DataSet problem
- I'm developing a VB.NET 2005 application with an MS Access backend. The Queries for the most part are "LIKE" queries, and they will not return rows in the application when querying in Access I return rows. When I run a "=" query I return rows from the application...
- Tags: Microsoft Office, Databases, Programming languages, .NET, culbysl@..., Microsoft Access, Microsoft Visual Basic.Net
- Discussion threads 2007-09-01
- Error Gaurd Good or Bad
- Recently one my clients came to claiming that Error Guard had fixed his slow and freezing start up problems taht he was having. (which were non exsitant when I build the machine.) I told him that I've heard error gaurd causes more problems than it fixes and is a source...
- Tags: Spyware, adware & malware, Spyware, Cyberthreats, Viruses and worms, SECURITY
- Q&A 2006-02-25
- Online Game Administrator.needs advice
- Hello fellowship of TechRepublic, I need advice...suggestion..or help.I am a Administrator of an Online Game Service in Indonesia, and i'm thinkin of a career change because well...i feel that i'm not making any career improvement here.Compare to my IT counterpart jobs such as System Analyst,DBA,System Administrators,Sys.Engineer...i dont see any prospect...
- Tags: AndreAkbar, career, information technology, job, online game, Web site
- Q&A 2005-03-08
- Jet SQL and T-SQL handle duplicate values differently
- Access databases use Jet SQL—at least they use to. The more familiar Access database format (the .mdb file) has always used Jet SQL. Access projects, however, use Transact-SQL (T-SQL), which is the version of SQL that SQL Server uses. Access users unfamiliar with T-SQL and SQL Server might assume that...
- Tags: Databases, Susan Harkins, Figure B T-SQL, Jet SQL, T-SQL TOP, Microsoft Access, Microsoft SQL Server Transact-SQL
- Technical articles 2003-06-19
- Implementing a FIFO and a LIFO stack in SQL Server
- multi-threaded accessThese solutions work when requests come in slowly, so that only there is only one request at a time doing a push or pop. However, when two or more requests are serviced simultaneously, both might obtain the same @ItemNumber. Using an identity column would resolve this issue, but the...
- Tags: exception handling, I-Lin, Microsoft SQL Server, server, software, stack, threading
- Discussion threads 2005-06-28
- << Previous
- page 1 of 1
- Next >>
