Click here to Skip to main content
15,347,117 members
Home / Discussions / Database
   

Database

 
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
MemberMember 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
MemberAmr Muhammed27-Apr-14 10:30 
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
MemberAmr 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
MemberAmr Muhammed27-Apr-14 19:28 
There is no table for shares. I have only a table for deeds and this table consists of 4 columns (DEED_ID 'identity', DEED_NUMBER, START_SHARE, END_SHARE). For example if we have a deed consists of a 50 shares the values in these columns will be (1, 100, 1, 50) for DEED_ID, DEED_NUMBER, START_SHARE and END_SHARE respectively. What I need is to get all shares numbers, more clearer, if we apply on the above example of a deed of 50 shares starting for share number 1 to share number 50 I need to get the values 1, 2, 3, 4, 5 ..... 50. I need to do that for all deeds I have within my database. So if I have 150,000 deeds each of which consists of 50 shares. then I have 150,000 * 50 = 7500000 shares. I need to get values starting from 1 up to 7500000. I already make a solution by using a cursor for all deeds, getting each deed separately and then getting its start and end share numbers then making a while loop from the start share number to the end share number of that deed, then get the next deed and so on. However, this solution taking a considerable amount of time to load the the shares values and this time is unacceptable.
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 
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 

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.