Click here to Skip to main content
15,351,370 members
Home / Discussions / Database
   

Database

 
GeneralRe: Loading large amount of data with unacceptable time Pin
David O'Neil27-Apr-14 11:38
professionalDavid O'Neil27-Apr-14 11:38 
AnswerRe: Loading large amount of data with unacceptable time Pin
Mycroft Holmes27-Apr-14 12:54
professionalMycroft Holmes27-Apr-14 12:54 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed27-Apr-14 19:28
MemberAmr Muhammed27-Apr-14 19:28 
GeneralRe: Loading large amount of data with unacceptable time Pin
Mycroft Holmes27-Apr-14 21:54
professionalMycroft Holmes27-Apr-14 21:54 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:11
MemberAmr Muhammed29-Apr-14 13:11 
AnswerRe: Loading large amount of data with unacceptable time Pin
V.28-Apr-14 0:01
professionalV.28-Apr-14 0:01 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:06
MemberAmr Muhammed29-Apr-14 13:06 
GeneralRe: Loading large amount of data with unacceptable time Pin
V.30-Apr-14 23:45
professionalV.30-Apr-14 23:45 
so basically you have this?

DEED_NR START_SHARE END_SHARE
1             1                     50
2             1                     25
3             1                     75

If you need get them out the result should be 1 - 150.
If that´s the case you could use the SUM function:

SQL
Select sum(END_SHARE) from DEEDS


if your START_SHARE = END_SHARE+1 (1-49, 50-74, 75-154 eg) of the previous record you just need to select that last record of the deed containing the shares.
SQL
Select END_SHARE from DEEDS HAVING DEED_NR = max(DEED_NR)  --(not sure if a having works without a group by, but there are other constructs doing similar things.)


hope this gives you an idea.
V.

(MQOTD rules and previous solutions)

AnswerRe: Loading large amount of data with unacceptable time Pin
jschell28-Apr-14 8:16
Memberjschell28-Apr-14 8:16 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:00
MemberAmr Muhammed29-Apr-14 13:00 
GeneralRe: Loading large amount of data with unacceptable time Pin
Mycroft Holmes29-Apr-14 13:06
professionalMycroft Holmes29-Apr-14 13:06 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:12
MemberAmr Muhammed29-Apr-14 13:12 
GeneralRe: Loading large amount of data with unacceptable time Pin
David O'Neil29-Apr-14 13:22
professionalDavid O'Neil29-Apr-14 13:22 
GeneralRe: Loading large amount of data with unacceptable time Pin
jschell29-Apr-14 14:33
Memberjschell29-Apr-14 14:33 
QuestionHow do I pass parameters from one jquery tab to another? Pin
samflex25-Apr-14 17:32
Membersamflex25-Apr-14 17:32 
AnswerRe: How do I pass parameters from one jquery tab to another? Pin
Kornfeld Eliyahu Peter26-Apr-14 23:42
professionalKornfeld Eliyahu Peter26-Apr-14 23:42 
GeneralRe: How do I pass parameters from one jquery tab to another? Pin
samflex27-Apr-14 5:53
Membersamflex27-Apr-14 5:53 
Questionscript to delete related rows without cascade Pin
Nico Haegens25-Apr-14 1:57
professionalNico Haegens25-Apr-14 1:57 
AnswerRe: script to delete related rows without cascade Pin
Mycroft Holmes25-Apr-14 13:16
professionalMycroft Holmes25-Apr-14 13:16 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens25-Apr-14 23:54
professionalNico Haegens25-Apr-14 23:54 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 0:33
professionalMycroft Holmes26-Apr-14 0:33 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens26-Apr-14 4:41
professionalNico Haegens26-Apr-14 4:41 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 13:46
professionalMycroft Holmes26-Apr-14 13:46 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens26-Apr-14 23:12
professionalNico Haegens26-Apr-14 23:12 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes27-Apr-14 12:44
professionalMycroft Holmes27-Apr-14 12:44 

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.