A little trick with SIGN and the OVER clause makes this a simple query

😎

USE AdventureWorks2012;

GO

;WITH MULTI_COUNTING AS

(

SELECT /* Sum the row numbers, gives distinct count */

...

IMHO: The ability to quickly hide and show the result pane is very helpful, especially when working with limited screen estate (laptops, tables & mobiles).

😎

What does this return?

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'MasterAgentPayments'

Do you have the duplicate table in a different schema?

😎

Next step, generate the create script for the table. Make certain to go first to tools->options and under SQL Object Explorer->Scripting select all the relative options.

Let us know what you...

Execute this statement (with the correct schema and table name)

EXEC sp_help 'schema.table'

Then look for the constraint and Foreign key reference sections. Resolve those!

😎

If it is not working then take a look at this: CTRL + R not working in SSMS 2012

😎

First thing that comes to mind is to use the SQL Server Import and Export Wizard from SSMS. (right click on the target sql database->Tasks->Import data) Walk through the Wizard...

For what it's worth, have a test system with 2005 and 2014 on it, not on the same drives though, 2005 is a default 1433 instance, 2014 a named instance,...

Chio, you could compare the installation logs from the different instances to track down the difference. I'll try out your component on a vanilla system and let you know the...

Hard to say without further knowledge, normally I would consider this a good and normal practice.

😎

Eric M Russell (5/2/2014)

I can confirm that 3 dimensional joins work quite well; it's the 12 or 20 dimensional...

Felt I could not leave this one hanging......:cool:

Use the output to insert the records into a table and export to excel/csv from there....

You can use the output clause with the delete

😎

DECLARE @TTABLE TABLE

(

TT_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL

,TT_VAL INT NOT NULL

);

INSERT INTO @TTABLE(TT_VAL)

VALUES...

I would recommend a dynamic package or in other words, programmatically generated packages. This is fairly straightforward from a script task in a master package.

😎