No announcements
Found 1381178 threads
-
0 VotesSQL PIVOT Multiple Columns
Ok But in that case how I will get the updated rows from _DATA table in order to avoid duplicate and its not good to always select all rows and then PIVOT and then insert in ...Answered | 18 Replies | 1910 Views | Created by Tech Aspirant - Monday, November 26, 2018 12:44 PM | Last reply by Visakh16 - Tuesday, November 27, 2018 11:56 AM
-
0 Votes
How to create a Pivot table with a Column of Multiple rows?
Don't wory You can easily learn from this link http://balavardhanreddy.over-blog.com/categorie-11295031.html Now after creating ...Answered | 8 Replies | 13286 Views | Created by G Kiran Kumar - Monday, March 22, 2010 8:49 AM | Last reply by Shamas Saeed - Thursday, March 25, 2010 5:00 AM -
0 Votes
Sql Pivote in 2000 with multiple column
Take a look at my new blog post on this topic Dynamic PIVOT on multiple columns For every expert, there is an equal and opposite expert. - ...Answered | 7 Replies | 5728 Views | Created by Mujeeb85a - Wednesday, May 25, 2011 2:33 PM | Last reply by Naomi N - Sunday, May 29, 2011 5:18 PM -
0 Votes
Pivot with Multiple Columns
Take a look at this article T-SQL: Dynamic Pivot on Multiple Columns For every expert, there is an equal and opposite ...Answered | 6 Replies | 855 Views | Created by WebRelations - Tuesday, September 1, 2015 1:00 AM | Last reply by WebRelations - Tuesday, September 1, 2015 4:02 AM -
0 Votes
Multiple Rows to Multiple Columns
Using the pivot operator would be be an option, http://msdn.microsoft.com/en-us/library/ms177410.aspx .Answered | 3 Replies | 3993 Views | Created by NSG12 - Monday, March 29, 2010 3:19 PM | Last reply by NSG12 - Monday, March 29, 2010 3:25 PM -
0 Votes
Updating Multiple Rows And Multiple Columns
But you don't need multiple SET clauses, just separate the multiple columns with commas, eg Update [ScadaData] SET LastValue = CASE ...Answered | 4 Replies | 910 Views | Created by FordIT - Thursday, December 8, 2016 3:25 PM | Last reply by FordIT - Thursday, December 8, 2016 5:10 PM -
1 Votes
PIVOT on Multiple Columns
In the dynamic sql, the columns after SELECT are ordered so that the output can be as you expected.Answered | 7 Replies | 1223 Views | Created by 2012S4 - Thursday, January 22, 2015 8:04 PM | Last reply by Eric__Zhang - Tuesday, January 27, 2015 2:52 AM -
0 Votes
Multiple pivots resulting in null values for second pivoted column
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.seAnswered | 1 Replies | 5425 Views | Created by Webfriebd13 - Friday, May 13, 2011 9:53 AM | Last reply by Erland Sommarskog - Friday, May 13, 2011 10:18 AM -
1 Votes
How to convert multiple row into single row and multiple column in by sql querry...??
You can make use of PIVOT table.Answered | 4 Replies | 7331 Views | Created by Mordhwaj Chauhan - Friday, April 13, 2012 2:39 PM | Last reply by Virat Singh - Saturday, April 14, 2012 5:21 PM -
0 Votes
Execute Sql task (SSIS) with result set of multiple columns and multiple rows
Make sure that your query is returning only one row and the ResultSet property is set to Single ...Answered | 5 Replies | 17219 Views | Created by SSQLL - Monday, November 25, 2013 4:05 PM | Last reply by Jim Young (Level6 Productions) - Monday, November 25, 2013 5:03 PM -
0 Votes
pivot multiple columns
Pivot is shortcut for special kind of Select Case ...Answered | 4 Replies | 1885 Views | Created by babbupunia - Monday, January 30, 2012 5:30 PM | Last reply by SergNL - Monday, January 30, 2012 6:16 PM -
0 Votes
Need query to convert Single Row Multiple Columns To Multiple rows
CREATE TABLE dbo.T(ID INT,Column0 VARCHAR(99),Column1 VARCHAR(99),Column2 VARCHAR(99),Column3 VARCHAR(99),Column4 VARCHAR(99)) INSERT INTO T ...Answered | 4 Replies | 1325 Views | Created by ykMohan - Tuesday, April 21, 2015 6:45 AM | Last reply by Eric__Zhang - Tuesday, April 21, 2015 8:45 AM -
0 Votes
Derived Column Multiple rows...
As David mentioned, you need to use asynchronous transformations to process multiple rows together and redirect them to a destination for insert, this is sample of script component ...Answered | 3 Replies | 3844 Views | Created by RAGS1109 - Thursday, September 1, 2011 2:55 PM | Last reply by Reza Raad - Sunday, September 4, 2011 3:24 AM -
0 Votes
Pivot for multiple columns
Hi MUS, To achieve your requirement, also you can try PIVOT() function.Answered | 3 Replies | 747 Views | Created by mukejee - Monday, July 23, 2018 10:47 AM | Last reply by Xi Jin - Tuesday, July 24, 2018 2:41 AM -
1 Votes
Transpose (Pivot) columns to rows
I am digging into dynamic Unipivot with multiple columns.Answered | 10 Replies | 1620 Views | Created by HelalM - Saturday, August 15, 2015 1:57 PM | Last reply by Patrick Hurst - Monday, August 17, 2015 2:19 PM -
0 Votes
Convert Single Column of Data into Multiple Columns and Rows
You said this is written to a SQL table, is this in a single varchar(max) field in a single row or multiple rows?Answered | 19 Replies | 4094 Views | Created by DanHaf - Tuesday, January 19, 2016 3:13 PM | Last reply by Sam Zha - Wednesday, January 20, 2016 9:40 AM -
1 Votes
Convert Rows to columns using 'Pivot' in SQL Server
Tried multiple solutions but no luck yet.Answered | 29 Replies | 4058 Views | Created by Pratap09 - Monday, November 20, 2017 8:56 AM | Last reply by Suresh T G - Sunday, March 25, 2018 4:53 PM -
0 Votes
convert column into rows without using pivot
Hi there, Here's another article that presents several methods for concatenating row values into a single ...Answered | 18 Replies | 21908 Views | Created by uddu - Friday, March 19, 2010 2:27 AM | Last reply by José.Cruz - Friday, March 19, 2010 10:01 AM -
0 Votes
Pivot transform with multiple value columns
You will have to pivot both your value columns (see here for an example: http://www.bimonkey.com/2009/06/the-pivot-transformation/), so your output columns will ...Answered | 1 Replies | 4858 Views | Created by extelsql - Thursday, January 14, 2010 10:06 PM | Last reply by BI Monkey - Thursday, January 14, 2010 11:12 PM -
0 Votes
Pivoting of table for multiple columns
create table #t (cola int,colb char(1),colc int,cold int) insert into #t values (1,'x',12,13) insert into #t values ...Answered | 3 Replies | 2311 Views | Created by Amit Srivastava - Wednesday, May 30, 2012 10:54 AM | Last reply by Amit Srivastava - Tuesday, June 5, 2012 8:56 AM - Items 1 to 20 of 1381178 Next ›
No announcements
