Viewing 15 posts - 181 through 195 (of 1,183 total)
GSquared (12/15/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2011 at 11:20 am
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....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2011 at 10:36 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2011 at 10:19 am
Read up on PIVOT in BOL if the values are known, or search this site for Dynamic Pivot if not.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 15, 2011 at 10:11 am
Steve Jones - SSC Editor (12/13/2011)
That uses SSRS. While that's the preferred method, if you don't have an SSRS server, I don't...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 13, 2011 at 3:31 pm
Another approach is us FOR XML PATH ....
CREATE TABLE #Normalized
([TimeStamp] [datetime] NOT NULL,
[ToolID] [smallint] NOT NULL,
[VariableName] [nvarchar](12) NULL,
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 13, 2011 at 12:58 pm
Steve Jones - SSC Editor (12/13/2011)
In T-SQL, I'm not sure how easy this is. In SSIS,...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 13, 2011 at 8:43 am
Please post DDL and sample data create scripts and it'll be easier to help you.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 13, 2011 at 8:33 am
bradmcgehee@hotmail.com (12/12/2011)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 12, 2011 at 11:02 am
with the requirements you've laid out ....
SELECT .....
FROM .....
WHERE
WHERE
PubstartDate BETWEEN @Startdate AND @Enddate
OR
PubEndDate BETWEEN @Startdate AND @Enddate
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 8, 2011 at 11:29 am
The file RegSrvr.xml located C:\Users\<user name>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell should get you what you need.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 8, 2011 at 6:47 am
Hugo Kornelis (12/7/2011)
Jason Selburg (12/7/2011)
With the question being "What values are returned"
The...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 7, 2011 at 10:03 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 7, 2011 at 9:41 am
hmm, I don't see anything else.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 1, 2011 at 1:42 pm
In short, YES ... http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgDecember 1, 2011 at 1:29 pm
Viewing 15 posts - 181 through 195 (of 1,183 total)