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!)

but be sure to get the second edition (or later). The first one was a bit wonky.

Eirkur would no doubt be able to do this in a nanosecond, but in a nutshell, you would have to use XQuery to do this. Here's the article that...

Error: The buffer manager cannot extend the file "C:\Users\}.tmp" to length 2030084 bytes. There was insufficient disk space

Bigger hard drive? Space on another network drive?

Do not pass go. Do not collect $200. Go directly to the bookstore and by a copy of Ralph Kimball's book. he explains how to build a star schema/Data Warehouse...