USP_DATALIST_PROSPECTRESEARCH_LINKTANK
Link tank information for the Navigation tree in the shell.
Definition
Copy
create procedure dbo.USP_DATALIST_PROSPECTRESEARCH_LINKTANK
as
set nocount on;
select
'Corporate sources' as CAPTION,
'RES:web' as IMAGEKEY,
null as URL,
convert(xml,'<NODES>
<NODE>
<CAPTION>MarketWatch</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=1</URL>
</NODE>
<NODE>
<CAPTION>Hoover''s Online</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=2</URL>
</NODE>
<NODE>
<CAPTION>SEC Info</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=3</URL>
</NODE>
</NODES>') as NODES
union all
select
'Financial dictionaries' as CAPTION,
'RES:web' as IMAGEKEY,
null as URL,
convert(xml,'<NODES>
<NODE>
<CAPTION>Investopedia</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=4</URL>
</NODE>
<NODE>
<CAPTION>InvestorWords</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=5</URL>
</NODE>
</NODES>')
union all
select
'Foundations' as CAPTION,
'RES:web' as IMAGEKEY,
null as URL,
convert(xml,'<NODES>
<NODE>
<CAPTION>Guidestar</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=6</URL>
</NODE>
<NODE>
<CAPTION>The Foundation Center</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=7</URL>
</NODE>
</NODES>')
union all
select
'Professional directories' as CAPTION,
'RES:web' as IMAGEKEY,
null as URL,
convert(xml,'<NODES>
<NODE>
<CAPTION>AMA Physician Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=8</URL>
</NODE>
<NODE>
<CAPTION>Martindale-Hubbell</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=9</URL>
</NODE>
<NODE>
<CAPTION>Ziggs</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=10</URL>
</NODE>
<NODE>
<CAPTION>ZoomInfo Company Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=11</URL>
</NODE>
</NODES>')
union all
select
'Public records' as CAPTION,
'RES:web' as IMAGEKEY,
null as URL,
convert(xml,'<NODES>
<NODE>
<CAPTION>Campaign Finance Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=12</URL>
</NODE>
<NODE>
<CAPTION>Corcoran</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=13</URL>
</NODE>
<NODE>
<CAPTION>KnowX</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=14</URL>
</NODE>
<NODE>
<CAPTION>Search Systems</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=15</URL>
</NODE>
<NODE>
<CAPTION>Tax Assessor Database</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=16</URL>
</NODE>
<NODE>
<CAPTION>Yahoo Real Estate</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=17</URL>
</NODE>
</NODES>')
union all
select
'Reference' as CAPTION,
'RES:web' as IMAGEKEY,
null as URL,
convert(xml,'<NODES>
<NODE>
<CAPTION>APRA</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=18</URL>
</NODE>
<NODE>
<CAPTION>Infospace</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=19</URL>
</NODE>
<NODE>
<CAPTION>IRS Wealth and Gift</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=20</URL>
</NODE>
<NODE>
<CAPTION>Jay Computer Services</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=21</URL>
</NODE>
<NODE>
<CAPTION>PRSPCT-L Prospect Research ListServ</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=22</URL>
</NODE>
<NODE>
<CAPTION>United States Postal Service</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=23</URL>
</NODE>
<!--<NODE>
<CAPTION>Google Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=24</URL>
</NODE>-->
<!--<NODE>
<CAPTION>Hoover''s Free Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=25</URL>
</NODE>-->
<!--<NODE>
<CAPTION>Zoominfo People Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=26</URL>
</NODE>-->
<!--<NODE>
<CAPTION>Yahoo Finance</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=27</URL>
</NODE>-->
<!--<NODE>
<CAPTION>Salary Wizard</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=28</URL>
</NODE>-->
<!--<NODE>
<CAPTION>Moneyline Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=29</URL>
</NODE>-->
<!--<NODE>
<CAPTION>Foundation Finder</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=30</URL>
</NODE>-->
<!--<NODE>
<CAPTION>Zillow.com Home Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=31</URL>
</NODE>-->
<!--<NODE>
<CAPTION>SEC Info Search</CAPTION>
<URL>http://linktank.blackbaud.com/linktank.aspx?linktankid=32</URL>
</NODE>-->
</NODES>')
union all
select
'Wealth indicators' as CAPTION,
'RES:web' as IMAGEKEY,
null as URL,
convert(xml,'<NODES>
<NODE>
<CAPTION>Landings</CAPTION>
<URL>http://www.landings.com/_landings/pages/search/search_nnr-owners.htm</URL>
</NODE>
<NODE>
<CAPTION>Salary.com</CAPTION>
<URL>http://www.salary.com/</URL>
</NODE>
</NODES>')