Click here to Skip to main content
12,622,896 members (30,113 online)
   

Database

 
GeneralRe: Database design question Pin
PIEBALDconsult28-Dec-12 15:42
memberPIEBALDconsult28-Dec-12 15:42 
GeneralRe: Database design question Pin
jschell30-Dec-12 9:28
memberjschell30-Dec-12 9:28 
AnswerRe: Database design question Pin
Mycroft Holmes28-Dec-12 12:05
memberMycroft Holmes28-Dec-12 12:05 
QuestionImporting of Huge fixed width text file in sql server table Pin
ibrahim sharief27-Dec-12 10:24
memberibrahim sharief27-Dec-12 10:24 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
PIEBALDconsult27-Dec-12 15:08
memberPIEBALDconsult27-Dec-12 15:08 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
Deepak Kr130-Dec-12 21:29
memberDeepak Kr130-Dec-12 21:29 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
jschell31-Dec-12 10:14
memberjschell31-Dec-12 10:14 
Questionshow Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 7:52
memberhadeed147227-Dec-12 7:52 
Hi
i want to show results something like this...
First row contain the opening balance calculated by this i.e: Sum(Balance)where datefield <= DateByUser
and next rows shows the records between dates given by user & evaluate balance on each row

output should like this..
VchrNo___DrAmnt___CrAmnt___ Balance
00 --------00---------00--------1570
113--------10---------00--------1580
115--------15---------00--------1585
123--------10---------00--------1595
123--------12---------00--------1607
. . . .
. . . .
AnswerRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
djj5527-Dec-12 8:53
memberdjj5527-Dec-12 8:53 
GeneralRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 9:03
memberhadeed147227-Dec-12 9:03 
QuestionSQL BulkCopy using IDataReader - how can you cast the fields? Pin
Allan Watkins26-Dec-12 20:12
memberAllan Watkins26-Dec-12 20:12 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
Mycroft Holmes26-Dec-12 21:32
memberMycroft Holmes26-Dec-12 21:32 
GeneralRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
AllanW1111127-Dec-12 7:02
memberAllanW1111127-Dec-12 7:02 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
PIEBALDconsult27-Dec-12 9:48
memberPIEBALDconsult27-Dec-12 9:48 
QuestionSubquery returns more than 1 row Pin
Jassim Rahma24-Dec-12 2:02
memberJassim Rahma24-Dec-12 2:02 
AnswerRe: Subquery returns more than 1 row Pin
Eddy Vluggen24-Dec-12 2:29
memberEddy Vluggen24-Dec-12 2:29 
AnswerRe: Subquery returns more than 1 row Pin
MaulikDusara24-Dec-12 22:44
memberMaulikDusara24-Dec-12 22:44 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen25-Dec-12 3:41
memberEddy Vluggen25-Dec-12 3:41 
GeneralRe: Subquery returns more than 1 row Pin
Mycroft Holmes26-Dec-12 12:17
memberMycroft Holmes26-Dec-12 12:17 
GeneralRe: Subquery returns more than 1 row Pin
MaulikDusara26-Dec-12 19:45
memberMaulikDusara26-Dec-12 19:45 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen27-Dec-12 5:24
memberEddy Vluggen27-Dec-12 5:24 
QuestionOn the Naming of Columns for Lookup tables. Pin
Brady Kelly17-Dec-12 23:44
memberBrady Kelly17-Dec-12 23:44 
AnswerRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 0:19
memberMycroft Holmes18-Dec-12 0:19 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Brady Kelly18-Dec-12 0:26
memberBrady Kelly18-Dec-12 0:26 
GeneralRe: On the Naming of Columns for Lookup tables. Pin
Mycroft Holmes18-Dec-12 2:11
memberMycroft Holmes18-Dec-12 2:11 

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.


Advertise | Privacy | Mobile
Web01 | 2.8.161128.1 | Last Updated 2 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid