alien (alien)

	 
     

	WITH CteSum as 
	(
	 select   SUM ([reward_amount]  )  SumOfRewards , [reward_account_num] , [reward_routingNumber],[reward_dest_account_num]      FROM 
     [dbo].[tbl_Reward_Transactions]
	    WHERE  
		
        MONTH( reward_date ) = MONTH(  @date  )
		AND 
        YEAR ( reward_date ) = YEAR (  @date  )


      group by  [reward_account_num] ,  [reward_routingNumber] ,[reward_dest_account_num]  
	 )

	 SELECT SumOfRewards ,  [reward_routingNumber],[reward_dest_account_num] , AccountHolderName   FROM CTESUM  cte INNER JOIN [dbo].[Accounts]  A 
	 ON A.account_number = cte.[reward_account_num] 

	 WHERE A.account_number = @AccountNumber        

https://www.paypalobjects.com/en_US/vhelp/paypalmanager_help/credit_card_numbers.htm

  <Button guid="guidToolWindow1PackageCmdSet" id="ToolWindow1CommandId" priority="0x0100" type="Button">
    <Parent guid="guidSHLMainMenu" id="IDG_VS_TOOLS_OTHER2"/>
    <Icon guid="guidImages" id="bmpPic1" />
    <Strings>
      <ButtonText>ToolWindow1</ButtonText>
    </Strings>
  </Button>
</Buttons>// Enter here the actual content of the snippet.            

if (this.view.Selection.SelectedSpans.Count > 0)

           {
               System.Diagnostics.Debug.WriteLine(this.view.Selection.SelectedSpans[0].GetText());

               //System.Diagnostics.Debug.WriteLine(this.view.Selection.StreamSelectionSpan.GetText());
           }// Enter here the actual content of the snippet.            

Admin   

MCSroot03