customerid

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

How do I... Print a label for an individual record in Microsoft Access?

Printing labels is a common task and simple enough if you use the Microsoft Access Label wizard. You can print thousands of labels at one time. What isn't as easy is printing a label for a single record. You have to identify the record and pass it to a label...

Tags: Database, Microsoft Access, Query, Report, Microsoft Corp., Record, Form, Printing Label, CustomerID, Productivity, Document Management, Databases, Microsoft Office, Storage, Enterprise Software, Software, Finance, Managerial Accounting, Data Management, Office Suites, Hardware, Susan Harkins

Blog posts 2007-09-24

Build molecular queries from atoms in SQL Server

What is your preferred method of doing things? Arthur Fuller says his M.O. is what he calls molecular queries. This scalable technique allows him to re-use and re-combine the atoms as requirements demand. Every SQL Server developer has a preferred method of doing things; mine is what I...

Tags: Microsoft SQL Server, CustomerID, Databases, Arthur Fuller, server, ExtendedAmount, Northwind_New, SQL Server Newsletter, TechRepublic Inc., Atom, Column, Productivity, Enterprise Software, Software, Data Management

Technical articles 2006-09-01

How to improve the query speed?

How should I consider to improve query speed in oracle9i.Thanks for the suggestion!How long have you got ?They write books about this topic.Your going to have to hand out a bit more info, otherwise I'm going to wear the letters off my keyboard.Like what query, table structures, available indexes, sorting,...

Tags: Programming languages, Java, Databases, Jason Dong

Discussion threads 2005-10-10

Create an AutoLookup query in Microsoft Access

Want more Access tips and tricks? Automatically sign up for our free Microsoft Office Suite newsletter, delivered each Wednesday! You can reduce typing time by basing your Access forms on AutoLookup queries. For example, let's say you need todevelop an Order form that includes fields from both the Customers table...

Tags: AutoLookup, AutoLookup query, Customers table, Mary Ann Richardson, Microsoft Access, Microsoft Corp., Orders table

Technical articles 2005-03-15

Additional Resources

Understand the ambiguities of compound JOINs in SQL

Arthur Fuller explains why he wants developers to think about this general principle: Compound JOINs become nonsensical when one of the clauses references only one of the tables. This article begins with a test. Look at the SQL below and determine, without using your computer, what the ...

Tags: SQL, Arthur Fuller, dbo.Orders.OrderID, dbo.Orders.CustomerID, Databases, SELECT dbo.Customers.CustomerID, NULL CustomerID, OUTER JOIN dbo.Orders, dbo.Customers, SQL Server Newsletter, TechRepublic Inc., Clause, Row, dbo.Customers.CustomerID, Programming Languages, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2005-07-25

Problem with SQL Query in Visual Basic

The following query works if I remove the "tblLocations.PrimaryFlag=-1" from the WHERE statement. I wanted to see if anyone could tell me what I am doing wrong. I have also tried "tblLocations.[PrimaryFlag]='-1'" and "(((tblLocations.PrimaryFlag)=-1))". I need to be able to filter for records with a -1 result for...

Tags: Microsoft Visual Basic, programming, SELECT tblCustomers.CustomerID, strSQL, tblLocations.PrimaryFlag, tblLocations.PrimaryFlag=-1, twhite@...

Q&A 2005-09-14

Understand the ambiguities of compound JOINs in SQL

good use of on clauseActually, I do use elements of the on clause that only reference one table to good effect. I use it when the table I'm joining with has a lot of records in it that I would like to filter out before joining, (e.g. a description lookup...

Tags: clause, dbo.Customers.CustomerID, dbo.Orders.CustomerID, dominic@..., join, joins, software, SQL, sql server

Discussion threads 2005-11-15

Displayging Querie results from multiple tables in a form

I have a form I am using to Edit records from two joined table records. If it finds a match in the second table it works fine. I want to use a copy of the form to add new records to the second table. The first table has the master...

Tags: second table

Discussion threads 2006-01-04

Using SQL Server 2008's MERGE statement

Can you get the Identity key back?This is a great idea. It can reduce the "CU" of my CRUD stored procedures to have one for both create and update.When doing the "WHEN MATCHED", can you do a begin/end block there so that you can capture the @@IDENTITY value?YesYou could do...

Tags: Paul C., Using SQL Server 2008, SELECT CustomerID, TotalSalesCount, TotalSalesAmount, GetDate, LoadDate

Discussion threads 2007-09-25

Can a combo box be set to display only certain data

I have a combo box that selects a customer and brings up all of the data associated with that customer (Billing data on Main form, Order data (on Sub form #1) and Shipping Data on Sub form #2)...The combo box is unbound and uses a select table/query.Both subforms are 'bridged...

Tags: imroseofsharon@..., combo box, Sub

Discussion threads 2007-09-12

Using SQL Server 2008's MERGE statement

SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. In previous versions of SQL Server, you have to create separate statements if you need to insert, update, or delete data in one table based on certain conditions...

Tags: Microsoft SQL Server, Data, Statement, Table, SQL Server 2008, MERGE, MERGE Statement, Tim, Sales Strategy, Sales Force Management, Databases, Enterprise Software, Sales, Software, Data Management, Tim Chapman

Blog posts 2007-09-24

Assess a SQL Server applicant's skills with this TSQL test

For Test item #7: "Return the Product Category and the average Sale Price for those customers who have purchased two or more products." If what you really asked as I believe you intended to ask was:"Return the Product Category and the average Sale Price for those customers who have purchased...

Tags: applicant, developer, george_c57@..., Microsoft SQL Server, programming, server, SQL

Discussion threads 2006-10-23

Building and using table UDFs in SQL Server

Table UDFs (user-defined functions) are one of Arthur Fuller's favorite features of SQL Server 2000 and 2005. Find out why he says that, if you've never used them, you may be in for a surprise. Table UDFs (user-defined functions) are one of my favorite features of SQL Server...

Tags: Microsoft SQL Server, UDF, Databases, Arthur Fuller, server, SQL Server Newsletter, TechRepublic Inc., Fun, Table, Enterprise Software, Software, Data Management

Technical articles 2006-08-07

JOIN table and stored procedure

Is is possible to JOIN a table and the results of a stored procedure (ANSI SQL, Oracle, MySQL or SQL Server)join...You would have to put the results of the stored proc in at least a temp table, then do the join. Is that what you are looking for? ...

Tags: Databases

Discussion threads 2005-02-25

Basic and complex SQL joins made easy

If you think SQL JOIN statements are beyond your reach, think again. This quick review of basic concepts makes joins easy by explaining each type and showing you how to use them.If you’re new to SQL, joins can be a daunting concept. There are many different types of joins and...

Tags: Programming languages, Databases, Shelley Doll, SQL

Technical articles 2002-07-08

Explore the capabilities of Query of Queries in ColdFusion MX

One of the features Macromedia introduced in ColdFusion 5 was the ability to execute SQL statements against a pre-existing query result set. It called this functionality Query of Queries. With ColdFusion MX, the Query of Queries feature set has been expanded even further. I’ll show you how to use Query...

Tags: Programming languages, Development tools, Databases, Brian Kotek, ColdFusion MX, Allaire ColdFusion

Technical articles 2003-06-09

Defining cascading referential integrity constraints in SQL Server

Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user...

Tags: databases, sql server

Blog posts 2007-06-25

Applied reflection: Write 80 percent less access code when interacting with a database

Databaseinteraction is old hat to enterprise application developers. If you are a .NET developer,chances are you have used the SqlParameter, SqlCommand, and SqlConnection classes. There is also a high probability thatyou have noticed how monotonous and time consuming it is to use these classesto implement data access. Microsoft solved some...

Tags: Â Â Â Â Â Â Â, data access, Data Access Block, database, Database interaction, SqlParameter, Zach Smith

Technical articles 2006-09-26

Understand the effects of NULLs on inner and outer JOINs

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs. SQL Server developers must understand two things: the difference between inner and outer JOINs and the effect of NULLs upon these choices. This tip ...

Tags: Human Resources, Row, Column, Databases, Arthur Fuller, Network technology, SQL Server Newsletter, Networking, Enterprise Software, Software, Data Management

Technical articles 2006-11-28

Thinking SQL: Set-based logic can improve query performance

You can't teach an old dog new tricks—atleast that's what the cliché says. Many developers intentionally try to be the "olddog" so they don't have to learn new tricks. Some developers, even thosewho have been developing client server, Web-based, and smart clientapplications, still approach problems with a procedural mindset. They...

Tags: customer id, id, performance, Robert L. Bogue, SELECT Customers.ID, SQL

Technical articles 2005-01-18