Permanent change or presentation only?

Yup, WITH THE REQUIRED RESULTS.

Last time I say that to you.

Yup, rows for every other tables in the join and the results that the query should give WITH THOSE ROWS.

CREATE PROCEDURE test

AS

select * from msdb..sysjobs

GO

And here's the new URL .

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=232087

you can run sp_updatestats and then dbcc updateusage (not sure of the 2nd one)

If the db is is in full log mode, then yes... but they would hav to buy an expensive software to track those changes.

Why are you worried about that?

ISNULL(Object1, 0) + ISNULL(Object2, 0)

??

No.

What query did you run??

Maybe we should start a think tank .

I think it's time you changed your nickname .

That's why I ask for that much inf... I don't need to sweat long because I hav everything I need to make it work

WAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAY back in time .

You see it's not too bad... you're still getting rest even without knowing that 3rd thing .