Post reply

SQL Help Please

  • April 17, 2016 at 7:32 pm

    #318124

    Guys, Im new to sql and I have had trouble writing these codes. I dont have anything to check my answers too so I can study. If anyone could please help, that'd be great.

    I have screenshots attached. Thank you

  • April 18, 2016 at 5:26 am

    #1872702

    we can't help you with homework, but if you have specific questions you can't seem to get right, if you show us what you've done,we can offer suggestions.

    If i do the homework, i want the grade or job myself, no sense in involving a middleman, right?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 18, 2016 at 5:32 am

    #1872707

    I'm with Lowell. I'm only writing the query if I get the grade.

    If you're stuck, try writing the query. Show us what you have tried that doesn't work. I'm sure any of us would be happy to help you fix a query. I just don't see why I should do the work for you.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 18, 2016 at 6:51 am

    #1872728

    Were you really so lazy that you couldn't even copy the problem? That won't get you anywhere.

    If you don't have anything to test your answers, then build something. Download SQL Server (Express and Developer editions are free) and create your database and tables, then insert data into them. SSMS has a decent GUI to help you create everything.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • April 18, 2016 at 6:57 am

    #1872730

    Thanks guys, I and a few classmates figured it out.

    Luis, you don't need to be so rude. I actually have a great job lined up and I am getting both a minor and a bs in engineering, so I am not lazy. I've busted my ***. I attached the problems below because of the ERD. But thank you for the reply

    Have a great rest of your Monday everyone

  • April 18, 2016 at 7:09 am

    #1872737

    jsalzm1 (4/18/2016)

    Thanks guys, I and a few classmates figured it out.

    Luis, you don't need to be so rude. I actually have a great job lined up and I am getting both a minor and a bs in engineering, so I am not lazy. I've busted my ***. I attached the problems below because of the ERD. But thank you for the reply

    Have a great rest of your Monday everyone

    I'm sorry, it's some kind of tough love, partly generated by Monday morning.

    I gave you a good advice, and you can ask anyone. If you're not able to test your solutions, your can't say you have a solution. I told you a way to test.

    I'm sorry if you feel offended and believe that having a BS in Engineering is not being lazy. There are lots of people that completed their BS and stopped learning. They're lazy and complain about not having a good job or getting promotions. So, please prove that you can do things right every single time. Not to us, but to you.

    Have a nice week.

    P.S. I don't want to be rude, just realistic.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • April 18, 2016 at 7:44 am

    #1872751

    jsalzm1 (4/18/2016)

    Thanks guys, I and a few classmates figured it out.

    Luis, you don't need to be so rude. I actually have a great job lined up and I am getting both a minor and a bs in engineering, so I am not lazy. I've busted my ***. I attached the problems below because of the ERD. But thank you for the reply

    Have a great rest of your Monday everyone

    Luis is a very helpful contributor to these forums I can assure you. This is one of the best communities online for SQL. You just have to understand that we subscribe to the thought that we want to help people succeed.

    Cheers and welcome to the forums! 🙂

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply