alien
alien
Reputation Top 1%
alien
8 Snippets  (115th place)
Published
1 Channel
Created
4 Channels
Following
175 points  (174th 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  1861  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  1859  0  3  0

test card numbers

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

public by alien  2375  0  3  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  1647  0  3  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  2345  0  3  0

this is for pd

Admin   

MCSroot03                
;