Click here to Skip to main content
15,905,563 members
Home / Discussions / Database
   

Database

 
GeneralRe: Partial update via OleDBDataAdaptor Pin
Dave Kreskowiak27-Jun-07 5:55
mveDave Kreskowiak27-Jun-07 5:55 
QuestionI want to secure my DB Pin
merwa27-Jun-07 2:35
merwa27-Jun-07 2:35 
AnswerRe: I want to secure my DB Pin
Vasudevan Deepak Kumar27-Jun-07 2:47
Vasudevan Deepak Kumar27-Jun-07 2:47 
QuestionSQL Server 2000 mirror Database Pin
AcDev727-Jun-07 1:01
AcDev727-Jun-07 1:01 
AnswerRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 2:24
Mike Dimmick27-Jun-07 2:24 
GeneralRe: SQL Server 2000 mirror Database Pin
Colin Angus Mackay27-Jun-07 12:19
Colin Angus Mackay27-Jun-07 12:19 
GeneralRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 23:30
Mike Dimmick27-Jun-07 23:30 
QuestionStored procedure Pin
sidbaruah26-Jun-07 23:36
sidbaruah26-Jun-07 23:36 
Hi friends!!!
I have a table where i have a set of tutor ids and the relevant points they get according to a student.

table is like
student_name // tutor1_id // points // tutor2_id // points ....
john // 101 // 4 // 102 // 5
jacob // 102 // 3 // 105 // 4

and another table

tutor_id // tutor_name
101 ron
102 reid
103 abc
...


I need to show the points the tutor name and the student name together with a join among the two tables..

Right now i am using union operator for getting all the records
Is there any other method how i can get all the details together

Thanks for your time...

I was born dumb!!
Laugh | :laugh: Programming made me laughLaugh | :laugh: !!!
--sid--

AnswerRe: Stored procedure Pin
mamatha_raghu27-Jun-07 0:17
mamatha_raghu27-Jun-07 0:17 
AnswerRe: Stored procedure Pin
Pratik Vasant Shah27-Jun-07 19:44
Pratik Vasant Shah27-Jun-07 19:44 
Questionmysql input with stored procedure help Pin
boyindie26-Jun-07 23:20
boyindie26-Jun-07 23:20 
AnswerRe: mysql input with stored procedure help Pin
Devkranth Kishore Vanja28-Jun-07 20:42
Devkranth Kishore Vanja28-Jun-07 20:42 
GeneralRe: mysql input with stored procedure help Pin
boyindie28-Jun-07 21:48
boyindie28-Jun-07 21:48 
Questionsharing sql server without client installation Pin
mamatha_raghu26-Jun-07 20:41
mamatha_raghu26-Jun-07 20:41 
AnswerRe: sharing sql server without client installation Pin
Manas Bhardwaj26-Jun-07 22:24
professionalManas Bhardwaj26-Jun-07 22:24 
AnswerRe: sharing sql server without client installation Pin
originSH26-Jun-07 22:29
originSH26-Jun-07 22:29 
GeneralRe: sharing sql server without client installation Pin
mamatha_raghu27-Jun-07 0:06
mamatha_raghu27-Jun-07 0:06 
GeneralRe: sharing sql server without client installation Pin
originSH27-Jun-07 1:06
originSH27-Jun-07 1:06 
AnswerRe: sharing sql server without client installation Pin
Mike Dimmick27-Jun-07 2:46
Mike Dimmick27-Jun-07 2:46 
QuestionSequence of events/methods execuion in SSIS Pin
I.explore.code26-Jun-07 19:57
I.explore.code26-Jun-07 19:57 
Questionpull subscriptions Pin
SVb.net26-Jun-07 12:58
SVb.net26-Jun-07 12:58 
QuestionDatabase design for exam system? Pin
HinJinShah26-Jun-07 8:08
HinJinShah26-Jun-07 8:08 
AnswerRe: Database design for exam system? Pin
Ashiq Shaikh26-Jun-07 22:56
professionalAshiq Shaikh26-Jun-07 22:56 
GeneralRe: Database design for exam system? Pin
HinJinShah27-Jun-07 6:31
HinJinShah27-Jun-07 6:31 
QuestionProblem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 4:54
Dan Neely26-Jun-07 4: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.