I would have two fact tables. I like to have the fact table with dimension key and measures, I want to have another other indicator or whatever to put...

My company had wholesalers and retailers and we had two different dimension tables since our customers required different information for wholesalers and retailers.

I had to do it before and it might not be the best way to do it.

I had a ActiveX script to write the header line in the text...

I don't understand one thing. You said 'Address' could be used for facility, department of user, so why did you have foreign key to facility table only? ...

Good article. I use derived table a lot in my query.

You can put the query in a view but I don't think you can use it in a text file.

You cannot declare variable within the query inside the bcp. So you need to change @Timeout to 'DATEADD..'.

Wait a minute, I thought you wanted to find out which data in TableA but not TableB and there were multiple rows in TableB.

Full outer join means you...

How do you get the data right now? When you say you get the data incrementally, do you mean the fact table data? Then you have to reprocess...

Do you have a 'Date' dimension table? In that table you should have day, month, year as the drill down sequence, when you retrieve the data, you should retrieve...

Can you use SQL Profiler to find out why the dead lock occurred?

Yes my friend did that, you have to go to a speech therapist but still it helps to correct some accent but it will not eliminate totally. The...

I had worked for 8 companies, I always worked over 40 hours in each company. My manager in one company hinted me that everyone worked over 40 hours on...

You can try this query, I am not sure it will work.

SELECT a.value, b.bvalue

FROM TableA a

LEFT OUTER JOIN (SELECT DISTINCT Value bvalue

...

When the sp inserted a row in the report table, did it use 'BEGIN TRANSACTION....COMMIT TRANSACTION....END TRANSACTION'?

It would lock the table until the 'INSERT' is done. The 'UPDATE' would...