Here is the query to insert the data in table.

-- Step 1: Create the table

CREATE TABLE sat_temp (

Domain NVARCHAR(255),

[Required Result] INT

);

-- Step 2: Insert the data

INSERT INTO sat_temp (Domain, [Required...

• This reply was modified 4 months, 3 weeks ago by  sathishkm.

I want to find the top 100 1st words and 2nd second words in a cell in a column

100 results

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

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

This was the error message

Msg 208, Level 16, State 1, Line 14

Invalid object name 'dbo.DelimitedSplit8K'

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

Need the result like this

This is the column

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...

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

I get wrong result for the above code.

Its not executing it. I have attached the separate table.

I want to match from TableB

SUBSTRING(comp, 0, CHARINDEX(' ', comp, CHARINDEX(' ', comp, 0)+1))

This query not returning exactly how I was lookin for it

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