Thank You George. When I ran it across actual table, I get error:

Msg 9421, Level 16, State 1, Line 1
XML parsing: line 1, character 30, illegal name...

thanks Steve. i opened "The New Splitter Functions.zip" and ran CREATE FUNCTION [dbo].[DelimitedSplit8K]  all the way...

Thanks Erik / Steve,

I used your query from and it definitely worked in temp table, but when i replaced values in actual table, i got

Error: Invalid...

ok this is what i came up with:

;with [my cte test] ([Address]) AS
(SELECT [Address]
FROM [dbo].[test_parse_brand_from_url]
where
CHARINDEX('a_brand_t_fq:"',U.,1) + 14 AS PAT_START
,CHARINDEX('"',U.,CHARINDEX('a_brand_t_fq:"',U.,1) +...

noob on sql. no idea on cte. can you perhaps shed more info or perhaps put those values in sql query? also not sure what the original error in temp...

Thanks Eirikur Eiriksson. I should have said this is sample...

Thanks HanShi.

This is the error from the error log:

2018-02-26 22:35:15.77 Server  The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/MY-PC:50925...

Hello,

The problem has re-occurred. I've uninstalled AntiVirus program, and disabled Windows Firewall, restarted SSMS but getting error:

A network-related or instance-specific error occurred while establishing a connection...

Thanks Steve - Helpful

Sorry my mistake. You're right. Oversight. Thanks for explanation and help!

Appreciated.

Thanks Thom.

I tried:
ALTER TABLE #test_table ADD [Page] AS CONVERT(int,((CP - 1) / 10) + 1);

however, the values for coulmn [page] in the highlighted attachment...

Thanks Thom.

I tried
select convert([date] VARCHAR(10), GETDATE([date])
from #test_table
where [Date] >='2016-12-01' and [Date] <'2017-02-10'

getting invalid syntax near varchar.

Also how can I...

Do you mean?
like below:

select convert([date] VARCHAR(10), GETDATE(), 101)
from #test_table
where [Date] >='2016-12-01' and [Date] <'2017-02-10'

Ok got it. thanks for the tip.

select *
from #test_table
where [Date] >='2016-12-01' and [Date] <'2017-02-10'

How can I get the actual result to just...

Hi Erik,

Here's what I tried:

select *
from #test_table
where [Date] between '2016-12%' and '2017-02%'