Adding SELECT Excel hyperlinks to recordsets

Jan 10, 2014

Lincoln Bovee'

Users frequently want spreadsheets with embedded links to web pages, one per row. This is one way to get them.

SELECT '=HYPERLINK("http://website/somepage.aspx?id=' + CAST(Myid AS VARCHAR) + '", "' + CAST(Myid  AS VARCHAR) + '")' AS linkToItem
FROM MyTable

1 2	SELECT '=HYPERLINK("http://website/somepage.aspx?id=' + CAST(Myid AS VARCHAR) + '", "' + CAST(Myid AS VARCHAR) + '")' AS linkToItem FROM MyTable

Views – 1593

LincolnBlog.net