Show Records Not In Another Table – Concatenated

Posted on By David Kittell 
SELECT col1
	,col2
FROM table1
WHERE (col1 + ' ' + col2) NOT IN (
		SELECT (col1 + ' ' + col2)
		FROM table2
		)
Originally Posted on September 24, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

WordPress – List All Plugins

Posted on

Place the following code on a file ex. ListAllPlugins.php and then navigate to http://yourdomain.com/ListAllPlugins.php <?PHP require($_SERVER[’DOCUMENT_ROOT’] . "/wp-load.php"); require($_SERVER[’DOCUMENT_ROOT’] . "/wp-admin/includes/plugin.php"); function PrintPluginList($option) { $all_plugins = get_plugins(); if ($option == 1) { print_r(array_values($all_plugins)); } else { echo json_encode($all_plugins); } } PrintPluginList($_GET[’op’]); ?> This is a PowerShell script to automate some…

Read More

PowerShell – Add Windows Feature IIS Site Management

Posted on

If you are on a freshly installed Windows server and can’t find IIS Site Mangement try this script below. get-windowsfeature|where{$_.name -eq "BITS-IIS-Ext"}|add-windowsfeature get-windowsfeature|where{$_.name -eq "Web-Scripting-Tools"}|add-windowsfeature All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system…

Read More

Proxy Switch

Posted on

Recently had a need to be able to switch on/off proxy at will and got tired of going to Internet Explorer options to set/change it. Hopefully someone else will get benefit from this nice tool. Open Visual Studio File -> New Project -> Visual C# – Windows -> Windows Forms…

Read More