Click here to Skip to main content
15,849,996 members
Home / Discussions / Database
   

Database

 
GeneralRe: NAKRA Pin
kubben29-Jun-07 2:53
kubben29-Jun-07 2:53 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:09
NAKRAINC28-Jun-07 23:09 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:08
NAKRAINC28-Jun-07 23:08 
NewsNAKRA Pin
NAKRAINC28-Jun-07 23:06
NAKRAINC28-Jun-07 23:06 
Questionhow to encrypt whole Database ? Pin
hdv21228-Jun-07 22:51
hdv21228-Jun-07 22:51 
AnswerRe: how to encrypt whole Database ? Pin
originSH29-Jun-07 1:06
originSH29-Jun-07 1:06 
QuestionMerge Replication rights Pin
Sgg24528-Jun-07 21:15
Sgg24528-Jun-07 21:15 
QuestionCritical probs to display records..., Pin
Member 387988128-Jun-07 19:02
Member 387988128-Jun-07 19:02 
Hi i think this is critical probs...,
But i think some solution will be there..,
If u know plz clear to me...,

I have one table like...,
Id s1 s2 s3 s4 s5
1 100 200 0 0 0
2 400 0 100 0 150
3 500 150 <null> 50 0
...................
...................

Like this i have records in my table...,
Now my question is, i want to show my record...,
what are the fields have values those only...,
Suppose if i like to show my 2nd record...,
I want to show the records like...,

Id s1 s3 s5
2 400 100 150 only...,

Suppose if i like to show my 3rd record...,
The query want to display like...,

Id s1 s2 s4
3 500 150 50

Means what are the fields have 0 or null values those records dont want to display...,
Using stored procedure or query anything if its possible plz tell me...,
Advance Thanks,



Regards,
Magi

AnswerRe: Critical probs to display records..., Pin
Devkranth Kishore Vanja28-Jun-07 21:24
Devkranth Kishore Vanja28-Jun-07 21:24 
GeneralRe: Critical probs to display records..., Pin
Member 387988128-Jun-07 21:57
Member 387988128-Jun-07 21:57 
AnswerRe: Critical probs to display records..., Pin
Navneet Hegde29-Jun-07 4:34
Navneet Hegde29-Jun-07 4:34 
QuestionParamaterized Queries vs. Stored Procedures Pin
martin_hughes28-Jun-07 9:17
martin_hughes28-Jun-07 9:17 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
kubben28-Jun-07 10:09
kubben28-Jun-07 10:09 
AnswerRe: Paramaterized Queries vs. Stored Procedures [modified] Pin
Mike Dimmick28-Jun-07 10:22
Mike Dimmick28-Jun-07 10:22 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:34
martin_hughes29-Jun-07 2:34 
AnswerRe: Paramaterized Queries vs. Stored Procedures Pin
originSH29-Jun-07 1:11
originSH29-Jun-07 1:11 
GeneralRe: Paramaterized Queries vs. Stored Procedures Pin
martin_hughes29-Jun-07 2:32
martin_hughes29-Jun-07 2:32 
QuestionView more than one page with CrystalReportViewer vb.net Pin
kindman_nb28-Jun-07 6:09
kindman_nb28-Jun-07 6:09 
QuestionAlternative of CONVERT function in MS Access Pin
FishiFishi28-Jun-07 4:12
FishiFishi28-Jun-07 4:12 
AnswerRe: Alternative of CONVERT function in MS Access Pin
leckey28-Jun-07 5:20
leckey28-Jun-07 5:20 
Questiondatetime code Pin
niki_nilu28-Jun-07 2:56
niki_nilu28-Jun-07 2:56 
AnswerRe: datetime code Pin
Sathesh Sakthivel28-Jun-07 3:22
Sathesh Sakthivel28-Jun-07 3:22 
Questiondatetime problem Pin
niki_nilu28-Jun-07 1:54
niki_nilu28-Jun-07 1:54 
AnswerRe: datetime problem Pin
Krish - KP28-Jun-07 2:30
Krish - KP28-Jun-07 2:30 
GeneralRe: datetime problem Pin
FishiFishi28-Jun-07 4:16
FishiFishi28-Jun-07 4:16 

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.