Simple answer No. This is for three reason : 1-it breaks the MCP/MSL rules to show or reveal details of the questions 2-if you knew the questions before hand...

You have not given details of tables A and B. Assuming that tables A and B have not got a unique constraint on the memberID (as you specifically stated...

SQL 2005 see Dwain.C answer above.

Probably easier in SQL 2008 to use GROUPING SETS to accomplish the same result without 6 selects. This is built on the same data as Dwain.C without the CTE...

The LIKE clause could provide the level of checking required. A demonstration is listed below.

The next choice you want to make is what you want to do...

It depends where the extra column is put.

If you want to have a source table with I, U and D indicators then you no longer require a merge...

Try this for a demo of the MERGE you require. The DELETE something I would shy away from when using the MERGE as most of the time I would...

The final query is upto you. The @Outputresults holds all the records with the action type. Aggregate the changes by type and sum, min, max, avg the other...

As per the books online description of the OUTPUT clause the only output values are columns from the inserted or deleted tables plus scalar functions. Aggregate functions are not...

I think that utf-8 is used in SQL SERVER 2008 r2 and before. The new SC (supplementary character) sets are available in SQL SERVER 2012.

http://msdn.microsoft.com/en-us/library/ms143503.aspx

Fitz

CELKO, how does your method address the number of users available to assign the jobs to and the maximum concurrent jobs that need not be exceeded for each user during...

The code below will allocate the maximum concurrent jobs to the available users. Using NTILE with a select query will allow the jobs to be spread over the available...

Could try a clr aggregate for concatenate...

http://www.mssqltips.com/sqlservertip/2022/concat-aggregates-sql-server-clr-function/">

http://www.mssqltips.com/sqlservertip/2022/concat-aggregates-sql-server-clr-function/

This would return the products in a single column and allow a comma separated list

Fitz

Try this working with your data. I have created 2 extra tables for the locations and decode_locations. Working on a binary theme each location can be allocated a...

Thanks for the tip Rudolf, never knew that the delete from the CTE would affect the underlying table but the code as posted as a note earlier would not work...