Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
String between two indexes
-- Query to remove the string between two indexes of delimiters DECLARE @NameString VARCHAR(MAX) = 'Suman,Saurav,Rajeev,Chandra,Mizan,Ahmed', @StartIndex INT = 0, @EndIndex INT = 21 SELECT STUFF(@NameString, CHARINDEX(',', @NameString, @StartIndex), CHARINDEX(',', @NameString, @EndIndex) - CHARINDEX(',', @NameString, @StartIndex), '')
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
PIVOT AND UNPIVOT USING XML PARSING
top 3 salaries from each dept
megha
table emp
Dynamic substring in SQL
Running Total
Student
TRANHOANGLONG
Dividing runs by time stamp
reee
Please log in to post a comment.