One way to test a mirror is to query both database and look for the same results. Additionally you could change a value and see if it propagates to...

Cool. Glad you got everything worked out. 😀

Did you get a chance to check this out?

Are you trying to get the totals for a year at a time or would you like to see a aggregate total of everything prior to that year? For...

Put this in the ORDER BY clause. You dont have to add any additional columns as the third step does not use a group by.

ORDER BY CONVERT(VARCHAR,CONVERT(DATETIME, WeekNbr, 101),101)

Ok this is what I am thinking. The view retrieves the records from the assoicated tables and place a value of NULL for the SPAuditID column; however, at runtime...

I am not sure what else we could try. I will do a little research on the INSERT INTO SELECT * FROM View to see if it has any...

I understand that you would like the field to be NULL; however, what I am asking is when you plugged a number into this field, the insert worked. Did...

Did you list all 23 columns like the sample text file, or did you lessen the number of columns for testing?

When you plugged in newid() for the view insert did...

This should do the trick.

declare @Player1 table

(

date datetime ,

player_id int,

game_id int,

level_id int,

location_id int,

played_hours int

)

insert into @Player1

select '12/1/2007', 16000, 101, 102, 100, 8 union all

select '12/2/2007',...

Sorry, I jumped the gun in answer your question without reading your required results. I stopped at how do I :hehe:

Let me look at it a little harder.

join the tables/views with a full outer join

Grant is right we need to isolate the issue to either the insert or the view. If successfully insert outside the view, we can narrow the problem to the...

rabin_panichnok,

I too am a little confused because this statement worked as intended. Did you even test your statement or did you post it before running to verify?

The update statement...

I still have the column order sitting in the back of my mind. Cmayeux feels so passionately about the column order being correct that I would like to...