No announcements
Found 1613432 threads
-
0 VotesSplitting values dynamically in SQL
Next time you want to split the data, you just need to call this function.Answered | 10 Replies | 648 Views | Created by SyedF - Monday, July 10, 2017 5:36 PM | Last reply by Xi Jin - Tuesday, July 11, 2017 2:52 AM
-
0 Votes
Split coma separeted values in sql 2012
We never intended for SQL to be use this way.Answered | 5 Replies | 512 Views | Created by Bex111 - Friday, July 6, 2018 4:00 PM | Last reply by Bex111 - Monday, July 9, 2018 11:40 AM -
0 Votes
split my values and to insert...
can you help for that am using sql server 2000 Hi, As you are working with SQL Server 2000, we cannot use ...Answered | 7 Replies | 3954 Views | Created by Karan2vel - Tuesday, June 15, 2010 9:39 AM | Last reply by KJian_ - Monday, June 21, 2010 1:24 PM -
1 Votes
Split values in the column
DECLARE @TEST_DATA TABLE ( DT_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED , InvNo VARCHAR(10) NOT NULL , SalesCode ...Answered | 10 Replies | 1285 Views | Created by SSRS-Newbie - Thursday, October 15, 2015 8:06 PM | Last reply by Eric__Zhang - Monday, October 19, 2015 6:06 AM -
0 Votes
SQL 2012 String split
declare @Demo table (col1 varchar(100)); insert into @Demo (col1) values ('- Variable open or shorted - Variable electrical connection - Failed ...Answered | 2 Replies | 1366 Views | Created by Robbie3975 - Thursday, September 10, 2015 9:15 AM | Last reply by Uri Dimant - Thursday, September 10, 2015 9:37 AM -
0 Votes
Split the value into multiple values across the row
If you want to understand why you are more then welcome to check out the following link for ...Answered | 10 Replies | 2471 Views | Created by deepak_cool - Wednesday, August 7, 2013 12:21 AM | Last reply by pituach - Saturday, September 27, 2014 7:53 AM -
0 Votes
Split by ; in sql
declare @param2 varchar(1000) declare @param1 varchar(100) select @param1 = 'Test' select @param2 = '100;200;300' ;with ...Answered | 2 Replies | 4723 Views | Created by haroon2k8 - Tuesday, November 9, 2010 7:06 AM | Last reply by Nigel Rivett - Tuesday, November 9, 2010 11:25 AM -
0 Votes
How to split the string value
SELECT REPLACE('27-27-27','-',' ') However, I believe you mean something more along the lines of this.Answered | 2 Replies | 1975 Views | Created by Ranganathan Palanisamy - Tuesday, December 4, 2012 10:35 PM | Last reply by Peréz - Tuesday, December 4, 2012 10:45 PM -
0 Votes
Select - split delimited value
Erland Sommarskog, I take alook at http://www.sommarskog.se/arrays-in-sql-2005.html#tablelists but I didn't find a solution to my problem.Answered | 6 Replies | 2373 Views | Created by Nadim2522 - Sunday, April 15, 2012 11:01 AM | Last reply by Erland Sommarskog - Sunday, April 15, 2012 5:13 PM -
2 Votes
Split function to split the string in SQL
Alternatively, you can use a function that splits information.Answered | 6 Replies | 4598 Views | Created by nitin1309 - Tuesday, January 4, 2011 3:33 PM | Last reply by Naomi N - Tuesday, January 4, 2011 3:57 PM -
0 Votes
Splitting returned sql field.
Hi, you can use this split functin CREATE FUNCTION dbo.SplitStringXml ( @RowData NVARCHAR(MAX), @SplitOn NVARCHAR(5) ) ...Answered | 2 Replies | 640 Views | Created by cab806 - Thursday, August 27, 2015 11:59 AM | Last reply by Tomas Ludvik - Thursday, August 27, 2015 12:22 PM -
2 Votes
split a string using SQL
In addition to these useful links, try this : ALTER FUNCTION [dbo].Answered | 7 Replies | 51855 Views | Created by sdnd2000 - Sunday, August 18, 2013 8:30 AM | Last reply by Guillermo Ortiz Gonzalez - Friday, August 8, 2014 3:06 PM -
0 Votes
Split string (with variable number of value) into different columns
create table test ([Key] int , [Value] varchar(20)) insert into test values (1,'A,B,C'), (2,'A,B,C,D'), (3,'A,B,C,D,E') /*I know that there is at ...Answered | 3 Replies | 1762 Views | Created by MoThA999 - Tuesday, October 2, 2018 6:19 AM | Last reply by Jingyang Li - Tuesday, October 2, 2018 2:22 PM -
0 Votes
Sql servrer Page Splits
Page splits are bad and very expensive.Answered | 3 Replies | 1068 Views | Created by MSDN_12345 - Wednesday, November 27, 2013 1:30 PM | Last reply by Manu_vmr - Thursday, November 28, 2013 9:24 AM -
0 Votes
SQL-Split String
I added a TechNet article for this problem http://social.technet.microsoft.com/wiki/contents/articles/23449.t-sql-split-string-with-a-twist.aspx For every ...Answered | 8 Replies | 3139 Views | Created by eva05 - Tuesday, March 4, 2014 5:32 PM | Last reply by Leonardo Augusto Rezende Santos - Thursday, March 13, 2014 2:01 PM -
1 Votes
Split comma separated values into columns
NumAnswered | 8 Replies | 8396 Views | Created by Mr Mohamed Ismail - Sunday, March 24, 2013 8:53 PM | Last reply by SQLZealots - Wednesday, March 27, 2013 4:12 PM -
0 Votes
XSLT split an incoming delimited value
Hi, Please see the link http://seroter.wordpress.com/2008/10/07/splitting-delimited-values-in-biztalk-maps/, not exactly matching to your issue but quite ...Answered | 2 Replies | 7182 Views | Created by joacim37 - Wednesday, January 27, 2010 9:09 PM | Last reply by Tariq Majeed - Wednesday, January 27, 2010 9:49 PM -
1 Votes
Column split value by delimiters (automatic)
I need only the part, after having split by the ";", the text which is located on the right of the delimiters "=", and this for each lines which compose the ...Answered | 18 Replies | 1397 Views | Created by CalloudB - Wednesday, March 11, 2020 8:36 AM | Last reply by CalloudB - Wednesday, March 18, 2020 9:35 AM -
2 Votes
Split comma seperated values to multiple columns
Please refer the below link for the ...Answered | 5 Replies | 4309 Views | Created by nextwarren - Monday, July 29, 2013 12:09 PM | Last reply by Lorena Maria - Tuesday, July 30, 2013 7:48 AM -
0 Votes
Split comma separate value and then lookup ID
refer http://stackoverflow.com/questions/13159526/split-values-over-multiple-rows declare @table table(id int,stageIDs ...Answered | 2 Replies | 1888 Views | Created by Lezgettdrunk - Saturday, May 16, 2015 5:32 PM | Last reply by Stan210 - Saturday, May 16, 2015 8:26 PM - Items 1 to 20 of 1613432 Next ›
No announcements
