GSquared (12/15/2011)

---

A key question here is, are the regions reasonably static? You have Australia in there. How likely is that to go away, or be split in two,...

Ok. Read the article in my signature on how to best post sample data, then post your code with some DDL for sample data and I'll supply the pivot statement....

It really depends.

Is this a one time need?

Why do you need it that way?

You can just as easily paste the data into an Excel spreadsheet and then copy...

Read up on PIVOT in BOL if the values are known, or search this site for Dynamic Pivot if not.

Steve Jones - SSC Editor (12/13/2011)

---

Hardly, too many articles to keep track of. :w00t:

That uses SSRS. While that's the preferred method, if you don't have an SSRS server, I don't...

Another approach is us FOR XML PATH ....

CREATE TABLE #Normalized

([TimeStamp] [datetime] NOT NULL,

[ToolID] [smallint] NOT NULL,

[VariableName] [nvarchar](12) NULL,

...

Steve Jones - SSC Editor (12/13/2011)

---

Run the query for the top 20 and then loop through it, running additional queries.

In T-SQL, I'm not sure how easy this is. In SSIS,...

Please post DDL and sample data create scripts and it'll be easier to help you.

bradmcgehee@hotmail.com (12/12/2011)

---

My editorial got edited after I wrote it, and one important part of the message I was trying to get across apparently got deleted. In the original draft of...

with the requirements you've laid out ....

SELECT .....

FROM .....

WHERE

WHERE

PubstartDate BETWEEN @Startdate AND @Enddate

OR

PubEndDate BETWEEN @Startdate AND @Enddate

The file RegSrvr.xml located C:\Users\<user name>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell should get you what you need.

Hugo Kornelis (12/7/2011)

---

Jason Selburg (12/7/2011)

---

Allthough the intention of the question is valid and I got it correct, the SQL itself is not.

With the question being "What values are returned"

The...

Allthough the intention of the question is valid and I got it correct, the SQL itself is not.

With the question being "What values are returned"

The correct answer is "None...

hmm, I don't see anything else.

In short, YES ... http://www.sqlservercentral.com/articles/Development/2824/