Em Andamento

Appointments/Scheduling Queries and Stored Proceedures

Building a scheduling component for an application. So need some queries and stored procedures for SQL Server 2008 R2. The specs attached is for the first phase of this series. If work is well done, expect more to follow to build on it. Project is dynamic in nature, so tablenames and columns names are stores in settings table where the can be retrieved based on ID.

would like to check Resource Availability given a ServiceID as well as given desired start and end time, determine if resources are available or already in use.

SP1

Given

ServiceIDs = 2,3

RequestedStartDateTime

RequestedEndDateTime

Resource_Selection_Rule (optional): ‘EmployeesID = 10 and VehicleID = 101’

Return: True or False

SP2: Resource Availability

Given

ResourceID

RequestedStartDateTime

RequestedEndDateTime

Return: True or False

SP workings:

1. Check General Availability

2. Check service Availability

3. Using Service ID, Check each resource general availability using table s_ServiceResourcesAvailability (eg vehicles only available in afternoons on MWF)

4. Using SeviceID’s (e.g. Consultation), determine the required Resources by looking up table s_Service_to_Resource. It might be just one service needing one or more resource, or Multiple services needing one or more resource.

5. Using the resource (e.g. employee) columnID, we check availability. In checking availability, we check content of columns FromColumnID and ToColumnID for each resource. Can use sp_getrelatedvalue to achieve.

I attached some screen shots with tables

Last page would be of specs would be done in a very similar way to existing SP that I would provide.

Habilidades: SQL

Veja mais: stored, stored procedures, scheduling, queries, Project Scheduling , Appointments, appointments s, building project sql, table queries, queries sql, project sp1, sql server scheduling application, SQL Server Stored Procedures, sql appointments, sql appointments tables, sql multiple tables, employee time sql, time table scheduling, time table component, tables stored sql

Acerca do Empregador:
( 126 comentários ) Some City, United States

ID do Projeto: #4218394

Concedido a:

HenrichCristian

Hi. Please consider my bid, as discussed

$30 USD em 10 dias
(3 Comentários)
2.5

6 freelancers estão ofertando em média $178 nesse trabalho

sthakral

Hi, Have a couple of questions, and my understanding of the scenario in PMB. Can you please check. Best, Sandeep

$220 USD in 4 dias
(5 Comentários)
4.3
shaz123

Hi ===YESS!! WE ARE EXPERT IN WEB DEVELOPING, HTML, XHTML, CSS, JAVASCRIPT, JQUERRY, PHP, SEO, ECOMMERCE, WORDPRESS, JOOMLA, AJAX, DRUPAL,MAGENT,O XML, ANDROID APP,IPAD APP,IPHONE APP. , WE LOVE TO DEVELOP AND DESIGN== Mais

$190 USD in 15 dias
(3 Comentários)
3.6
oobretenov

I could help you

$220 USD in 5 dias
(0 Comentários)
0.0
sunshinelabs

I'm free to work on this tonight (NY Time), and hopefully have it done for you tomorrow. I am American, live in NYC, have a BS and a day job; I need extra projects this month which is why I'm trying to find a few p Mais

$250 USD em 1 dia
(0 Comentários)
0.0
topshotsystems

I'd be happy to assist you with your SQL project. It appears the deliverables are 2 stored procedures for use in SQL Server.

$160 USD in 2 dias
(0 Comentários)
0.0