Nice question. Did make me wonder for second, due to the DISTINCT, but then the brain (coffee) kicked it. I'm impressed that someone chose 5,5,5, even with your nice "(Please...

Anyone else find it really frustrating when someone (with like <=5 points) posts an incomplete question, but you think "Yeah, I think I know what they want, but need a...

8000MB is not a lot of RAM for the SQL server to play with. How complex are these queries? Have you had a look to see if you can improve...

There could be so many reasons. Power loss, system crash, hardware failure, to name but a few. You need to check the logs prior, and possibly not just on your...

The idea of a report is for it to be a report. You don't change the data on it.

Like Steve said, you could have drop down options but...

Can we make a couple of "safe" assumptions? As there are no key fields in your spreadsheet, and no data validations, can we rely that every Company's name on the...

1) Creating tables is simple. Getting them to fulfil your requirements, ensure that data integrity between each is maintained, they're efficient, etc, etc, is the challenge. your question is quite...

Try downloading the .mdf file instead. Also, just in case, ensure that SQL server hasn't created any log files with the expected name for the AW2012 database. if it has,...

Also, a more readable format, which also uses a JOIn rather than a CROSS APPLY:
SELECT CAPBANK.BANK_LOAN,
       CAPBANK.LOAN_YEAR,
       CAPBANK.LOAN_NUM,
 ...

The error is quite clear here, you have the value 'Offer Letter' and you're trying to convert it to an integer, which clearly can't be done.

Without consumable sample...

What is the error you're receiving? At a glance I can't see anything wrong, however, we can't run your code, as we don't have any Sample data. Perhaps could you...