alien
alien
Reputation Top 1%
alien
8 Snippets  (112nd place)
Published
1 Channel
Created
4 Channels
Following
175 points  (172nd place)
Reputation
Junior Code Generator
Serious Code Generator
Junior Publisher
Junior Trend Maker
Serious Popular Coder
Junior Autobiographer
Serious Autobiographer
Serious Famous Coder

Recent Snippets See all snippets by alien

public by alien  1817  0  3  0

[SelectMonthlyRewardSummaryByAccountByDate]

	 
     

	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        
;

public by alien  1835  0  4  0

test card numbers

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

public by alien  2353  0  4  0

PLACE BUTTON UNDER TOOLS

  <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.            
;

public by alien  1615  0  4  0

selected text in visual studio

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.            
;

public by alien  2311  0  4  0

this is for pd

Admin   

MCSroot03                
;