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;

Couple of things ... someone just asked this question on here... (answered maybe 15 minutes ago), and your INSERTS don't work.

if you use ROW_NUMBER() and partition by the UserID column...

Seems like you might be making this harder than it really is.

Is it not true that the odd-numbered "logins" for each employee are clocking in and the even ones are...

I guess you could create a report snapshot and expire it after some reasonable amount of time (depending on how often you need the data in the report refreshed). ...

I would probably start by reading this article[/url] by Pinal Dave on Simulating LAG in SQL Server 2008.

If possible I would persist the shredded XML to a table and then...