Viewing 15 posts - 1 through 15 (of 15 total)
I want to find the top 100 1st words and 2nd second words in a cell in a column
May 11, 2023 at 9:24 am
Msg 8144, Level 16, State 3, Line 38
Procedure or function string_split has too many arguments specified.
Completion time: 2023-05-08T16:53:02.0901322+05:30
May 8, 2023 at 11:23 am
Msg 8144, Level 16, State 3, Line 37
Procedure or function string_split has too many arguments specified.
Completion time: 2023-05-08T15:45:39.2855074+05:30
May 8, 2023 at 10:16 am
This was the error message
Msg 208, Level 16, State 1, Line 14
Invalid object name 'dbo.DelimitedSplit8K'
May 4, 2023 at 10:24 am
This is the error message I had got
Msg 8144, Level 16, State 3, Line 17
Procedure or function STRING_SPLIT has too many arguments specified.
Completion time: 2023-05-03T21:27:20.2644947+05:30
May 3, 2023 at 4:01 pm
May 3, 2023 at 12:59 pm
May 3, 2023 at 12:58 pm
This is my SQL Query to get the single words. I need two words grouping
SELECT value AS keyword, COUNT(*) AS keyword_count
FROM (
SELECT value
FROM [title_one_space]
CROSS APPLY STRING_SPLIT([title], ' ')
) keywords
GROUP BY...
May 3, 2023 at 12:55 pm
This was the error message
Msg 8144, Level 16, State 3, Line 12
Procedure or function string_split has too many arguments specified.
Completion time: 2023-03-24T13:47:00.0877172+05:30
March 24, 2023 at 8:17 am
I get wrong result for the above code.
March 23, 2023 at 6:40 pm
Its not executing it. I have attached the separate table.
I want to match from TableB
March 16, 2023 at 1:28 pm
SUBSTRING(comp, 0, CHARINDEX(' ', comp, CHARINDEX(' ', comp, 0)+1))
This query not returning exactly how I was lookin for it
March 10, 2023 at 2:23 pm
I want to extract first two words from the string. Example
ABC Property Management Inc.
I need to retrieve ABC Property
Even this case also
Brinker Inc
I need to retrieve Brinker Inc
March 10, 2023 at 1:47 pm
reduce the length to
The numbers should begin with 11.
The minimum length of the number should be 10
The maximum length of the number should be 15
Need to generate the random unique...
March 2, 2023 at 6:47 pm
Viewing 15 posts - 1 through 15 (of 15 total)