wow - quick response 🙂

thanks!

think i'll have to look into "ownership chaining" but if you have any good links to this feel free to pass them on.

cheers brian!

hi, this may be a stupid question, so apologies in advance (i'm not a dba!)... does this solution work if the users are not members of the db_datawriter role?

for example:

if...

there seem to be some very ungrateful (and even rude) posts here! and it's completly uncalled for!

Thanks for this! I'm looking forward to the next installment: "using it to generate a time coordinate table."

this video doesn't work for me.

i'm using windows XP and IE.

??!!

Thanks Steve and Jack.

Jack, do you have an example of the outer join problem?

Please keep posting if you have any more answers!! I want to knock this one on the...

Thanks Grant.

Much appreciated!!

This does parse, so i'm guessing the compile is something else then?

in my actual code (not the snippet i posted) i get the data from a text file and its...

Thanks for your reply DNA.

Would you (or anyone) agree that BOL is not clear about this? Or have I missed something?

Cheers

hang on a min... this looks familiar!

would this help:

[Delete Duplicates]

http://www.sqlservercentral.com/questions/T-SQL/62798/

🙂

dougi - are you using sql 2000 by any chance?

whats happened to sql - it used to be so simple 😉

Good suggestion!!

Any others?

thanks for the clarification hugo

Hello!

Whats this??!!

I had no idea this was needed... is this new to SQL2005?

And just to be absolutly sure, everytime a table used in a view changes (ie column added/deleted) the...