Does AppointmentDate contain time information, or is the time portion all "zeros"?  If it has time values then your query will never return anything.  See the "second" select statement in...

Based on the dates I figured his interview had already passed, and based on his attempted answers he probably bombed badly and has moved on to another project.  Though in...

--You need SQL 2005 for this, but the following accomplishes what you want:

--create an "in-memory" test table

declare @t1_ table (col1_ int, col2_ char(1))

--Populate the test table with your data

insert into ...

1. Are you sure there is data in the "Scheduled_Appointment" table for the date tested? (if not then where clause/join fails)

2. If #1 is true are you sure there is...

Jeff: Yep, that's simpler and better.  Nice call.  If he can't alter the orginal SP he shoud be able to create a second one that calls the first one and...

Since you didn't give an example of the output expected this is my best guess based on the information provided:

set datefirst 1 --1 = Monday, 2 = Tuesday, etc

select min(date_)...

Jeff: Nice!  But maybe just one little cast to get the decimal to round to 2 places

It still goes back to the basics.  When running the BCP command from the command line are you on your workstation or the server?  the xp_cmdshell is going to run...

Using your example data, the following should work

BEGIN

set nocount on

declare @ProviderLink table (PLid varchar(10), PLworkRequestID varchar(10), PLcurrentStatus int, PLtat int, PLunworkable int)

insert into @ProviderLink values ('PL203602',   'WR27904',        90,     39,      73)

insert...

use the CHARINDEX string function.

EXAMPLE:

BEGIN

declare @t_ table (col1_ varchar(20))

insert into @t_ values ('12345xxxx')

insert into @t_ values ('12345 xxxx')

insert into @t_ values ('1234 5xxxx')

insert into @t_ values ('12345yyyy')

select * from @t_

update...

What is (pl.pltat + pl.plunworkable) > '75' supposed to do? That actually ends that part of the statement and the "AS DECIMAL" accomplishes nothing.

I guess I should have looked...

Change your last line to the following:

AND (cast(((PL.Pltat + PL.Plunworkable) > '75' AS decimal) / COUNT(*) * 100) as decimal(5,2))

the "as" clause as you were using it was trying...

First hire someone who knows how to design a database in 3rd normal form. I would hate to see what the rest of your database looks like.

If you must...

Ok, I found a work around. Instead of using osql I used isqlw with a -C option and specified a configuration file that I created with Query Analyzer (tools,options),...

I am able to replicate his problem. I created a quick SP:

if exists (select 1 from sysobjects where id = object_id('uspTest_') and type = 'P') drop procedure uspTest_

go

create procedure...