Ergun Ozyurt ergunozyurt

I hereby claim:

To claim this, I am signing this object:

-MERGE ResultRssDatas as TARGET
-USING (select RssDataID as RssDataID, SYS_CHANGE_OPERATION as Operation  from changetable(changes RssDatas, 0) as ctt) as SOURCE
-ON TARGET.RssDataID = SOURCE.RssDataID
-WHEN MATCHED AND SOURCE.Operation = 'D' THEN
-delete
-WHEN MATCHED AND SOURCE.Operation = 'U' THEN
-delete;--will be changed

+MERGE ResultRssDatas as TARGET
+USING  (SELECT
+				RssDatas.RssDataID,
+				NewsChannelCategories.NewsChannelCategoryID,
+				NewsChannels.NewsChannelID,
+				NewsChannels.Name as NewsChannelName,
+				ChannelCategories.ChannelCategoryID,
+				NewsChannelCategories.CountryID,
+				NewsChannelCategories.LanguageID,

	function searchArrayForKey($search,$array) {
	$foundArray= array();
	foreach ($array as $key => $value) {
	if($key === $search)
	{
	$foundArray = $value;
	break;
	}
	else
	{

	# ---------------------------------------------------------------------------
	#
	# Description: This file holds all my BASH configurations and aliases
	#
	# Sections:
	# 1. Environment Configuration
	# 2. Make Terminal Better (remapping defaults and adding functionality)
	# 3. File and Folder Management
	# 4. Searching
	# 5. Process Management

	# set folder path
	$dump_path = "d:\temp"

	# set min age of files
	$max_days = "-1"

	# get the current date
	$curr_date = Get-Date

	# determine how far back we go based on current date