Sorry for an unclear question previously; hopefully I can start again... I have this data: entityidnamestringvalue
I want to basically join these 3 table in a view for a report: Class Table: IDName 1N1 2N2 3N3 Flags Table:
Is it actually possible to rotate a T-SQL (2005) so that (for the sake of argument) the values of the first column\'s rows become the titles of th开发者_StackOverflow中文版e output table\'s columns?
I have a simple query over a table, which returns results like the following: idid_typeid_ref 2702531 27021614开发者_StackOverflow
SQL Pivot Help: I have three tables as follows: Class Table: ID Name 1N1 2N2 3N3 Flags Table: IDClassIDFlags 11F1
How do I get this: entityidnamestringvalue ----------开发者_Go百科- -------------------- --------------------
Every example of using PIVOT in MSSQL shows people using this to aggregate data. I\'m trying to exploit this to just simply transpose rows to columns
I am trying to mutlipivot source data (as below ) alt text http://img532.imageshack.us/img532/5418/sourcex.jpg
SQL 2005 using T-SQL, I want to rotate rows into columns. Sample script: Use TempDB Go CREATE TABLE [dbo].[CPPrinter_InkLevels](
I am in process of building Dimension开发者_运维技巧 from EDW (source), wherein I need to pivot columns of source to load Dimension.
加载中,请稍侯......