Click here to Skip to main content
16,017,325 members
Home / Discussions / Database
   

Database

 
QuestionNot in for two columns with Inner join Pin
indian1432-May-14 9:18
indian1432-May-14 9:18 
AnswerRe: Not in for two columns with Inner join Pin
Mycroft Holmes2-May-14 13:04
professionalMycroft Holmes2-May-14 13:04 
Questionhow to join all three query results to one in mysql Pin
sr15930-Apr-14 23:01
sr15930-Apr-14 23:01 
AnswerRe: how to join all three query results to one in mysql Pin
Simon_Whale30-Apr-14 23:12
Simon_Whale30-Apr-14 23:12 
GeneralRe: how to join all three query results to one in mysql Pin
sr1591-May-14 5:34
sr1591-May-14 5:34 
Questionhow to fetch a table column of same name of more than 4 different database in sql server 2008r2??? Pin
Member 1078495429-Apr-14 20:24
Member 1078495429-Apr-14 20:24 
AnswerRe: how to fetch a table column of same name of more than 4 different database in sql server 2008r2??? Pin
Kornfeld Eliyahu Peter29-Apr-14 21:22
professionalKornfeld Eliyahu Peter29-Apr-14 21:22 
QuestionLoading large amount of data with unacceptable time Pin
Amr Muhammed27-Apr-14 10:30
Amr Muhammed27-Apr-14 10:30 
I'm working on an application for a joint-stock company.

A joint-stock company is a business entity which is owned by shareholders. Each shareholder owns the portion of the company in proportion to his or her ownership of the company's shares (certificates of ownership). This allows for the unequal ownership of a business with some shareholders owning a larger proportion of a company than others. Shareholders are able to transfer their shares to others without any effects to the continued existence of the company.

Shares are collected in a form of a deed. A deed has classes like a deed of 50, a deed of 40 and so on.
50 and 40 means that a deed consists of 50 shares, 40 shares and so on.

A joint-stock company may have a 1000 shares that are distributed in the form of deeds. each deed has a start share number and an end share number for example lets take a deed of 50 shares so its shares will start from share no. 1 to share no. 50.

Within the database of the company there is a table to store the information of each deed

DEED (DEED_NUMBER, START_SHARE, END_SHARE) if we use the previous example of deed of 50 and lets say that the deed number is 100. So the data will become 100 for DEED_NUMBER, 1 for START_SHARE, and 50 for END_SHARE.

What I need is to get all the numbers between 1 and 50 and this will be applied to all the deeds. So if I had a 1000 shares distributed in deeds I need to get the numbers 1, 2, 3, 4, .... 1000.

I already used a cursor to make such solution through looping on all deeds one at a time getting its start share number and its end share number and get all the numbers between them. However, this solution taking too much time and with a company like the one I'm working on having more than 100,000 to 150,000 deeds the time my solution takes to retrieve shares numbers is unbearable and unacceptable.

Thanks for any help and I'm sorry for long post I just wanted to explain what is the mean of joint-stock company so people know what I want.
AnswerRe: Loading large amount of data with unacceptable time Pin
David O'Neil27-Apr-14 11:17
professionalDavid O'Neil27-Apr-14 11:17 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed27-Apr-14 11:32
Amr Muhammed27-Apr-14 11:32 
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
Amr 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
Amr 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
Amr 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 
AnswerRe: Loading large amount of data with unacceptable time Pin
jschell28-Apr-14 8:16
jschell28-Apr-14 8:16 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:00
Amr 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
Amr 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
jschell29-Apr-14 14:33 
QuestionHow do I pass parameters from one jquery tab to another? Pin
samflex25-Apr-14 17:32
samflex25-Apr-14 17:32 

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.