Columns to rows and rows to column conversion without pivot/unpivot

SQLServerCentral » Latest topics

Columns to rows and rows to column conversion without pivot/unpivot

All I need is convert Column(A1/A2) into rows and rows(1 into Jan) into columns.Input:

Here A1/A2 belongs to say A and they are calculated as A1/A2 for each month.

more info...

Subscribe to: Post Comments (Atom)

Subscribe To

Posts

Atom

Posts

Comments

Atom

Comments

Followers

Blog Archive

• ►  2018 (580)
  • ►  June (93)
  • ►  May (99)
  • ►  April (110)
  • ►  March (104)
  • ►  February (81)
  • ►  January (93)

• ▼  2017 (3854)
  • ►  December (274)
  • ►  November (609)
  • ►  October (663)
  • ►  September (677)
  • ▼  August (707)
    • Why Missing Index Recommendations Aren’t Perfect
    • The Table Valued Constructor
    • https://www.prohealthguides.com/keranique-hair-gro...
    • date fillers - dates in two rows
    • Display records horizontally
    • first wife adopted in 1949 When
    • Today's Random Word!
    • script to run dbcc indexdefrag for all databases i...
    • SSIS as an Execution Engine for Multiple Sql scripts
    • Curious Case of SUM Function
    • Appreciating New Perspectives
    • The Adequate DBA
    • script to run dbcc indexdefrag for all databases i...
    • Today's Random Word!
    • SSRS Default dates if statement
    • Database Development Made Easy?
    • Query cancelled but completed is 0...
    • copying a database from one server instance to ano...
    • Update Statistics..
    • Anyway to find the row based on the page number
    • Compare database structure
    • Installing SQL Server Agent on SUSE Linux
    • What does LockTime out event , text data is interp...
    • http://www.healthyapplechat.com/nouvelle-beaute-se...
    • SSIS as an Execution Engine for Multiple Sql scripts
    • Today's Random Word!
    • List all logins, databases, role mapping
    • Returning Measure from Dim Date.
    • Can Uber, Lyft, and Waze Save Lives in Natural Dis...
    • Today's Random Word!
    • Determining causes for performance difference in q...
    • Determine Monday of next month and Monday of next ...
    • Finding Consecutive Values For a Record
    • Time increments
    • security admin/db_security admin role permission i...
    • Database Development Made Easy?
    • Create a database from backup when the backup tran...
    • Solved - Can I join these tables with a query to o...
    • A Logical Consistency-Based I/O Error
    • Replication alternatives for SQL Server 2016 Web E...
    • Performance tuning, alternative to cursors for my ...
    • Sessions and preconference at Microsoft Ignite and...
    • Are the posted questions getting worse?
    • Sql Cannot establish new connection
    • Case and replace
    • Dynamically read images from share path and displa...
    • Join with Same table
    • Comic for 2017.08.30
    • How to Find Out Which Database Object Got Deleted
    • The Azure Data Lake Catalog
    • Houston, Hurricane Harvey, and Technology
    • Trying To filter Data using LAG() and LEAD() funct...
    • Handling Transactions - Try/Catch - Error
    • Columns to rows and rows to column conversion with...
    • Database Development Made Easy?
    • Are the posted questions getting worse?
    • do you have a StripNonNumeric ITVF function?
    • Query Help
    • Who's Responsible?
    • running stored procedure in a loop to get Top leve...
    • Today's Random Word!
    • SSIS Package Permission Proxy Account
    • Are the posted questions getting worse?
    • Object Level Recovery Tool
    • Graphing Performance
    • Are the posted questions getting worse?
    • Query Help
    • Who's Responsible?
    • Setting up New Sql Server
    • general question on query performance
    • Strange transaction log activity
    • Comic for 2017.08.29
    • Extending DevOps practices to SQL Server databases...
    • SSAS Data Source Impersonation Information
    • http://www.healthitcongress.com/prime-ageless-serum/
    • Incremental Package Deployment – A SSIS 2016 Feature
    • Today's Random Word!
    • Install SQL Server Named Instance using silent ins...
    • Calculating averages
    • A Data ID
    • Install SQL Server Named Instance using silent ins...
    • a bit or that have been clarified
    • Comic for 2017.08.28
    • Biztalk DBs in compatibility mode
    • Importing data reports data truncation in both EM ...
    • Full text search with Contains function
    • AlwaysON 2014 Mulit Site Failover Cluster keep ale...
    • Job reported: Unable to terminate process (reason:...
    • Script or Ways to check if SSRS encryption key bac...
    • Local #dax measures in #powerbi reports are not vi...
    • Help me with the SQL syntax
    • AVG Disk Transfer goes out of scale randomly
    • Column name assignment
    • Installed SS 2016, unable to find default instance...
    • Logshipping Shipping- Regular LOG BACKUP
    • Error on Backup
    • TDS Remoting: A Better Way to Create Linked Server...
    • solved - Row Level Security based on membership in...
    • SQLCMD Mode; Run all SQL files in a directory
    • Testing COALESCE with tSQLt
  • ►  July (690)
  • ►  June (234)