For larger dimensions it is usually more efficient in my experience to load a staging table that has your key columns nullable and do an update with a stored procedure.

...

This may sound odd, but try adding one of the problem users directly rather than through the group. That will at least tell you if the issue is with the...

I suggest coming up with a simple example. Employee A is in charge of product x. Employee B is in charge of one a subproduct, x1, another Employee is in...

It's returning correctly. 0 being midnight, 23 being 11 PM.

An advantage to using a DW is you benefit from having a known structure designed specifically to support analysis. If you use the source systems structure and there is a...

What is the declaration of your trigger?

By the NULLs, it appears that nothing is being pulled from EVENTDATA()

CDCUserName should be in each cdc table. This is the sql/windows login used at the time of the change.

No, the tables have to be created in the same database. You can adjust how long the data stays in there (I can't remeber off the top of my head...

Take...

Interesting. thanks for that link.

Madhivanan (11/6/2008)

---

Is this reliable?

SELECT dates FROM

(

SELECT '$.00 AIIMIE 01 2002' as dates union all

SELECT...

Jeff Moden (11/6/2008)

---

Cliff, take a look at the text file attached in the first post of this thread... not much to "pattern match" on... certainly, not enough to build...

You'll have to write a cleanser.

I would load a staging table that has the same coumns as your target table plus

CleansedDate field

IsValidDate field

Update the IsValidDate field with the results...

ISDATE()

With the results of the election we should see some kind of alternative energy solutions over the next four years. It will be interesting to watch.