On ZDNet: Why email is your enemy
1 Resources for

merge statement

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

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

Additional Resources

mail merge issues
I am using a spreadsheet with different amounts of data fields for eeach customer. When I merge to my word document the blank data fields appear as 0's. I have tried a skip if statement and an if statement and cannot get these to leave the empty data fields blank...
Tags: rabiduejd@...
Discussion threads 2007-02-09
Mail merge data and graphs into a letter
I am trying to do a benefit statement for our employees. I need to find a program that will merge the data for each individual into a letter and also set it up somehow so that I can merge a graph into the letter that will be specific to each...
Tags: graph, thaugen@...
Discussion threads 2007-02-05
The Power of the BY Statement
When used to its fullest potential, the BY statement can save time and effort, and add clarity and simplicity to SAS programs. It can make complex coding problems simple or accomplish in one pass what would otherwise require multiple passes of the data. Unfortunately the full power of the BY...
Tags: Statement, SAS Institute
White papers 2007-05-14
Let Your Data Power Your DATA Step: Making Effective Use of the SET, MERGE, UPDATE, and MODIFY Statements
The "Plain vanilla" SET statement is ubiquitous in SAS programming. It feeds the contents of a data set to a DATA step. This usage only scratches the surface of the capabilities of the SET statement and its siblings (MERGE, UPDATE, and MODIFY). Data sets typically are more than collections of...
Tags: Statement, SAS Institute, Programming, Development Tools, Software Development, Software/Web Development
White papers 2005-03-09
Delete rows during updates using Oracle 10g's MERGE statement
In Oracle 10g Release 1, the MERGE statement gained the ability to delete rows, as well as update and insert them. This Oracle tip shows you how it works. The MERGE statement, introduced in Oracle 9i Release 2, is often called an "upsert" because it can both...
Tags: Oracle Corp., Oracle Application Server 10g, Storage, Databases, Bob Watkins, Listing B, clause, Oracle Tips Newsletter, Transaction, Statement, MERGE, UPDATE, INSERT, Application Servers, Business Intelligence, Enterprise Software, Software, Data Management, Hardware
Technical articles 2007-02-20
Mail Merge - Merge to new document problem
Dear All,I have a user who runs a "Mail Merge" in MS Word and sometimes comes across the following problem. After the user adds "Mail Merge Recipients" and then clicks on the icon to "Merge to New Document" the text overlays itself, so each character in a line or section...
Tags: nick.mcdonald@..., Mail Merge
Discussion threads 2007-11-16
Data Sources in Mail Merge
In Word 2003, is it possible to use more than one data source for a single mail merge document? The data sources are Access databases.I don't think you can use two data sources for one merge, but you can merge your access databases together, then use the table or...
Tags: Microsoft Word, Word processors, Microsoft Office, data source
Q&A 2005-02-16
Merge 2 excel files to MS word mail merge
I have more than 1 excel files to merge with mail merge. First, I combined them into 1 excel file but cannot because we have more than 255 columns. Please help me with this problem
Tags: Word processors, wirapornk@..., Microsoft Word, Microsoft Corp.
Discussion threads 2007-04-10
Create and Print Envelopes for a Mass Mailing
When one wants to use envelopes to send a mass mailing to the address list, one can use mail merge to create a batch of envelopes. Each envelope contains an address from the list. The mail merge process entails the following overall steps: set up the envelope, connect the envelopes...
Tags: Merge, Address List
White papers 2007-12-01
Merge (exe)
Merge is a very simple graphic utility for overlaying two images prior to saving to a file and printing. You can merge the two images in different ways as well as smooth blending of just part of an image. There is a feature to batch-merge several images with one reference...
Tags: Image
Software downloads 2007-02-15
Visual Merge (zip)
Visual Merge is a visual folder synchronization and file merge utility. The program is particularly useful for software engineers, web designers and other professionals who often need to compare and merge two versions of the same source file. The program shows two files side-by-side and highlights the differences between them....
Tags: Mode, Visual Merge, Channel Management, Mice, Productivity, Tools & Techniques, Marketing, Hardware, Peripherals, Management
Software downloads 2005-09-16
PDF Split-Merge (exe)
PDF Split-Merge is a stand-alone application that can be used to split, merge, and manage your PDF files, PDF Split- Merge is offered as an easy to use GUI application, and a command line application. PDF Split-Merge is used to split files by pages, you can split the file into...
Tags: Adobe PDF, PDF Split-Merge
Software downloads 2006-05-04
PDF Merge for .NET (zip)
The PDF Merge for .NET can be used as to merge PDF documents, images in any format supported by .NET, HTML files and strings, and texts in a single PDF document. The library can be used from any .NET 2.0 application (windows forms, ASP.NET web sites, or command line tools)....
Tags: Adobe PDF, Outside Software Inc., .Net, Application Servers, Middleware, Software Development, Software/Web Development, Enterprise Software, Software
Software downloads 2007-04-18
Personalize Newsletters With E-mail Merge in Publisher 2007
If the business depends on making customers feel personally cared for, the person know the value of a newsletter. But he might also know how time-consuming it can be to tailor the message and offerings in a newsletter and manage the recipient list. Now the new E-mail Merge feature in...
Tags: Newsletter, Microsoft Corp., Corporate Communications, E-mail, Marketing, Online Communications
Webcasts
Visual Merge (exe)
Visual Merge is the easiest application for personalized PDF mailings ever. Visual Merge enables you to create personalized mail-merge documents using PDF forms as templates. Import data from Excel document or Microsoft Access database. Creating a personalized mailing is highly intuative due-to the direct visual feedback.Version 1.3.3.46 may include unspecified...
Tags: Adobe PDF, Visual Merge, Microsoft Excel, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
Software downloads 2006-11-01
Merge Cells Wizard for Excel (zip)
With Merge Cells Wizard you can merge data from several Excel cells using any separator you like (e.g. carriage return / line break). You can merge row by row, column by column or data from selected cells into one cell. The Merge Cells Wizard preserves all data if the selection...
Tags: Microsoft Corp., Merge Cells Wizard, Microsoft Excel, Microsoft Office, Office Suites, Software
Software downloads 2007-03-05
Merging dates from Excel into a mail merge document
I'm using Excel 2003 as my data source and Word 2003 as my main document in a mail merge I've done many times before. This year, however, I can't seem to get cells with text to merge properly. OK is merged as 12:00:00 AMThe only thing I can...
Tags: Microsoft Office, Microsoft Word, Word processors, jlcopp@..., Microsoft Excel
Discussion threads 2007-04-20
Mail Merge in Microsoft Word 2002
The presenter of this webcast will discuss how to use the mail merge features in Word 2002. He will talk about the different types of merge documents that one can create, the different types of data that one can use, and some of the most common difficulties that a person...
Tags: Word processors, Microsoft Office, Microsoft Word 2002, merge, Microsoft Word, Webcast, Microsoft Corp.
Webcasts 2006-10-20
Macro after a mail merge (Microsoft Word)
I have created a document for a mail merge and what results is 1 for yes criteria and a 0 for none criteria. What I'd like to do is have the 1 appear as a check mark. But I can't seem to do it with the merge fields...
Tags: jepspele@..., merge fields, software, mail merge, Microsoft Corp., Microsoft Word
Discussion threads 2007-02-28
  • << Previous
  • page 1 of 1
  • Next >>


Cisco IOS Command Chart (IOS v.12+)
Becoming proficient with Cisco equipment means remembering a whole new set of commands. These command charts give you a quick way to look up the needed IOS commands and switches when you need them.
Buy Now
Microsoft PowerPoint Advanced Functionality
Microsoft PowerPoint Advanced Functionality is a preformatted presentation for training staff to maximize Microsoft PowerPoint's more advanced functio ...
Buy Now