No announcements
Found 3501647 threads
-
1 VotesGet Values from a concatenated String
Hi Tiago, If you want to custom expression on report design itself then you can opt this expression to have the desired output till with whatever ...Answered | 2 Replies | 1990 Views | Created by Tiago_Costa17 - Thursday, October 11, 2012 7:59 AM | Last reply by Arun Gangumalla (MCP) - Thursday, October 11, 2012 10:37 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 | 2242 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
Try: -- This is to simulate your table declare @t table ([Name] varchar(10), [Group] varchar(20), TG varchar(100)) insert into @t select ...Answered | 6 Replies | 2601 Views | Created by Nadim2522 - Sunday, April 15, 2012 11:01 AM | Last reply by Erland Sommarskog - Sunday, April 15, 2012 5:13 PM -
0 Votes
Split String Value
Okay, well the code you use is going to depend on what you need to do dynamically -- what you expect the values to be and what you need to get out of them (numbers vs text, length, ...Answered | 4 Replies | 3230 Views | Created by prathap2 - Friday, April 11, 2008 11:54 AM | Last reply by Jaystation - Monday, April 14, 2008 2:30 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 | 2168 Views | Created by MoThA999 - Tuesday, October 2, 2018 6:19 AM | Last reply by Jingyang Li - Tuesday, October 2, 2018 2:22 PM -
1 Votes
Split values in the column
34.50') ; SELECT * FROM @TEST_DATA SELECT DT_ID,InvNo,LEFT(SalesCode,CHARINDEX('!'Answered | 10 Replies | 1592 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
split my values and to insert...
use the split function from http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?Answered | 7 Replies | 4164 Views | Created by Karan2vel - Tuesday, June 15, 2010 9:39 AM | Last reply by KJian_ - Monday, June 21, 2010 1:24 PM -
14 Votes
How to split string value into multiple cols ?
http://www.sommarskog.se/arrays-in-sql-2005.html For 2016 or greater use SPLIT_STRING() function.Answered | 5 Replies | 931 Views | Created by Samantha v - Wednesday, October 4, 2017 11:25 AM | Last reply by Bhadresh Vasani - Wednesday, October 4, 2017 1:00 PM -
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 | 2691 Views | Created by deepak_cool - Wednesday, August 7, 2013 12:21 AM | Last reply by pituach - Saturday, September 27, 2014 7:53 AM -
1 Votes
How to split the string value into multi-columns?
You could split the string and return a table where each element in the list will be a row, then you can dynamically pivot the rows.Answered | 1 Replies | 6366 Views | Created by Anonymous9153 - Saturday, March 28, 2009 4:05 PM | Last reply by Hunchback - Saturday, March 28, 2009 4:45 PM -
0 Votes
Splitting values dynamically in SQL
Next time you want to split the data, you just need to call this function.Answered | 10 Replies | 923 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
get numeric and cahracter value from string
Is your whole column value?Answered | 5 Replies | 2009 Views | Created by BI_Support - Friday, June 21, 2013 6:25 AM | Last reply by BI_Support - Monday, June 24, 2013 9:50 AM -
2 Votes
Getting string values from a website.
Can you tell me how to extract the individual values only?Answered | 3 Replies | 2778 Views | Created by kesk - Monday, October 20, 2008 7:07 PM | Last reply by Dave A Gordon - Wednesday, October 22, 2008 12:11 PM -
0 Votes
passing connections string string to sp and split the values
select @UserID = [Value] from #ParsedResults where Attribute = 'user id' select @Password = [Value] from #ParsedResults where ...Answered | 6 Replies | 4238 Views | Created by Anand Rajagopal - Monday, June 20, 2011 2:43 PM | Last reply by Naomi N - Tuesday, June 21, 2011 2:52 PM -
0 Votes
split comma seperated values and get results from another table
,'int') as RSSFeedID from (select CONVERT(XML,'<i>'+REPLACE(@CustomFeeds,',','</i><i>')+'</i>') as d)x1 cross apply d.nodes('i') as ...Answered | 5 Replies | 4938 Views | Created by dathy - Tuesday, February 22, 2011 8:47 PM | Last reply by Rishabh K - Wednesday, February 23, 2011 3:39 AM -
8 Votes
Splitting a string to get valid data
Regex is your friend, by setting up a pattern and extracting the matches and their values one can do multitude of things with textual data.Answered | 5 Replies | 3258 Views | Created by Amare1982 - Monday, May 4, 2009 2:38 PM | Last reply by OmegaMan - Monday, May 4, 2009 2:54 PM -
2 Votes
Getting value from HTML String
string pattern = @"(?Answered | 3 Replies | 5036 Views | Created by jgnguyen - Monday, June 14, 2010 2:04 PM | Last reply by Kirill Polishchuk - Tuesday, June 15, 2010 3:36 AM -
1 Votes
Select values in List box from a cell value
Dim rngC As Range Private Sub CommandButton1_Click() 'load the values Dim v As Variant Dim i As Integer Dim j As Integer ...Answered | 2 Replies | 1981 Views | Created by SumitKumarDua - Monday, March 25, 2013 2:03 PM | Last reply by SumitKumarDua - Tuesday, March 26, 2013 9:31 AM -
0 Votes
how to split string values and bind to dropdownlist
My Question is how to Split string .Answered | 3 Replies | 2156 Views | Created by ps41 - Tuesday, April 8, 2014 10:39 AM | Last reply by Tomasz von Oertzen - Tuesday, April 8, 2014 7:48 PM -
0 Votes
Getting the selected value from an autocompletebox
Instead of trying to get the value from the ACB control itself, you should be getting it from the bound property instead.Answered | 2 Replies | 2681 Views | Created by Dan Margolis - Saturday, November 26, 2011 7:34 PM | Last reply by Dan Margolis - Sunday, November 27, 2011 2:03 PM - Items 1 to 20 of 3501647 Next ›
No announcements
