" I can tell consistently when the parameter dropdown list will have values and when it will not have values."

how? psychic powers?

Could it be a timeout?

Watch Kendra Little's video[/url]...

See #6. and the video that goes with it.

She and Brent Ozar know more about SQL Server than I probably ever will. And they know what they're...

Exercise your Google-fu. Found a bunch of hits in less than a second.

sys.dm_os_volume_stats - see example A.

An example from SQLMag...

Sounds like you might need a report or something that...

Olaf,

I got it to work, sort of. (Well, in my bar graph.)

I created a simple bar graph with (Date, Value), so the x-axis represents dates. If you right-click on a...

Nice solution, but where did OrderDate go?

I did the query in 2012 (Yes, I did read that you were using 2008... solution to follow) This was the SQL statement - super easy once Windowing functions...

Maybe start here:

https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/

Since this is a guessing game without the CREATE TABLE and INSERT scripts and the expected results, please provide them. I'm just not a fan of pin the tail...

Can't remember if this works in 2008. I think it works in R2

WITH SampleData (PERSON,TRANSACTDATE, STARTDATE, END_DATE, IN_PUNCH,OUT_PUNCH,HOURS) AS

(

SELECT 1234,'08/03/2015','08/03/2015','08/03/2015', '06:00','09:00','3' ...

Welcome to SSC...

For a first timer, pretty good post. Two things that would help us to help you are:

1. CREATE TABLE scripts

2. INSERT scripts to populate the table(s)

so...

MM,

Any idea why the parameters button would be grayed out? I'm using Integrated Security, and the SQL Instance is on my local PC.

So I can't specify a parameter as (?).

(Oh,...

Please include the description of the problem in the body of the message. Putting it in the title makes it hard to read.

Read this article[/url] - it explains how...

Snce you're new here, here's how to post your data so that people here can help. Here's your data...

use tempdb;

GO

CREATE TABLE Data (

ID INT NOT NULL,

JoiningDate DATE,

Placement CHAR(1),

pID INT,

cID...

What version of SQL Server are you using? If you have 2012 or later then you can use Windowing functions.

For the benefit of those trying to help, here are the...

Maybe start here:

http://stackoverflow.com/questions/10577676/how-to-obtain-failed-jobs-from-sql-server-agent-through-script

then incorporate it.