The following scenario is an example of using CTEs with a MERGE statement.

Let's say you would like to update the status (attended, no show, canceled, rescheduled, etc.) of appointment records...

From SQL Server 2005 Books Online:

"The Merge transformation requires that both its inputs be sorted and the merged columns have matching metadata."

Make sure the second criterion has been met.

Sathish,

Your SSIS Control Flow tasks would be as follows:

1. Execute SQL - Create temporary table

2. Data Flow - Load data from source flat file into temporary table

3. Execute SQL -...

Sathish,

You can use the ranking function ROW_NUMBER() to generate the destination table you have described.

Ex. SELECT SINo, DeptNo, ROW_NUMBER() OVER (PARTITION BY DeptNo ORDER BY SINo) AS IncNo, Name,...

Scott,

There are several approaches you can take:

1. Call a different stored procedure from within your frontend for each session user id, or

2. Pass the session user id to a stored...

Tracy,

The first thing I would try to do is to run the report using a dataset that is a small subset of the data your stored procedure selects.  This could be...

Your SQL should be:

USE newDB

SELECT * FROM Person AS P LEFT OUTER JOIN Book AS b ON P.PersonID=b.AuthorID

GO

Sarah,

If the data source for your Web Pivot Table is OLAP, your users will not be able to use the "Create Calculated Detail Field" option on the Pivot Table toolbar. ...

Place the following expression in the Table Footer of the column in which you wish to display the report row count:

       =Count(Fields!Column.Value).

Note: Column is the name of a dataset field

Searching Google group microsoft.public.sqlserver.reportingsvcs

it appears one solution would be to group on field 'A', place a  count of the detail rows for a group in the group header (=Count(Fields!A.Value)),...

I would look into using the CountDistinct aggregate function for displaying the total number of stores

Andrew,

http://www.esri.com would be a good place to start.  One paper of note:

http://gis.esri.com/library/userconf/proc97/proc97/to650/pap650/p650.htm

HTH.

Tom