software recommendations

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Recommendations

Q&A for people seeking specific software recommendations

declare @http nvarchar  = N'http://'
declare @slash nvarchar = N'/'

select substring(
          comment
          , charindex(@http, comment) +7
          , charindex(@slash ,comment, 
               charindex(@http, comment) +7)-
                  (charindex(@http, comment) +7)
           ) as dest
      , count(*)
     
from posthistory
where posthistorytypeid = 36 -- here
group by substring(
          comment
          , charindex(@http, comment) +7
          , charindex(@slash ,comment, 
               charindex(@http, comment) +7)-
                  (charindex(@http, comment) +7)
           ) 
order by count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results