If you wanted to do this regularly then a view might be an answer.

Below is a script to generate the view using a SP and a cursor. Not that...

The real reason that the update fails is that the subquery is not related to the table being updated. This causes the subquery to join all rows from the...

Job 2 locks the table objects in exactly the reverse of job 1. Try using the code below for job 2. This would cut down the...

You have two agents that are updating the account and account history actions tables. The locks for these are interfering with each other. In agent 1 ( inserting...

Before any help can be given please post the code to create and query the table. Remember that an identity column is not always used as a key field...

Please clarify your requirement with examples of the data held and the output required. The original post stated both ANSCI and ANSIC, neither of which I have come across...

Sorry did not mean to undermine the SQL 2008 answer that was given. The Focus functionality is a lot close to SQL 2012 that 2008 in this respect.

Fitz

Are you looking at copying the changes across or the complete table? If the table is growing then the time taken to copy will increase.

Have you looked at :

1....

It really depends what you need out of this reorganisation of the tables.

1 - If each person had a unique address that you will not save any space...

I agree this Lutz about the design. In SQL Server 2012 this becomes a little easier with the introduction of lag and lead functions.

declare @tbl table

(

Name VARCHAR(30),

Dept VARCHAR(30),

EndDate DATETIME

)

SET...

The difference is the Core edition is aimed at the Windows Core edition rather than standard Windows.

Fitz

The query that was used in your first post caused an alphabetic range to be created and used (char(10)). This would lead to the range '26-03-2012' to '30-03-2012' to...

It maybe worth evaluating the new CDC components within SSIS. CDC has been added at both the Control flow and data flow levels.

Check the privileges allocated to the two accounts (WebSSISProxy and SQL Agent Services account). To get the result as shown privileges are missing from the WebSSISProxy. Which permissions...

I think that you may be looking to include the % as a search term as in the demo below. If this is the case use the replace technique...