All Questions
Tagged with string-splitting sql-server-2016
5 questions
3
votes
1
answer
135
views
Temp tables streamline query
I am trying to get to the Customer table from data in the SiteConfiguration table.
I am getting the data and setting it to @AdditionalVoteViewers, which would be a string of emails address. I then ...
- 79
-3
votes
1
answer
848
views
I want to split the text in the row into separate columns
I have this column and rows
I want to split the text in the row into separate columns like this.
1
vote
2
answers
4k
views
Splitting a column on underscores [duplicate]
What SQL syntax would split this column into three new columns (split would be on the underscore)?
There are other columns in the table, but I would like to split these into three (underscore based).
1
vote
1
answer
9k
views
SQL Split Address Line into Separate Columns
Whats the best way to split a comma list column into different columns? I am looking for a simple algorithm, heard it is best to avoid scalar value functions, as they might be slow. Searching into ...
user172734
0
votes
1
answer
2k
views
why my split string functions are not working with large OBJECT_DEFINITION?
I have in one of my databases a stored procedure
called PROCEDURE [repl].[usp_upd_repl_out_application], that is not exactly a very clever stored procedure but it has over 389 lines.
As I need to ...
- 16.6k