1 Resources for

tc1.tc_opcode

Sponsored White Papers, Webcasts, and Downloads

(CASE Expression and Access 2003): Access 2003 allegedly supports SQL-92 (i've set it to do so), and the CASE expression is part of the SQL-92 standard (per SQL For Smarties 2nd ed., pg 127). So why then does this not work for me:ROUND(SUM(CASE WHEN tc1.Tc_OpCode = 'r' THEN 1 ELSE 0), 3)And what I really...; Tags: access 2003, andeezle, case, CASE Expression, database, END, Microsoft Access, software, sql, tc1.Tc_Hours, tc1.Tc_OpCode; Discussion threads 2005-09-07

Exploring the various uses of SQL's CASE keyword: Sql's Case KeywordVery usefulShowing Description in Group by clauseIn group by example, try the following querySELECT CASE WHEN price IS NULL THEN 'Unpriced' WHEN price < 10 THEN 'Bargain' ...; Tags: CASE, END, IS NULL, ramasubramanianm@..., software, SQL, sql server; Discussion threads 2005-08-30
Patch Panel and Cable Labeling: Any good idea for a patch panel and cable labeling schema in a large computer room.I would go with a letter/number system. Such as A1 A2 A3 B1 B2 C1 C2 etc... to identify the patch panels and then the jacks. If you are going to...; Tags: Cable, computer room; Q&A 2006-06-07

Windows XP Network Troubleshooting Power Checklist: Windows XP is pretty easy to connect to a network. Sometimes, however, things just go awry. That's when you need a strategy. This power checklist walks you through how to figure out what's wrong with Windows XP networking and how to get it fixed.; 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