Did you mean
selection (35 results), vendor selection (16 results), Select Medical Corp. (1 results), Selectica Inc. (1 results)
Sponsored White Papers, Webcasts, and Downloads
- BNET Industries
- Select Comfort develops, manufactures, markets and distributes beds. Co. sells a line of beds under the Sleep NumberŪ brand featuring adjustable firmness air-chamber technology. In...
- Select Comfort Corp. company page on BNET »
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Find blocking processes using recursion in SQL Server 2005
- Blocking occurs in SQL Server 2005 when one process has one or more records locked, while another process tries to acquire locks on the same set or subset of records. This causes the second process to wait until the first process is done so it can acquire the records; this...
- Blog posts 2008-01-28
- Use Excel's MS Query Wizard to query Access databases
- Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program. There's data in your company's Access database that you need to analyze, but the PC you work with does...
- Technical articles 2006-09-19
- Write PIVOT queries in SQL Server 2005
- Pivot ?Hi,I came across this problem ,select * from (select distinct amountfc, amounttype, Date_,SupplierCode,InvoiceType, CostType,Total, Currency,ROE from invoice inner join inv_detailed on invoice.InvoiceID=inv_detailed.InvoiceID ) as resPIVOT ( sumAmountFC for AmountType in ( select amounttype from inv_amounttypes ) ) as testENDand yes, i understood this cannot be done, well it is one of...
- Discussion threads 2007-01-16
- can anyone explain.. SELECT @ApplicationId = NULL
- DECLARE @ApplicationId uniqueidentifier SELECT @ApplicationId = NULL what does this Select do? I have to modify as procedure but don't know what this code does. i am not a dba so bear with me.Well it declares a local variable@Applicatio
- Discussion threads 2006-11-10
- Optimize database code to boost performance
- Select COUNT(*) - secretSelect COUNT(*) DOES NOT do full table scan if table has a primary key. It counts the Index. Sometimes indexes may be 50MB for a 500MB table and Select COUNT(*) can be very fast! DB optimizition needs knowledge of programmer to get best out of the CBO...
- Discussion threads 2006-09-27
- How do I? Configure Microsoft Windows XP Remote Desktop?
- Supportingremote systems is much easier thanks to Windows XP's Remote Desktopapplication. The application's biggest benefit is that it provides access to adesktop as if you were sitting in front of the system. In addition to receivingthe actual desktop GUI, you can access network shares and printers as if seatedat the...
- Technical articles 2006-09-26
- Change your Excel worksheet defaults to fit your working environment
- Default Number of Pages in WorksheetAnother Default I change is the number of sheets or pages in a worksheet. Why open three worksheets when I normally only need one woksheet.1) Select Tools + Options2) Select General Tab.3) Change "Sheets in new Workbook:" setting to 1.4) Select OK button to save...
- Discussion threads 2006-08-07
- Dive into .NET with Web Matrix
- ASP.NET Web Matrix is a free download that lets you create ASP.NET Web applications, services, etc. Here's an overview of Web Matrix, as well as the steps you need to take to create a .NET Web solution using Web Matrix. Microsoft is tipping the scales in...
- Technical articles 2005-08-04
- Use hardware to partition tables horizontally in SQL
- You may not have to partition tables horizontally very often, but when the need arises, you'll need hardware resources to make it work. Get more details on horizontal partitioning. When a table grows to millions or even billions of rows, performance can be a serious problem. The...
- Technical articles 2005-07-25
- SQL retrieving only rows of a size
- I want to examine the grades of students only if there are at least 10 students in the class. I think I should be able to write something like this, but I get all classes. What am I doing wrong?selectshrtckn_subj_code,shrtckn_crse_numb,shrtckg_grde_code_finalFROM shrtckn LEFT JOIN shrtckg ON shrtckg_pidm = shrtckn_pidmWHERE (SELECT count(b.shrtckn_pidm)...
- Q&A 2006-07-18
- Find sequence gaps using Oracle's analytic functions
- OK, but......what usefulness is this? IMO, if you have an application that relies on sequential unique ID's, you should be change your DB/app design.This is also completely useless for clustered DB's, as sequential ID's are a huge performance hit.What about legacy systems that need this?They don't just go away...
- Discussion threads 2006-07-05
- Why does this Trigger go off?
- I have created a SQL trigger that should only work if both fields are updated. Can someone tell me why when ony one field is uptated that this trigger goes off. Thank YouCREATE TRIGGER send_update_requeston dbo.ONSA_NSSFOR UPDATEAS--- Send a Update request to the owning ONSA/AGENTDeclare @ID NVARCHAR (4000)Declare @subject...
- Q&A 2006-06-28
- Insert varchar value to number field
- Can i insert the values like thisINSERT INTO sara SELECT To_Numberagreementid from empHere sara table have agreementid as number(18,4)emp table have agreementid as varchar(255) but it contains only number in that field.While inserting i got ORA-01722 INVALID NUMBER error. I check there is not character in that field.Can anybody help...
- Discussion threads 2006-06-08
- LB Quick Visual Designer (zip)
- LB Quick Visual Designer is a select and draw GUI designer and aims to simplify Liberty Basic form creation and to provide a professional looking, Visual Basic like design environment for Liberty Basic language.
- Software downloads 2004-07-01
- Single Click is Double-Clicking instead
- I haven't changed any options. Now when I single click, it double-clicks instead. I can hardly get any work done, as it does this in every application I am in and is driving me insane! Please help!If you don't changed anything, probably it's a hardware problem. Change...
- Q&A 2006-05-23
- crate xl range name from a variable
- My macro copies a template worksheet, renames it with user prompted msgbox value with leading zeroes. The value "newname" becomes the sheet name as well as the contents of cell D3, E3 will contain a balance. I want to list the various D3's and E3's on Consolidated sheet so I...
- Q&A 2006-03-30
- Excel Spreadsheet Bloat
- I have had people in the past who have had spreadsheets that seem to "bloat" and the file size gets huge for no reason. I was able at one time to find some information on how to correct this. I think you select all empty cells and the clear...
- Q&A 2006-03-16
- Wireless novice
- We have a Linksys router in our office and although my laptop will connect, it will not allow any websites to load, it says " finding site, then switches me to an AOLsearch site but that never comes up either. Are there some settings that need changed or checked?...
- Q&A 2006-03-08
- Select Favorites Folder in web browser
- I would like to change the default favorites folder for my microsoft web browser Internet Explorer. I have done so in the past and forgot where the settings are located.Hope this helps http://windows.about.com/od/tipsarchive/l/bltip046.htm Poster rated this answer. ...
- Q&A 2006-02-21
- Multi boot
- I have installed a multi boot on my computer.There are three windows installed in three physically distinct drives.I was able to edit the menu presented when booting so that there is clear indication about which boot is which.Now I have deleted one windows installation and I would like to remove...
- Q&A 2006-02-06
- << Previous
- page 1 of 3
- Next >>
Content Types
- Blog posts (1 results)
- Discussion threads (17 results)
- Q&A (29 results)
- Software downloads (1 results)
- Technical articles (5 results)
Refining Tags
- Software (20 results)
- windows (10 results)
- programming (7 results)
- SQL (7 results)
- Microsoft Excel (6 results)
- hardware (6 results)
- Microsoft Corp. (6 results)
- Microsoft Access (5 results)
- server (4 results)
- Database (4 results)
- e-mail (4 results)
- Microsoft SQL Server (4 results)
- Databases (3 results)
- Enterprise Software (3 results)
- Data Management (3 results)
