Click here to Skip to main content
15,394,785 members
Home / Discussions / Database
   

Database

 
GeneralRe: Performance issue Pin
Albu Marius11-Oct-07 6:31
MemberAlbu Marius11-Oct-07 6:31 
Questionhow to block ? Pin
ahmed eldeghedy11-Oct-07 2:58
professionalahmed eldeghedy11-Oct-07 2:58 
AnswerRe: how to block ? Pin
Colin Angus Mackay11-Oct-07 3:42
MemberColin Angus Mackay11-Oct-07 3:42 
GeneralRe: how to block ? Pin
Paul Conrad12-Oct-07 12:04
professionalPaul Conrad12-Oct-07 12:04 
AnswerRe: how to block ? Pin
Colin Angus Mackay11-Oct-07 7:00
MemberColin Angus Mackay11-Oct-07 7:00 
GeneralRe: how to block ? Pin
Paul Conrad12-Oct-07 12:05
professionalPaul Conrad12-Oct-07 12:05 
QuestionCopy Information Pin
Sarfaraj Ahmed11-Oct-07 0:58
MemberSarfaraj Ahmed11-Oct-07 0:58 
AnswerRe: Copy Information Pin
pmarfleet11-Oct-07 2:00
Memberpmarfleet11-Oct-07 2:00 
You could add another column to CopyBooks called CopyID. This would be a sequence no. uniquely identifying a copy of each book. For example:

ISBN CopyID Book_ID
1001 101    1001101
1001 102    1001102
1001 103    1001103
1002 101    1002101
1002 102    1002102
1002 103    1002103
1002 104    1002104


Book_ID could then be changed to a computed column using the formula (CONVERT([varchar],[ISBN],0)+CONVERT([varchar],[CopyID],0)).

To find the next CopyID for a particular ISBN, all you have to do is find the current highest CopyID for that ISBN and add 1.

Paul Marfleet

GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 3:19
MemberSarfaraj Ahmed11-Oct-07 3:19 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 8:59
Memberpmarfleet11-Oct-07 8:59 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 3:55
MemberSarfaraj Ahmed11-Oct-07 3:55 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 9:00
Memberpmarfleet11-Oct-07 9:00 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 15:09
MemberSarfaraj Ahmed11-Oct-07 15:09 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 21:39
Memberpmarfleet11-Oct-07 21:39 
Questionupdate database(urgently) Pin
Milind Panchal10-Oct-07 22:51
MemberMilind Panchal10-Oct-07 22:51 
AnswerRe: update database(urgently) Pin
N a v a n e e t h10-Oct-07 23:09
MemberN a v a n e e t h10-Oct-07 23:09 
AnswerRe: update database(urgently) Pin
Rob Philpott11-Oct-07 4:46
MemberRob Philpott11-Oct-07 4:46 
Questionis the order of parameters addition to a command for update command realy required? Pin
nicolus10-Oct-07 20:23
Membernicolus10-Oct-07 20:23 
AnswerRe: is the order of parameters addition to a command for update command realy required? Pin
John Gathogo11-Oct-07 4:54
MemberJohn Gathogo11-Oct-07 4:54 
QuestionComplex Query Pin
Aavesh Agarwal10-Oct-07 20:21
MemberAavesh Agarwal10-Oct-07 20:21 
AnswerRe: Complex Query Pin
_Damian S_10-Oct-07 20:50
professional_Damian S_10-Oct-07 20:50 
GeneralRe: Complex Query Pin
Aavesh Agarwal10-Oct-07 21:03
MemberAavesh Agarwal10-Oct-07 21:03 
GeneralRe: Complex Query Pin
Rob Philpott11-Oct-07 4:40
MemberRob Philpott11-Oct-07 4:40 
QuestionHow to use Form Authentication in SSRS Pin
krishbasu10-Oct-07 19:47
Memberkrishbasu10-Oct-07 19:47 
Questionwhile poop in stored procedure Pin
Sonia Gupta10-Oct-07 18:47
MemberSonia Gupta10-Oct-07 18:47 

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.