Click here to Skip to main content
15,170,745 members
Home / Discussions / Database
   

Database

 
AnswerRe: A Secured Hotel Management System using Visual BAsic 2010 Pin
Simon_Whale3-Aug-10 6:28
professionalSimon_Whale3-Aug-10 6:28 
AnswerRe: A Secured Hotel Management System using Visual BAsic 2010 Pin
dan!sh 3-Aug-10 6:29
professional dan!sh 3-Aug-10 6:29 
AnswerRe: A Secured Hotel Management System using Visual BAsic 2010 Pin
Smithers-Jones3-Aug-10 6:49
MemberSmithers-Jones3-Aug-10 6:49 
AnswerRe: A Secured Hotel Management System using Visual BAsic 2010 Pin
Chris Meech3-Aug-10 9:54
MemberChris Meech3-Aug-10 9:54 
QuestionHow to get value from outer to inner SELECT Pin
Robert König3-Aug-10 2:59
MemberRobert König3-Aug-10 2:59 
AnswerRe: How to get value from outer to inner SELECT Pin
Tim Carmichael3-Aug-10 6:27
MemberTim Carmichael3-Aug-10 6:27 
AnswerRe: How to get value from outer to inner SELECT Pin
Bernhard Hiller3-Aug-10 21:55
MemberBernhard Hiller3-Aug-10 21:55 
GeneralRe: How to get value from outer to inner SELECT Pin
Robert König3-Aug-10 23:35
MemberRobert König3-Aug-10 23:35 
This is my query now:
SELECT ID,
       DAY
FROM (SELECT ROWNUM as CAL_ROWNUM, 
             DAY AS MAX_CALENDAR_DAY     
             FROM (SELECT DAY 
                   FROM CALENDAR
                   WHERE DAY > TRUNC(TO_NUMBER(SYSDATE - TO_DATE('01.01.1970', 'DD.MM.YYYY')))
                   AND CALENDAR.IS_WORKING_DAY= 'y'
                   ORDER BY CALENDAR.DAY)
             WHERE ROWNUM <= (SELECT MAX(NR_OF_DAYS)
                              FROM WORKCENTER
                              WHERE ID IN (1, 2, 6, 7, 9))
     )
INNER JOIN WORKCENTER
ON NR_OF_DAYS = CAL_ROWNUM
WHERE ID IN (1, 2, 6, 7, 9)

And it works, yeah! Thanks guys.

Greetings
QuestionTemporary freeze updating .SDF file - fixed Pin
hairy_hats3-Aug-10 1:45
Memberhairy_hats3-Aug-10 1:45 
GeneralSelect number of rows [modified] Pin
MathewPV2-Aug-10 22:18
MemberMathewPV2-Aug-10 22:18 
GeneralRe: Select number of rows Pin
J4amieC2-Aug-10 23:01
MemberJ4amieC2-Aug-10 23:01 
GeneralRe: Select number of rows Pin
MathewPV2-Aug-10 23:24
MemberMathewPV2-Aug-10 23:24 
GeneralRe: Select number of rows Pin
Jörgen Andersson3-Aug-10 0:25
professionalJörgen Andersson3-Aug-10 0:25 
GeneralRe: Select number of rows Pin
MathewPV3-Aug-10 0:58
MemberMathewPV3-Aug-10 0:58 
GeneralRe: Select number of rows Pin
J4amieC3-Aug-10 4:06
MemberJ4amieC3-Aug-10 4:06 
GeneralRe: Select number of rows Pin
J4amieC3-Aug-10 4:07
MemberJ4amieC3-Aug-10 4:07 
GeneralRe: Select number of rows Pin
Jörgen Andersson3-Aug-10 4:46
professionalJörgen Andersson3-Aug-10 4:46 
QuestionOrder By Pin
SatyaKeerthi151-Aug-10 21:34
MemberSatyaKeerthi151-Aug-10 21:34 
AnswerRe: Order By Pin
R. Giskard Reventlov1-Aug-10 22:57
MemberR. Giskard Reventlov1-Aug-10 22:57 
GeneralRe: Order By Pin
SatyaKeerthi152-Aug-10 0:40
MemberSatyaKeerthi152-Aug-10 0:40 
GeneralRe: Order By [modified] Pin
R. Giskard Reventlov2-Aug-10 1:16
MemberR. Giskard Reventlov2-Aug-10 1:16 
Questiondb4o Embedded DB Pin
Mike Hankey1-Aug-10 3:05
professionalMike Hankey1-Aug-10 3:05 
AnswerRe: db4o Embedded DB Pin
PIEBALDconsult1-Aug-10 4:37
professionalPIEBALDconsult1-Aug-10 4:37 
GeneralRe: db4o Embedded DB Pin
Mike Hankey1-Aug-10 4:43
professionalMike Hankey1-Aug-10 4:43 
GeneralRe: db4o Embedded DB Pin
PIEBALDconsult1-Aug-10 4:46
professionalPIEBALDconsult1-Aug-10 4:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.