how to write queue with give table to maintain users based on location and shift?

Question

0.00/5 (No votes)

See more:

Queue Logic : FIFO ( Query should get a set of users from this table based on the date assign them to a week . Query should filtered by location in which the machine group is present. While assigning you have to check the validity if not valid ignore that user try the next user. The set of user that are updated will have updated date which is week start date in the queue table.

Tables
QueueTable (columns: Auditor, Location, Date)
machine(columns : machine_name,m_no,location)
group(columns:groupname,groupnumber,location ,shift)
weektable(today,weeek,week1,week2,week3)[week is current week,week1,is next to current week,week2 is next to week1,....soon]

help me to write queue or sugget me any other like procedure or service with reason

thanks in advance

Thanks&Regards
vamsi krishna

Posted 30-Apr-12 0:21am

jvamsikrishna

Add a Solution

Comments

jvamsikrishna 30-Apr-12 6:27am

Suggest me it is achivable in SP.

bbirajdar 30-Apr-12 6:43am

Yes. This is achievable in SP. Go for it..

jvamsikrishna 2-May-12 5:08am

Thank you for your suggestion

i had written that sp.

tirumalararao 30-Apr-12 7:11am

ok

Corporal Agarn 1-May-12 10:25am

Show what you have done so far

jvamsikrishna 2-May-12 2:12am

create procedure sp_schedule
as declare @qid int
declare @loc varchar(30)
begin TRANSACTION tran1
select top 1 @qid = q_id,@loc=location from QueueTable where
QueueTable.audit_date =(select top 1 audit_Date from queuetable order by audit_Date asc)
update queuetable set audit_date=GETDATE() where @qid=q_id and @loc=Location
commit tran1

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

jvamsikrishna · Accepted Answer · 2012-05-01T20:11:00

SQL

create procedure sp_schedule
as declare @qid int
declare @loc varchar(30)
begin TRANSACTION tran1
select top 1 @qid = q_id,@loc=location from QueueTable  where
QueueTable.audit_date =(select  top 1 audit_Date from queuetable order by audit_Date asc)
update queuetable set audit_date=GETDATE() where @qid=q_id and @loc=Location
commit tran1