Reply to topic  [ 22 posts ]  Go to page Previous  1, 2
Databases.. 
Author Message
I haven't seen my friends in so long
User avatar

Joined: Thu Jun 18, 2009 5:10 pm
Posts: 5836
Reply with quote
Is this part of studies or part of work or what? :?

Because it sounds like you need to ask for help either way.

_________________
Jim

Image


Thu Aug 19, 2010 12:02 pm
Profile
What's a life?
User avatar

Joined: Thu Apr 23, 2009 8:25 pm
Posts: 10691
Location: Bramsche
Reply with quote
Code:
Select name,scheduled_periods,duration
from sdowner.SDVC_ACTIVITY
where Id IN
(Select Id from sdowner.SDVR_ALLC_SET
where Student_Set = (select Id from sdowner.SDO_STUDENT_SET
where HOST_KEY in (select host_key from sdowner.SDO_STUDENT_SET where department ='32642DAC5B87808BCCF150497CA14982' ))

Something along those lines, assuming that you have given us the correct relationships. Without an entity relationship diagram or the database structure to look at, it is hard to say, whether that is accurate or not.

_________________
"Do you know what this is? Hmm? No, I can see you do not. You have that vacant look in your eyes, which says hold my head to your ear, you will hear the sea!" - Londo Molari

Executive Producer No Agenda Show 246


Thu Aug 19, 2010 12:47 pm
Profile ICQ
Spends far too much time on here
User avatar

Joined: Thu Apr 23, 2009 9:40 pm
Posts: 4876
Location: Newcastle
Reply with quote
EddArmitage wrote:
Angelic wrote:
Hm, I shall definitely be looking into this .net thinger... How hard is it to do something like this from no experience in about a day?

I still reckon it's overkill for something this trivial, and locks you into Windows! Sorry Finlay! (I do want to pick up .Net dev again, it's just kind of pointless for uni coursework as everything has to compile on a unix box) (8-p)


M O N O

_________________
Twitter
Charlie Brooker:
Macs are glorified Fisher-Price activity centres for adults; computers for scaredy cats too nervous to learn how proper computers work; computers for people who earnestly believe in feng shui.


Thu Aug 19, 2010 5:22 pm
Profile
I haven't seen my friends in so long
User avatar

Joined: Thu Apr 23, 2009 9:40 pm
Posts: 5288
Location: ln -s /London ~
Reply with quote
finlay666 wrote:
M O N O

It's not on the uni unix boxes, so it's a no-go.

_________________
timark_uk wrote:
Gay sex is better than no sex

timark_uk wrote:
Edward Armitage is Awesome. Yes, that's right. Awesome with a A.


Thu Aug 19, 2010 7:01 pm
Profile
Spends far too much time on here
User avatar

Joined: Thu Apr 23, 2009 9:40 pm
Posts: 4876
Location: Newcastle
Reply with quote
EddArmitage wrote:
finlay666 wrote:
M O N O

It's not on the uni unix boxes, so it's a no-go.


It was the comment about being overkill and locking you into windows.... it doesn't

_________________
Twitter
Charlie Brooker:
Macs are glorified Fisher-Price activity centres for adults; computers for scaredy cats too nervous to learn how proper computers work; computers for people who earnestly believe in feng shui.


Thu Aug 19, 2010 7:05 pm
Profile
I haven't seen my friends in so long
User avatar

Joined: Thu Apr 23, 2009 9:40 pm
Posts: 5288
Location: ln -s /London ~
Reply with quote
finlay666 wrote:
EddArmitage wrote:
finlay666 wrote:
M O N O

It's not on the uni unix boxes, so it's a no-go.

It was the comment about being overkill and locking you into windows.... it doesn't

Oh ok, well yes, it doesn't *lock* you in, but the last time I looked mono development was behind MS .Net development by quite a way (although this was .Net 2.0 sort of time).

I still think it's overkill to write a .Net console app compared to a quick script in python. You're perfectly entitled to your view, mind.

_________________
timark_uk wrote:
Gay sex is better than no sex

timark_uk wrote:
Edward Armitage is Awesome. Yes, that's right. Awesome with a A.


Thu Aug 19, 2010 7:21 pm
Profile
Doesn't have much of a life
User avatar

Joined: Thu Apr 23, 2009 7:16 pm
Posts: 704
Location: Leeds, UK
Reply with quote
Well i've found a handly little module called pymssql though I can't for the life of me make it work. Guess i'll keep drudging on.

I'm fully aware that I need help, but most of the helpful staff are away on holiday, and those that aren't on holiday can't help me! There aren't any staff left in the department who specialise in SQL anymore (last guy just left) and he was also the guy that specialised in Python. Woe is me, cos he really knew what he was talking about.

Didn't realise the situation was so dire to be honest, it's really struck me how impossible this is to actually do without an experience. It said specifically that this course was for people with no background in computing - a complete lie!


Fri Aug 20, 2010 11:54 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 22 posts ]  Go to page Previous  1, 2

Who is online

Users browsing this forum: No registered users and 7 guests


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

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.