I wouldn't call that luck .

And you're the one asking others to stop doing that???

I either don't understand your design or there's a missing link.

You need all 3 tables for this, the temp table is useless in this case to get that info (unless...

Make sure you retest the insert statement to be certain that there's no syntax error. It's much easier to correct them on your end.

I'll worry about the identity inserts...

Something like this :

Create table demo

(

a varchar(10) not null,

b int not null

)

insert into demo (a, b) values ('test', 0)

insert into demo (a, b) values ('asdf', 3)

insert into demo (a,...

Yup but it doesn't say what cause this problem to pop up in the first place (I know about the object_id... but what caused that problem).

Or actually using the correct datatype for the column in the first place and avoiding this problem altogether.

How about it's thursday morning here?? and I'm not working tomorrow anyways .

This is the kind of mistake you must aboid at...

Maybe you should have used more xml to solve this problem .

Was the user David or something like that??

Be carefull to always specify the owner of the object or else you'll suffer terrible consequences in procution code (not just a threat).

And the insert statements??

we must use the same data as you have to recreate the problem.

insert statements please. I'm not typing all type by hand.

There can never have too many details in a question .

how about else null end???

So that the columns with the real value of 0 doesn't get mixed up with corrupt data?

Run this to get the answer :

Select user_name(uid) as OwnerName from dbo.SysObjects where name = 'CallLogRevenuesTEST ' and XType = 'U'

then replace dbo. with the results of the query.

If...

You're missing a table in this design, should be :

Users

Documents

PermissionsUsersDocuments

It takes all three of these tables to create this query.