I'm in exactly the same situation. If I figure out how to do it, I'll let you know.

Gila: it's on a crazy redundant Net App filer. I guess technically it is network attached storage, but when I hear network attached...

ps (6/8/2009)

---

Rick Todd (6/8/2009)

---

If we move our TempDB to an iSCSI solution we can greatly improve the performance of one of our vendor's apps. We don't have a lot of...

What do you get if you open the document in a simple word processor, and not an xml processor? Just right-click on it and choose "open with" and choose notepad....

Well, I'm hoping to get some advice on how to configure the relationship between the FactTransaction Measure Group, the DimCustomer Measure Group, and the DimSaleDate Dimension in Analysis Services Dimension...

P.Prashanth Reddy (3/11/2009)

---

Thanks Rick for the reply.

But I must join the comments table. The problem is that I cannot make any changes to the following query.

SELECT ...

FYI, if you want the average working stiff, like me, who just has a couple of minutes a day to help people out, to answer, you're going to have to...

P.Prashanth Reddy (3/11/2009)

---

I have two tables called Resource, and Comment

table structure is

1)Resource

EntryNoint

ResourceNovarchar(50)

JobNovarchar(50)

Quantitydecimal(18, 0)

2)comment tablr

CommentNoint

CommentLineNoint

commentntext

Relation between two table is EntryNo in Resourse table and the commentNo in comment table are the...

I couldn't figure out how to get it to do it in a controlled fashion. I really wanted to like the way BIDS did it for me, because it was...

We're doing something similar to the timestamp column, although not quite as easy for us, since there isn't one in the source system DBs, which we don't have control over,...

Hari, a possibly completely different solution, depending on how you're consuming the data. We use Pivot Tables for a lot of our analysis, and you can just right click on...

Ells already answered your problem, but I wanted to 2nd the idea, with one minor caveat. We do the same thing: at the end of the ETL process we rank...

I would say it really depends on how large your product table is compared to your fact tables. If you're going to be adding 2 columns, one of which sounds...

s.appanasamy (2/26/2009)

---

Hi Rick,

Thanks for your reply...

I would like it to insert like (as in first scenario you mentioned)

1 1 ...

s.appanasamy (2/24/2009)

---

But while using SCD transformation for loading target, it inserts all the records in Target. ie, after the load Target table look like

11XXX ...