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

Yeah, we silly Anglos can't read that well...

Yeah, if you use a smaller font, you can squeeze more letters into the same space. <eye roll >

Why would you want to?

Sounds like a "Death by UDF" in the making... Kevin Boles did a presentation on it, and it's here

I think this is right... and it's missing the relationship between Card and Transaction...

CREATE TABLE CCTransaction (

TransactionID INT,

Credit_Card CHAR(19),

TransactionDate DATE,

Result INT

);

INSERT INTO CCTransaction

SELECT 1 AS ID,'3578 4539 4328 4381'...

Maybe this will help.

http://blog.sqlauthority.com/2011/05/12/sql-server-import-csv-file-into-database-table-using-ssis/