That's definitely something I'm open to the idea of.  Initially I'm looking for some free or very inexpensive resources to get an idea if it's something I can wrap my...

I took care of the duplicates in one table but now I'm having trouble joining tables with a one to many relationship.  I realize this is getting off topic based...

I swear all it takes is to walk away for a minute and things make sense.  It turns out Table1 has some duplicates in it.  Let me clear them out...

I'm bringing this topic back to life because the need for it has come back.  Luckily, this time it is a more scaled back version and I figured out the...

I'll continue to play around with indexing and what not on the joins to see if I can improve that.  For now I've created a physical table using the view...

The base table has ~4 million records.  There are four different lookup tables having record counts of 270, 7000, 24000, and 42000.  The main reason of trying to avoid putting...

Thanks, Brian! That's some really good information and will help me accomplish what I'm trying to do. I'll mess around with it and get back with any questions...

I was able to get what I need by using a combination of making the role the owner of all the schemas they need access to and by specifying deny...

Sue - I must not be setting it up correctly when trying to follow your advice. What permissions do I grant at the database level that won't apply to...

I'm away from a computer and will be for the next few days so I'll give it an attempt to type it out here. The headers will read:

Date, Code,...

whenriksen -

The example I provided is code for a report we are taking over from another group. The first goal is to convert it to ANSI-92 style joins so...

Here's some sample data. There is some more filtering I need to do on my end so that is why it returns so many results. My intent was...

I wanted to give this a bump in case someone missed it last week and can provide information on what I'm trying to do.

They are set to read-only now but it's not specified to not include them in the backups. I was also hoping to move them out of sight without having...

Thanks, MadAdmin and ZZ!