Thank you for all of the information. The SQL Server is only going to be used for SQL so I ended up putting the OS and the SQL install...

Thank you for your help!!! Actually, the backups are going to be on a NAS device as we do several-daily, monthly and archival (long story...I'm still trying to find...

After doing some research, I am leaning toward the following configuration...

C: - 100gb for...

I apologize for posting in the incorrect forum. Should I move my question or repost??? Yes, these drives will hold everything, OS, log files and DB's but no...

Just to update you both and thank you again for your patience with me, the issue was with the data, not the view. I suppose I could have worked...

Thank you both for your advice. I have been looking into this further and for some reason, the cust_line_binary table did not update when the customer_order table did. ...

Sorry, didn't mean to post that yet...no, I don't need all of the columns, only 6. 3 from one table and 3 from another. I don't even need...

I'm sorry, I have had no SQL training whatsoever. Even the article is confusing to me. I apologize for wasting your time, that is why I chose the...

Thank you for the clarification. Here it is.

CREATE VIEW dbo.AB_CUST_ORDER_ACK

AS

SELECT dbo.CUST_LINE_BINARY.CUST_ORDER_LINE_NO, dbo.CUST_LINE_BINARY.BITS, dbo.CUSTOMER_ORDER.ACCEPT_EARLY,

...

I'm sorry but I don't know what DDL is so I'll do the best I can without annoying everyone too much. Below is a select statement from the customer_order...

As I said...I am really new to creating views...if I had an update statement, where would it be??? If I don't have one, how would I create one??? None...