Click here to Skip to main content
12,401,324 members (34,943 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# SQL-Server
Hello all,


My requirement is, if one user is added 5 members , he will add 1 credit to his credit table. For this i am using memberconnection table in this table columns are
ID, RequieredMemberID, RecipientMemberID, Datecreated, StatusID. I want to find out members(RecipiencememberID's) count using Datecreated column.
Suppose example from todaydate to tommorrow evening i will get 5 members count i want to add 1 credit to another table. from tomorrow evening onwards suppose after
5days i will get 5 members count i want to add another 1 credit just like loop . How count no.of members(ReceipientMemberID).
How i will do this requirement using datecreated column in memberconnection . Please tell me any one.


Thanks
Posted 1-Apr-13 20:49pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

--write a procedure for the below code which takes startdate and enddate as parameter

Declare @startdate datetime;
Declare @enddate datetime;

declare @count int;

select @count=count(*) from memberconnection where Datecreated >=@startdate and Datecreated<=@enddate

if @count>=5
begin
---add credit
end
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160721.1 | Last Updated 2 Apr 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100