I remember. I just wanted to give some advice as I find myself in a similar position....

CASE 02

Date Customer TransactionID ProductID Quantity Sales Ammount

20120101 CLI01 FAC0005 PROD01 3 300 €

20120101 CLI01 FAC0005 PROD02 2 500 €

20120101 CLI01 FAC0006 PROD01 1 100 €

20120101 CLI02 FAC0007 PROD01...

ppcentral (4/27/2012)

---

Of course...

One thing is the grain by the transaction (CASE 01)

Another thing is the grain by the transaction per item line (CASE 02)

Where in CASE 01 you have a...

I'm not an accidental DBA, I got into this because I wanted to and found it fun.

You are what I consider a Hybrid DBA, you have experience on both sides...

Which is not what Kimball indicated based on this from your own post (emphasis is mine):

But in a Transaction Fact Table...

CASE 01 doesn't go...

And while you are looking at BCP, you may also want to look at BULK INSERT.

ppcentral (4/27/2012)

---

HI Lynn,

Thanks again... I know you the tips and suggestions you gave me... I understand that you are trying to help me! 🙂

My issue is about the summary table......

ppcentral (4/27/2012)

---

Thank you Lynn for you reply.

Again, I need to have a Fact Table (CASE 01) with just the information stored in the ORDER_Header (DATE, CUSTOMER and TRANSACTIONID) and the...

Here is my suggestion since you really haven't given us much to work with here.

Open Books Online and read about error handling. You have two choices and you need...

Steve Cullen (4/27/2012)

---

A simple example of dynamic sql in a procedure :

CREATE PROCEDURE DynamicSelectExample

DECLARE

@Database SYSNAME = 'snafu',

@Tablename SYSNAME = 'foobar',

...

ppcentral (4/27/2012)

---

Paul,

Thanks again for your reply...

I made the CASE 02 just for explain my issue.

And finally you answered my question! 🙂

Ok... you think the CASE 01 is a Summary Table......

dwain.c (4/26/2012)

---

I was looking at a stock table with the columns Part Number and Part Description. I just found out that we have over 95 tables that contain these two...

riya_dave (4/26/2012)

---

DECLARE @Table TABLE(

[ID] int,

[CostA] real,

[CostB] real,

[CostC] real

)

INSERT INTO @Table

EXECUTE [dbo].[CostProcedure]

@RootId = @Rootid

...

And, last but not least, you are also missing the expected results based on the sample data.