Thanks Jeff, I never have seen or used the COUNT(DISTINCT <column> ) in the SELECT or HAVING. That is kinda of hard to visualize.

Great Article!!!

Thomas

That is a good responce, never would of thought of using dynamic SQL to pivot.

Thanks,

Thomas

I think you need to break the table into multiple tables with foreign keys. You should probably read Joe Celko's Stairway to Data and to Database Design and Gregory Larsen's...

I would attend a local SQL Saturday and look for BI track. Then, get some names and contact info from attendees and speakers to start networking with BI related SQL...

Look fowarding to speaking, networking and skiing!!!

Thomas

Andy,

You meniton that connections are stored in your profile. Where is the profile?

"As you develop SSIS packages on a server, you create connections. The connections you create are stored in...

The problem was I created the SP in our DBA database on the instance, then the shortcut was DBA.dbo.sp_xxx.

The SP and table have to be in the same database and...

I get SELECT * FROM [Person].[Contact] when I run it.

Thanks,

Thomas

Right-click on Database and go to Tasks\Export... Pick table for Source, and Flat File Destination for Destination. There is an option under Format including column names in the first data...

This article needs to be proof read by somebody, lots of mistakes in listings and missing queries to try.

Should never have brought in the 3rd normal form stuff.

Thomas

Get formatting and explanation in the article.

For a followup article, maybe you could go into more detail about where the changed data is located internally in SQL Server:

FROM [person].[person]...

Jeff,

No problem.

Thomas

Yes.

Restore backup, and populate table.

Recreate the publication and subscription and make sure to use the NoSync initialization.

I have done this for columns added to large tables in replication.

Bing search "no-sync...

3rd party backup software

Thomas

Look at books Online for Pivot table