Thanks Howard (sorry I forgot in my first reply) and Gail.

These are 'end user' views, and used to feed SSAS and reports, the tables are pretty small with around 100-150 million rows in, although it seems some of the developers...

Marbo (1/10/2013)

---

Hi ringovski,

I don't fully understand what your point is but isn't it simple to use a second send email task with probably a second variable or expression.

Or create a...

We will need to have a little more than that if we are to help, Ideally we would need the same DDL (Table definitions), some sample data, and an example...

In TFS you shouldnt need to use the SP_rename you should just be able to alter the column name in the relevant underlying projects.

Are you using a DB project in...

atapia_

Nice piece of code providing the table was blank, but what happens when #New_Table already contains data as per below.

Insert into #New_Table

Values (1,'0000000000')

,(2, '1111111111')

,(3, '1111111111')

,(4, '2222222222')

,(5, '3333333333')

,(6, '2222222222')

the code provided...

Basically it works by ordering the data in the source table and assiging a Row number to each of the source rows (Select in the CTE)

Then a Left Join with...

Ok, looks like our posts crossed, the above should work.

Heres another way, but it assumes that you dont care if other Rows are duplicated, and will add rows to New_Table Provided the total in New_Table doesnt exceed 3 rows

With...

Have you considered using the filestream feature http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx

As storing video etc is going to cause your database to grow very rapidly.

Ok, That is what I thought.

The question is do you want to allow duplicates?

For example would you want to have Id's 1,6 and 7 duplicated in the new table if...

Something like this should work, provided the New table is empty.

Create TAble #Old_Table

(Id int, National_Code varchar(20))

Create TAble #New_Table

(Id int, National_Code varchar(20))

Insert into #Old_Table

Values (1,'0000000000')

,(2, '1111111111')

,(3, '1111111111')

,(4, '1111111111')

,(5, '1111111111')

,(6, '2222222222')

,(7, '3333333333')

With...

This should work, there are other ways as well

CREATE TABLE #Id

(

Id int

)

Insert into #Id

Values (10),(12),(9),(15),(8),(4),(100),(29)

Select Id,Right('000'+Convert(varchar,Id),3) from #Id

Personally I put the Primary Key clustered index on the surrogate Key in the Dimension, with a non-clustered index on the Business key.

Unless the dimension is a Type 1,...

Personally I would stick with the Exists solution as IMHO its far easiernd understand compared with the Count(*) method.