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/

Ouch! I hate it when I do that... reminds me of the Far Side cartoon... "Thag, take napkin, have mammoth on face."

Not enough information. What do you mean by "incorrect"? Is this a matrix or a table? What did you expect vs what you got?

got sample data?

oh, that's <> (not equal), the formatting stuff here screwed it up.

Might be as simple as

=Sum(IIf(Fields!Factory.Value <> "ABC", Fields!Total_Progs.Value,0))/Sum(IIf(Fields!Factory.Value <> "ABC", Fields!Anotherfield.Value,0))

If you need the total size of Total_Progs/(Total_Progs + Factory), you would have to alter it a little.

Note, you will...

This works...

SELECT A, B, C, txt

FROM

(SELECT 1 AS A, 2 AS B, 3 AS C

UNION ALL

SELECT 2,1,3

UNION ALL

SELECT 4,1,2) x

CROSS JOIN

(SELECT 'Text1' AS txt

UNION ALL

SELECT 'Text2') y

In your...

(See, told ya Eirikur could do it... even if I can't remember how to spell his name!)