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