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...

something like this?

SELECT jobnbr, tasknbr

FROM dataTable

EXCEPT

(SELECT d1.jobnbr, d1.tasknbr

FROM dataTable d1

WHERE d1.item_Type = 'TASK'

INTERSECT

SELECT d2.jobnbr, d2.tasknbr

FROM dataTable d2

WHERE d2.item_Type = 'HOLD');

(I may be missing the weekNbr, though...)

I have to...

One option might be to create two separate matrices with the same grouping and stack them.

got any dummy data for us to play with? (either create table and insert scripts...

How about...

SELECT EmpName, SwipeDate, Time_In, Time_Out, DATEDIFF(minute,Time_In,Time_Out) AS WorkTimeMins

FROM

(SELECT TOP 100 PERCENT EmpName, SwipeDate, MIN(SwipeTime) AS Time_In, MAX(SwipeTime) AS Time_Out

FROM #EmpHours

GROUP BY EmpName, SwipeDate

ORDER BY EmpName, SwipeDate) x;