SQL Stored Procedure not giving correct results
I've been working on a stored procedure on my SQL server to basically do a few things:
1. Look at an oncall schedule for any given day.
2. See who is oncall for that day, and if there are more than one results for any schedule, present them back to me.
3. If no one is on call for that day, present a "No o/c listed" result back to me.
I can get the first two to work but not the last part. I have the SP and will post it if anyone would like to see it.
Without knowing what you tried that hasn't worked and the structure of the table that the information is being stored in that you are trying to retrieve it would be difficult to offer anything remotely constructive.
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
By Walter in forum Database
Last Post: 02-07-2006, 05:33 PM
By software_develo in forum Database
Last Post: 10-31-2005, 07:25 AM
By Mike in forum VB Classic
Last Post: 06-17-2002, 03:13 PM
By Gigi in forum Database
Last Post: 04-11-2001, 07:25 AM
By Devaraj in forum Enterprise
Last Post: 05-11-2000, 01:48 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL