Seems to do the job, Thanks!

That doesn't seem to quite do it. When I run it using an fkeyuser flag like I outlined above I get:

1,first item,1,1

2,second item,1,1

3,third item,1,1

4,fourth item,1,1

I was expecting:

1,first item,0,1

2,second item,1,0

3,third item,0,0

4,fourth...

Sorry, edited the original post with the info. Maybe those links should be sticky'd on top of the forum.

Also under the how to post data link, there is an error

http://www.sqlservercentral.com/articles/Best+Practices/61537/

The...