SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How to reset the count to 0
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tsaliki
Starting Member

India
19 Posts

Posted - 01/09/2014 :  03:14:10  Show Profile  Reply with Quote
I have a table with records as follows: Its just a sample table for understanding the scenario.


Create table resetcount
(
userid int,
totalhighprtjobs int,
[date] datetime
)


insert into resetcount Values (147,0,GETDATE())
insert into resetcount Values (169,1,GETDATE())
insert into resetcount Values (176,0,GETDATE())
insert into resetcount Values (187,1,GETDATE())
insert into resetcount Values (188,1,GETDATE())




Everytime when i assign a job to a userid the totalhighprtjobs gets increased by 1.it will assign to all the users randomly and equally. Suppose if all the count of totalhighprtjpbs becomes 1 then i want to reset all those to 0.if suppose today there are 3 jobs assigned to useids 169,187,188.tomorrow while assigning jobs since the count of highprtjobs of userid 147 and 176 are 0 first these two will be assigned a job.After assigning to these two the count ot totalhighprtjobs wil be 1 for all,then i want to reset the count to 0 for all after assigning to those two.


Can you guide me in this ..

nagino
Yak Posting Veteran

Japan
65 Posts

Posted - 01/09/2014 :  04:31:34  Show Profile  Reply with Quote
do you mean that execute the following after assigning?

-----------------------------------------

--if all records are assigned, reset.
UPDATE resetcount
SET totalhighprtjobs = 0
WHERE NOT EXISTS(
SELECT *
FROM resetcount
WHERE totalhighprtjobs = 0)


From Japan
Sorry, my English ability is limited.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 01/09/2014 :  05:01:48  Show Profile  Reply with Quote
sounds like a simple update to me

update resetcount
set totalhighprtjobs = 0
where totalhighprtjobs > 1
and date < GETDATE()


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000