Many thanks!  How do I create the login at the sever level?  Is that master db?

Hi,  Many thanks I will study the link you send.  This is actually all in a test environment.  I agree with your prospective on keeping the separate instances.  Thanks for...

Many thanks all for all the replies!

Many thanks for all the replies everyone!

If using CROSS APPLY is there a way to do a WHERE clause so that we don't create line items for a $0 dollar...

this works perfectly!  Many thanks!!

Many thanks for the quick reply!

The trouble with the case solution is that I still get mutliple rows per company.  What I am hoping to do is consolidate each company...

I studied the article and have my sample data, and real project working now, many thanks!!

Hi, My apologies for any confusion.

What I am asking for help with now is the ability to compare values between two Users based on Fruit they like.

For example, using my...

Hi Many thanks both for your help on this!

For some reason, I get the message Invalid object name 'dbo.DelimitedSplit8k'.   Could I need an update for this?

Also, if I want to...

• This reply was modified 3 years, 8 months ago by  rjjh78.

Many Thanks!!

Ah, got it!  Thanks again Phil!

Thanks again!!

Many Thanks!  Last question, for the Junction table do I want to store a record for all possible language per user?  Or only the languages they have selected only?

Thank you all for your thoughts/recommendations/feedback.  I very much like the idea of using a Multiple Checkbox drop down.  If I go with these plan, what is the best way...

Thanks again!  So are you saying the table structure in my example would be OK for data storage, but instead of using checkboxes at the UI level, use a mutliple...