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 creationdate
     , substring(
          comment
          , charindex(@http, comment) +7
          , charindex(@slash ,comment, 
               charindex(@http, comment) +7)-
                  (charindex(@http, comment) +7)
           ) as dest
     , text
     
from posthistory
where posthistorytypeid = 35 -- away

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results