All Questions
Tagged with substring sql-server-2008
3 questions
0
votes
1
answer
69
views
SQL Server 2008 - Replacing csv substrings in view-row using data from other table
Using SQL server 2008, is there a way to perform SELECT query in a view replaces a row containing comma-separated values with their corresponding text value from another table? STRING_SPLIT and ...
- 20.3k
0
votes
2
answers
16k
views
Single query approach to split and copy string values in a column
This is a part of my previous question.
I have the below logic to split a string value from a column in table tblProjects as below:
SELECT @Docs = Documents FROM tblProjects WHERE ID = @ID
SET @...
CommunityBot
- 1
1
vote
2
answers
3k
views
How to pull number code from strings buried in parentheses?
I have string data (ProductDescription) that includes product names and ID numbers and need to pull the ID numbers for cross-referencing...
Data Samples:
Widget (1234)
Different Widget (123)
Many ...
- 22.2k