Click here to Skip to main content
15,500,227 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
leoinfo16-Jul-08 5:39
Memberleoinfo16-Jul-08 5:39 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 5:56
Memberfracalifa16-Jul-08 5:56 
QuestionHow to Make Application to Sync on Remote Site Pin
Nassoro Ally16-Jul-08 1:39
MemberNassoro Ally16-Jul-08 1:39 
QuestionReports are not visible on client machine Pin
meetaqadir15-Jul-08 21:54
Membermeetaqadir15-Jul-08 21:54 
QuestionOLEDB with Excel problem Pin
acroitoriu15-Jul-08 21:52
Memberacroitoriu15-Jul-08 21:52 
AnswerRe: OLEDB with Excel problem Pin
acroitoriu15-Jul-08 22:23
Memberacroitoriu15-Jul-08 22:23 
Questionfacing probs in nested cursor Pin
Member 387988115-Jul-08 20:56
MemberMember 387988115-Jul-08 20:56 
AnswerRe: facing probs in nested cursor Pin
Alsvha16-Jul-08 0:28
MemberAlsvha16-Jul-08 0:28 
I have trouble understanding your question so I can't provide much actual help; however looking at the query one thing puzzles me.

Why do you have similar selects both outside your "WHILE" loops as well as inside? To me it looks like it will cause problems with the loop over FETCH NEXT.
Removing duplicate functionality could help you reduce the complexity of your query making it more manageable, and it could possible be from those double selects that your problems arise.


Questionbytes retrieval Pin
vicki52815-Jul-08 19:19
Membervicki52815-Jul-08 19:19 
AnswerRe: bytes retrieval Pin
Alsvha16-Jul-08 0:28
MemberAlsvha16-Jul-08 0:28 
QuestionHow do i convert a varchar field into the datetime data type Pin
Rameez Raja15-Jul-08 19:12
MemberRameez Raja15-Jul-08 19:12 
AnswerRe: How do i convert a varchar field into the datetime data type Pin
Alsvha16-Jul-08 0:31
MemberAlsvha16-Jul-08 0:31 
QuestionDATABASE CONNECTIVITY Pin
murphy7715-Jul-08 16:58
Membermurphy7715-Jul-08 16:58 
AnswerRe: DATABASE CONNECTIVITY Pin
Ashfield15-Jul-08 22:45
MemberAshfield15-Jul-08 22:45 
QuestionConnecting to an ODBC DataSource Pin
ffowler15-Jul-08 15:17
Memberffowler15-Jul-08 15:17 
QuestionDatabase Publishing Wizard alternatives Pin
Todd Smith15-Jul-08 10:15
MemberTodd Smith15-Jul-08 10:15 
AnswerRe: Database Publishing Wizard alternatives Pin
Alsvha16-Jul-08 0:34
MemberAlsvha16-Jul-08 0:34 
Questionautomatica fire event Pin
Member 387988115-Jul-08 5:12
MemberMember 387988115-Jul-08 5:12 
AnswerRe: automatica fire event Pin
Mark J. Miller15-Jul-08 8:07
MemberMark J. Miller15-Jul-08 8:07 
QuestionHow to make subreport display based on data Pin
imranafsari15-Jul-08 2:25
Memberimranafsari15-Jul-08 2:25 
AnswerRe: How to make subreport display based on data Pin
TheFM23415-Jul-08 6:33
MemberTheFM23415-Jul-08 6:33 
QuestionResetting Identity Column in oracle Pin
meeram39515-Jul-08 0:45
Membermeeram39515-Jul-08 0:45 
AnswerRe: Resetting Identity Column in oracle Pin
scottgp15-Jul-08 4:58
professionalscottgp15-Jul-08 4:58 
QuestionConfigure SQL 2005 For Remote Connection Pin
swjam15-Jul-08 0:43
Memberswjam15-Jul-08 0:43 
AnswerRe: Configure SQL 2005 For Remote Connection Pin
Tim Leung15-Jul-08 1:30
MemberTim Leung15-Jul-08 1:30 

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.