Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Building a data values dictionary with SQL
- When a client asked a developer to construct a data values dictionary, the client was actually referring to a list of the distinct values in various columns and tables. Check out the basic SQL that was developed to fulfill this client's request. TechRepublic's free SQL Server newsletter, delivered each...
- Tags: SQL, Databases, Arthur Fuller, Programming languages, data values dictionary, distinct value, SELECT DISTINCT, SQL Server Newsletter, TechRepublic Inc., Procedure, Column, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Technical articles 2005-04-25
Additional Resources
- RECORD DUPLICATION
- dear All,now i am using sql server for database for my application.while I am using a query it give multiple records.I double checked with query analyser but no impact. please help..the query:"select domains.domainid,domains.dvendor,domains.dexpirydate,domains.wspace,domains.wexpirydate, clients.organisation, enquiry.dateoffollowup from domains inner join clients on domains.organisation=domains.organisation inner join enquiry on clients.organisation=enquiry.organisation order by enquiry.enquiryid...
- Tags: Databases, domains.organisation=domains.organisation
- Q&A 2005-07-27
- Question on Access 2000/XP Query
- In Access 2000, I build two Tables, for example, one for Items Basic Info: part number, description, and so on; another for Structure: ID, parent part number, child part number, Qty.Then I have a Query, select parent part number, its information from Basic Info table; based on this query design...
- Tags: hunter_jn_cn@..., Microsoft Access, new record, programming
- Q&A 2005-01-05
- Select statment in a VB code
- Select statement is timing out inside VB program code thereby resulting to ODBC failure. However the select command is correct and the same select command is working using query analyzer from the SQLSelect Statement in a VB CodeKindly post your code and let me check that to provide u the...
- Tags: tim.oyelowo@..., IVC_DATE, software, programming, Microsoft Visual Basic
- Discussion threads 2007-02-19
- DesktopAngel Diary (exe)
- You can record the daily things based on the date, the schedule and so on. At the same time you can select and edit them. Furthermore, you can group the whole documents under distinct colors. This version is the first release on CNET Download.com.
- Tags: Diary
- Software downloads 2008-01-16
- 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...
- Tags: for, hrubeshj17@..., in, Microsoft SQL Server, Microsoft SQL Server 2005, pivot, programming, select, Write PIVOT
- Discussion threads 2007-01-16
- Duplicate entries
- My Access Data base won't allow me to change the Serial number field and a couple of other fields to "NO Duplicates". I already have over a thousand records and don't want to search each field for duplicates is there a solution?Have you tried Microsoft's Knowledebase?I'm not an Access...
- Tags: Microsoft Office, Databases, Microsoft Access
- Discussion threads 2005-05-06
- Bizimg Foggy Autumn (zip)
- Foggy Autumn is a high quality wallpaper pack with beautiful top-grade distinct photos and a special software to select a wallpaper. Features: Top rated 6 high quality photos; Specially designed software for quickly select a right wallpaper.
- Tags: Wallpaper, Foggy Autumn, Tools & Techniques, Management
- Software downloads 2005-12-09
- Diary (exe)
- Write daily diary. You can record the daily things based on the date, the schedule and so on. At the same time you can select and edit them. In especial, the whole documents can be grouped under distinct color. Version 2.2 may include unspecified updates, enhancements, or bug fixes.
- Tags: Diary
- Software downloads 2008-01-10
- Store Result of SELECT stament to be used to UPDATE another table
- Hi, im trying to update a field of a table which is done through the results of a select statement. I need to be able to a store the results of the select statement which can then be used to determine if an update another table is initiated. This is...
- Tags: Notebooks, twanstall@..., laptop computer
- Discussion threads 2007-03-24
- How to write DISTINCT in sql's CASE ?,For that below query i am trying
- SELECT DISTINCT TO_CHAR(creation_dt,'MM/DD/YYYY') "Date of Creation",first_names "First Name", surname "Last Name", Section_Name "SSO ID",(CASE WHEN Authority_id = 'LEAD1' THEN 'Reconciler'WHEN Authority_id = 'LEADREV' THEN 'Reviewer'WHEN Authority_id = 'LEADRR' THEN 'Reconciler/Reviewer'WHEN Authority_id = 'LEADADMN' THEN 'Administrator'WHEN Authority_id = 'LEAD1' THEN 'Reconciler'WHEN Authority_id = 'LEADVIEW' THEN 'Browser' WHEN Authority_id = 'LEADCRE' THEN...
- Tags: Authentication/Encryption, SQL, m_shamanth, Authority_id, LEAD1
- Discussion threads 2007-08-31
- How to write DISTINCT in sql CASE statement ?
- How to write DISTINCT in sql CASE statement ?Answered in discussionswhere you posted as well.
- Tags: Programming languages, m_shamanth, SQL
- Discussion threads 2007-08-31
- Replay Racer (zip)
- For each race in Replay Racer, the game will select a challenging opponent for you based on your current skill level. Race 3 in distinct car types on 4 unique and challenging race tracks.
- Tags: Opponent, Race, Games, Personal Technology
- Software downloads 2006-08-28
- Galactic Justice (exe)
- Join the Galactic Council in the battle against the evil Boomdragons. Select from over 20 weapons and 50 orbs to create the ultimate vehicle to deliver justice. Travel to 5 distinct planets to earn badges of justice and take back the galaxy. Take the yoyo of justice and walk their...
- Tags: Justice, PoisonAxe Games
- Software downloads 2008-06-12
- Almost the opposite of duplicate query in MS Access
- I need to create a query that is almost the opposite of duplicate query in MS Access. It returns the lines that are not duplicates with one instance of duplicate line.Get to the SQL view of the SELECT query that gives you all the lines you want plus the...
- Tags: acampbell@..., Microsoft Access, Microsoft Corp., opposite, POSTER, SELECT, software
- Q&A 2005-02-21
- GigaTribe (exe)
- Create a private file-sharing (P2P) network to exchange large files with your friends. Only the users you have invited will see the files and folders you share. All exchanges are strongly encrypted. Interrupted exchanges automatically resume with no data loss. Define users groups to share distinct folders with distinct groups....
- Tags: Exchange, Peer To Peer (P2P), Internet
- Software downloads 2007-08-29
- Creating a form to append a table with values from other tables/data entry
- Hi,I have built an Access DB containing 3 tables: dimensions, time, companies. The tables are not linked and are to be used to look up values for the new form. The goal is to create an Access form that would allow the user to select distinct values
- Tags: access forms to append table, main table, programming, software, Value at Risk, zima8172@...
- Discussion threads 2006-10-12
- Understand Oracle 10g's new multiset operators
- Scott Stephens discusses Oracle 10g's new set of Advanced Multiset support operators for SQL Server 2003, which you can use with nested tables in an Oracle database. The Oracle 10g database release has a new set of Advanced Multiset support operators for SQL Server 2003, which ...
- Tags: Oracle Corp., Oracle Application Server 10g, Scott Stephens, Databases, Application servers, Enterprise software, Num, nested table, Oracle Tips Newsletter, Value, Table, NUM_TAB_TYP, Storage, Programming Languages, Software, Data Management, Hardware, Software Development, Software/Web Development
- Technical articles 2005-07-27
- I need a 'countif' equivalance in Access
- Hi, I am trying to create a query where it will count the occurance of distinct elements in a column. Example: Column name is Question1, and its values can be any of the following: 'Excellent', 'Good', 'Fair', 'Poor'. I would like to run a query to see how many...
- Tags: kosheno@..., Microsoft Access, SELECT, software
- Q&A 2005-10-12
- Query for data with the SELECT statement in MySQL
- This sample chapter, taken from MySQL 5.0 Certification Study Guide, discusses how to use the SELECT statement in MySQL to retrieve information from database tables. Learn how to use the SELECT statement to retrieve information from database tables. This information will help you prepare for the MySQL...
- Tags: Sams Publishing, MySQL, MySQL 5.0, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2006-02-07
- << Previous
- page 1 of 1
- Next >>
