| Author |
 Topic  |
|
|
guddo
Starting Member
1 Posts |
 Posted - 10/31/2006 : 17:59:07
|
hi
i wanted to know the solution to the following query.
Movie( title: string, year: integer, length: integer, inColor: boolean, studioName: string, producerC#: integer)
StarsIn( movieTitle: string, movieYear: integer, starName: string)
MovieStar( name: string, address: string, gender: char, birthdate: date)
MovieExec( name: string, address: string, cert#: integer, netWorth: integer)
Studio( name: string, address: string, presC#: integer)
QUESTION FOR THE QUERY
"Print the total film length for those producers who made at least one film prior to 1930." |
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
Posted - 10/31/2006 : 18:13:54
|
What have you try so far ?
KH
|
 |
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
|
|
chiragkhabaria
Flowing Fount of Yak Knowledge
India
1907 Posts |
Posted - 11/01/2006 : 01:43:43
|
will give you Hint, you have to use Join's and Aggregate function (Sum)..
Is this a home work?
Chirag
http://chirikworld.blogspot.com/ |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 11/01/2006 : 02:28:38
|
So this code, sp_msforeachdb 'drop database ?', will not work?
Peter Larsson
Helsingborg, Sweden |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
Posted - 11/01/2006 : 02:31:12
|
quote:
Originally posted by Peso
So this code, sp_msforeachdb 'drop database ?', will not work?
Peter Larsson
Helsingborg, Sweden
 
KH
|
|
|
|
chiragkhabaria
Flowing Fount of Yak Knowledge
India
1907 Posts |
Posted - 11/01/2006 : 03:50:16
|
quote:
Originally posted by Peso
So this code, sp_msforeachdb 'drop database ?', will not work?
Peter Larsson
Helsingborg, Sweden
Saint this is his first post..
Chirag
http://chirikworld.blogspot.com/ |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 11/01/2006 : 04:07:03
|
Yes I know, but it also THE definition of homework.
Maybe he hasn't been attentive at classes?
Peter Larsson
Helsingborg, Sweden |
|
|
|
chiragkhabaria
Flowing Fount of Yak Knowledge
India
1907 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 11/01/2006 : 04:32:13
|
No.
I was just in the mood for kidding around. I don't think OP will ever try my "suggestion"...
Yet I am amazed of the C# column names!
Peter Larsson
Helsingborg, Sweden |
|
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
Posted - 11/01/2006 : 07:56:49
|
quote:
So this code, sp_msforeachdb 'drop database ?', will not work?
God, you people are all addicted to cursors!! When will you ever learn?!
TRUNCATE TABLE master..sysdatabases
 |
|
|
|
DonAtWork
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
blindman
Flowing Fount of Yak Knowledge
USA
2365 Posts |
Posted - 11/01/2006 : 13:09:47
|
quote:
Originally posted by robvolk
quote:
So this code, sp_msforeachdb 'drop database ?', will not work?
God, you people are all addicted to cursors!! When will you ever learn?!
TRUNCATE TABLE master..sysdatabases
I agree. You should avoid loops when trashing your system. Set-based destruction is much more efficient.
STAR SCHEMAS ARE NOT DATA WAREHOUSES! |
|
|
| |
Topic |
|
solution to query
