Help!

Sql Query

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Office applications RSS
Next:  0_0 It's Official. I Get Every Sims 2 Problems T..  
Author Message
tiredmother



Joined: Aug 09, 2003
Posts: 1312
PostPosted: Tue Mar 07, 2006 10:29 pm    Post subject:
HI!
I haven't been around in a very, very long time because I'm in school and a tiredmother, too!

I am studying accounting, yet, for some reason, we are expected to write SQL queries using Microsoft's Query Analyzer. I can do the simple ones but the last three in the assignment are beyond me. The assignment is made harder by the fact that I can't access the database except at the school which is 45 minutes away. I never seem to have more than thirty minutes between picking up one of the kids somewhere or going to work. It's due Thursday. Sad

I was wondering if some kind, ultra-smart SQL wizard on these forums would be willing to help a tiredmother trying to get through an accounting class.

I could send you the exercise in .pdf which includes the tables being queried with their respective attributes. Note, I do not consider this cheating because collaboration is allowed. (I've checked with just over 50% of the other students in my class, and they can't figure it out either! We're accounting majors!!!)

Thanks for anything helpful you can offer!
Teresa
Back to top
Gary66



Joined: Sep 01, 2005
Posts: 8353
PostPosted: Wed Mar 08, 2006 4:10 pm    Post subject:
So you want someone to do your homework. :hmm: It is nice to see you posting again anyway. Just kidding about the homework.
Quote:
ultra-smart SQL wizard
I don't know if we have such a creature.
Back to top
tudoridvoreanu



Joined: Mar 08, 2006
Posts: 1
PostPosted: Wed Mar 08, 2006 7:00 pm    Post subject:
Let's see. I have sent you a private e-mail with my address.
Quote:

I could send you the exercise in .pdf which includes the tables being queried with their respective attributes.

Back to top
Werebo



Joined: Aug 09, 2003
Posts: 4078

Location: SE London, UK...
PostPosted: Wed Mar 08, 2006 9:43 pm    Post subject:
Quote:
I don't know if we have such a creature.

Amazing Forum here, just as one is needed, one comes along :thumbup:

:laugh:

Back to top
tiredmother



Joined: Aug 09, 2003
Posts: 1312
PostPosted: Thu Mar 09, 2006 1:58 am    Post subject:
Yep! I knew there would be one!

(But I must have my e-mail wrong in the profile Teddy because I never got your message.) Sad

Thank you so much for the offer! I find the most helpful people here! But, I worked on it last night and broke it down into the steps (it was only two!) needed to create the subquery, then the query. Then, I took it to the teacher and said, "now, what?" He's a good teacher and helped me finish it up. I printed it out earlier today and now wash my hands of it! Thanks anyway! :wub:

Quote:
So you want someone to do your homework.

Yes, that was my plan. :goof: Thanks for the welcome back.
tiredmother
Back to top
starionwolf



Joined: Mar 13, 2006
Posts: 5
PostPosted: Tue Mar 14, 2006 2:45 am    Post subject:
Hi tiredmother, good luck in the class. I envy you because you are majoring in an interesting field. I took some basic accounting courses in college. I don't think I have used SQL in an accounting class before. I use PL/SQL in my Oracle database programming class.

I can do simple queries like:

select * from accounts
where salary = 30000
group by 'Last_Name';

That's about it.

Bye
Back to top
tiredmother



Joined: Aug 09, 2003
Posts: 1312
PostPosted: Tue Mar 14, 2006 3:04 am    Post subject:
Quote:

Hi tiredmother, good luck in the class. I envy you because you are majoring in an interesting field. I took some basic accounting courses in college. I don't think I have used SQL in an accounting class before. I use PL/SQL in my Oracle database programming class.

I can do simple queries like:

select * from accounts
where salary = 30000
group by 'Last_Name';

That's about it.

Bye


Thank you starionwolf...I'm fortunate to be attending school right now, that's for sure.

Yeah, these were (unfortunately) a lot more complicated than that. It's a new class for the school, for the prof and for the program. The accounting firms that come on campus to interview for interns and other new hires expressed strong desires for accounting grads to have a better ability to communicate with the IT people about what they need the system to do and the controls that need to be in place.

Additionally, Sarbanes-Oxley (fallout from Enron) created a new oversight board that issued a standard requiring auditors to provide a statement attesting to the management's assessment that the controls in their IT system are adequate and functioning the way they ought to function. Sort of hard for the auditor to do that if he/she doesn't have a clue how the system is supposed to work! (Sheesh! I sound as exciting as my textbooks! Surprised I looked for a sobbing smilie - couldn't find one!)

We've been told that a CPA with an MIS (management information systems) option would be hired immediately upon graduation by just about any firm they were interested in. It makes sense...how much accounting actually takes place away from a computer these days? Not much! I've thought about it but I'm already a tiredmother with a 6 quarters to go and the MIS option would add four more. I just can't face that! :blink:
Back to top
Werebo



Joined: Aug 09, 2003
Posts: 4078

Location: SE London, UK...
PostPosted: Tue Mar 14, 2006 9:31 am    Post subject:
Quote:
I looked for a sobbing smilie - couldn't find one!

Here you go Tiredmother, you can save these if you like Wink ...

Hehehehehehehehhe.....

:laugh:

PS Re: all that 'accounting' stuff... Is that really english?? I understood the words but the sentences made a wonderful 'whoooooshing' sound as they went straight over my head... Wink

Back to top
tiredmother



Joined: Aug 09, 2003
Posts: 1312
PostPosted: Sun Mar 19, 2006 2:10 am    Post subject:
Quote:

Quote:
I looked for a sobbing smilie - couldn't find one!

Here you go Tiredmother, you can save these if you like Wink ...

Hehehehehehehehhe.....

:laugh:

PS Re: all that 'accounting' stuff... Is that really english?? I understood the words but the sentences made a wonderful 'whoooooshing' sound as they went straight over my head... Wink


Thanks for the tears....hmm...that doesn't seem right. :unsure:

I think it's English, but I don't know anymore, the accounting classes have distorted my view of reality. :tongue:
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Office applications All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum