No announcements
Found 1789519 threads
-
0 VotesSplit the column into rows.
If it is FN1 LN1 FN2 LN2...you can do something like DECLARE @lstr varchar(100); DECLARE @ix int; SET @lstr = 'fn1 ln1 fn2 ln2 fn3 ln3'; SET ...Answered | 4 Replies | 4853 Views | Created by Jeevan Dasari - Tuesday, December 14, 2010 2:42 AM | Last reply by Boyan Penev - Tuesday, December 14, 2010 4:58 AM
-
0 Votes
Split column into rows
I think that you can place your existing query (or any alternative that splits the strings) into Common Table Expression (CTE), then divide the ...Answered | 5 Replies | 1193 Views | Created by RonTech1 - Friday, July 24, 2020 12:04 PM | Last reply by Viorel_ - Friday, July 24, 2020 2:44 PM -
0 Votes
Table Splitting in Code First and the Problem with the Identity Column
An explaination from Rowan Miller I quoted as below: " If you are configuring a relationship that is required:required or optional:optional then Code ...Answered | 12 Replies | 5149 Views | Created by Morteza Manavi - Wednesday, May 11, 2011 3:48 PM | Last reply by Morteza Manavi - Saturday, May 28, 2011 5:33 PM -
0 Votes
Split String Into a Multi-Column Table
So that you can tell 1,A,Fruit was first in the string, 2,B,Veggie second etc.Answered | 3 Replies | 12068 Views | Created by Ryan0827 - Tuesday, July 19, 2011 7:46 PM | Last reply by Badii Gharbi - Tuesday, July 19, 2011 10:17 PM -
1 Votes
Audit Table | Row or Column Duplication
I guess one question is, do you mean Audit table or History table?Answered | 6 Replies | 3264 Views | Created by RajeshSql - Friday, June 1, 2012 12:37 PM | Last reply by Krishnakumar S - Friday, June 1, 2012 3:16 PM -
4 Votes
How to split 4 columns, one row into 2 columns, two rows?
This will get you there, too: DECLARE @foo TABLE (col1 int, col2 int, col3 int, col4 int) insert @foo values(1,2,3,4) insert @foo values(5,6,7,8) insert @foo ...Answered | 3 Replies | 915 Views | Created by ironryan77 - Friday, December 18, 2015 10:10 PM | Last reply by Ahsan Kabir - Sunday, December 20, 2015 4:59 AM -
0 Votes
Splitting the rows
0) BEGIN -- Find the first delimiter SET @index = CHARINDEX(@delimiter , @text) -- No delimiter left?Answered | 4 Replies | 4828 Views | Created by Kashif Chotu - Saturday, February 6, 2010 6:10 PM | Last reply by Plamen Ratchev - Sunday, February 7, 2010 3:42 AM -
0 Votes
XML conditional split into separte columns and insert into single SQL table
Hello Eileen, Yes I did use the XML source component first and then used that as an input for the conditional split.Answered | 4 Replies | 4520 Views | Created by Pankaj Behera - Thursday, April 19, 2012 11:42 PM | Last reply by Pankaj Behera - Friday, April 27, 2012 2:09 AM -
0 Votes
split columns in to rows
I have a tabel with 2 ...Answered | 1 Replies | 5273 Views | Created by Anu reddy - Tuesday, January 12, 2010 1:30 AM | Last reply by Abdshall - Tuesday, January 12, 2010 2:20 AM -
0 Votes
selecting table columns as table rows
Hi h2007, You can also use a SQL string split function instead of Pivot and Unpivot too.Answered | 5 Replies | 1087 Views | Created by h2007 - Wednesday, February 26, 2014 5:03 AM | Last reply by Visakh16 - Wednesday, February 26, 2014 7:09 AM -
0 Votes
rows to split
See this thread How to hide duplicate rows although I suggest against doing it in T-SQL.Answered | 5 Replies | 4191 Views | Created by coolguy123SQL - Thursday, December 2, 2010 4:18 PM | Last reply by Ai-hua Qiu - Tuesday, December 7, 2010 5:45 AM -
1 Votes
Split 1 column into multiple columns
The best approach is to NOT split them out into individual columns...Answered | 4 Replies | 1413 Views | Created by Royal Thomas - Tuesday, April 14, 2015 4:25 PM | Last reply by Jason A Long - Tuesday, April 14, 2015 11:21 PM -
1 Votes
Split values in the column
Hi SSRS-Newbie, Are your trying to split the row into 2 rows with corresponding SalesCode and Amount?Answered | 10 Replies | 1313 Views | Created by SSRS-Newbie - Thursday, October 15, 2015 8:06 PM | Last reply by Eric__Zhang - Monday, October 19, 2015 6:06 AM -
5 Votes
Split a column into multiple rows by multiple search strings
In other words you need to copy the query as is and then replace column name and table name only.Answered | 8 Replies | 7170 Views | Created by ahpitre - Monday, February 11, 2013 5:13 PM | Last reply by Jingyang Li - Tuesday, February 4, 2014 9:18 PM -
1 Votes
Adding row group in middle of the table, by default it is getting created as first column
well, i have been asking for row level toggling only like drilldown in the middle of the table. yeah example is misleading Pavan ...Answered | 9 Replies | 1021 Views | Created by Pavan12S - Tuesday, February 6, 2018 4:16 PM | Last reply by Visakh16 - Monday, February 12, 2018 1:33 PM -
3 Votes
Find first empty row in table?
Hello Robert, Please read this post: http://www.eggheadcafe.com/software/aspnet/35886615/find-first-empty-row-of-a-table.aspx.Answered | 2 Replies | 9152 Views | Created by Robert Crandal - Sunday, March 6, 2011 4:12 AM | Last reply by Graham Mayor - Sunday, March 6, 2011 3:23 PM -
0 Votes
first row from a table...
I just have this new issue at work and thinking how to get this issue resolved....i have got a table B linked to another table A(i renamed the tables for this forum to make ...Answered | 1 Replies | 6072 Views | Created by Sayed_Syd - Sunday, August 30, 2009 11:50 PM | Last reply by Justin Shen - Monday, August 31, 2009 1:49 AM -
0 Votes
Insert the values into a table from another table by Splitting the string column based on ';' as delimiter and write into separate rows
Try as select first (I haven't looked at Erland's site right now to find the name he is using in his functions, if you would use the function I posted the ...Answered | 20 Replies | 1869 Views | Created by SowmyaKNS - Monday, August 3, 2020 8:14 AM | Last reply by SowmyaKNS - Wednesday, August 5, 2020 9:36 AM -
0 Votes
Split multiple columns into rows using XML
Hi, Try like this , DECLARE @tmp TABLE (pk INT,Manufacturer NVARCHAR(50),partnumber NVARCHAR(50)) INSERT @tmp SELECT 1,'Man1; ...Answered | 3 Replies | 1354 Views | Created by Alex Vary - Friday, December 20, 2013 4:03 PM | Last reply by SathyanarrayananS - Friday, December 20, 2013 5:34 PM -
2 Votes
How to split table horizontally in SSRS depending on condition?
Hi MadhuriR, You can use two tables do display the data, and then set the visibility for the row of each table.Answered | 2 Replies | 5676 Views | Created by MadhuriR - Thursday, September 6, 2012 9:13 AM | Last reply by Syed Qazafi Anjum - Friday, September 7, 2012 2:32 AM - Items 1 to 20 of 1789519 Next ›
No announcements
