You really want to look at a pivot table for this.

Review these articles:

http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

Fraggle

SQLRNNR (3/9/2013)

---

Fraggle-805517 (3/9/2013)

---

General question here, but I am under the impression that a clustered primary key index, is essentially the table itself. If that is the case, does it...

General question here, but I am under the impression that a clustered primary key index, is essentially the table itself. If that is the case, does it make sense...

Sorry guys. I wasn't very clear. I already have a script to move all index (except primary keys) to a different file group. However, with Primary Keys,...

Alright, so apparently named pipes wasn't a red herring. It was the issue. My apologies for the confusion on that. Turned on Named Pipes in SAC, restarted...

opc.three (12/27/2012)

---

What does this say when run against the Publisher, the Distributor and the Subscriber:

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

...

I...

quackhandle1975 (12/27/2012)

---

1. It may not be possible to replicate from 2005 to 2012 (off hand I don't know this) you may need to have the 2005 server at SP4?

2. The...

In setting up replication, I ran across this issue:

Here is the situation. We are trying to use Transactional Replication from a 2005 Standard system to a 2012 BI system....

Lowell (10/22/2012)

---

i've played with Microsoft.SqlServer.Management.Smo.Scripter that is part of the microsoft.sqlserver.managment.sdk.sfc ;

using that, you can tokenize any SQL statement.

i did it when i was playing with making my own SQL...

Eric M Russell (10/23/2012)

---

Fraggle-805517 (10/19/2012)

---

...

Now, I don't know if this is really called parsing or replacing or something completely, different, but I have a hard time believing that someone hasn't...

Sadly I am only just now learning OO and C#. And all of my developers are pretty busy for the next few months on a major project. So...

Yea, I have looked at this. However, it aggregates everything and within the system I am trying to do, add's a lot of unnecessary overhead. I am already...

A note on resetting the endpoints. It will take your database offline for the duration of the restart. This is "expected" behavior per Microsoft support that hasn't been...

General question on this really old post. Has anyone updated this to use 2012 yet? I have it on my 2005 system, but we just upgraded to 2012....