So you have a fact table with a set of totals by day. you want to get a count over time based on that data. So using my...

Sorry I'm confused. What would you be storing in the fact table? If you do not have a boxID then how are you storing the fact? do you just...

Sorry update was a poor choice of word. what I meant to ask more is to clarify that when the record is clean and outputed to SQL any way...

Assuming I am not over simplifing what you are looking for and assuming I have mocked up data that is a representation of what you are looking for then this...

one last question are you updating the fact table from a fact table or are you pulling the data from a SQL database and then inserting into the data wharehouse....

so would it be fair to say you are looking for the number of groups a box is in during a time period?

not to ask a dumb question but did you check all logs? Application log, event log, Sql server erro log, SQL server system log?

I apologize for my silly post before. I looked and I was thinking there was a more specific error when there was a violation. once again the filling drawer...

based on the error it sounds like the foreign key constraint already exists. I would look in management studion and verify what leys and constriants already exist.

I think I am following you but to be sure would the count ever be more than 1? if so can you give an example of when it woul dnot...

I have run into the same problem and after much googling I discovered that VBA does not support Null in the same context it used to. as such Null...

If CleanRecord then

Row.DirectRowToCleanOutput() 'This works fine

Else

Row.DirectRowToErrorOutput()

Row.PAIDDATE = #11/6/1984#

Row.DirectRowToScrubOutput()

End if

So PAIDDATE gets updated Even if Row.DirectRowToCleanOutput() is updated? I assum the paiddate is some other value before this trasform is executed?

you can not determine when a record was inserted or updated unless you have either a trigger setup to record a timestamp or some form of record auditing is active....

CirquedeSQLeil

Here! Here! I could not agree more with what you said. I am still new but I answer questions I feel I can and I get more out...

chage the where cluase from 'userid=' to 'userid in'

delete from users

where userid in

(select users.userID from users

left join aspnet_users

on users.Username = aspnet_users.UserName

where aspnet_users.UserName is null)