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.

Read this[/url].

One option is to modify the Connection properties that are being used to execute the stored procedure.

I'm assuming you're using Excel 2013... if not, I don't know - haven't used...

Install a version of SQL Server. SSMS should be included. You can download the databases from here[/url]

Then you just move the databases to the DATA folder and then attach...