Click here to Skip to main content
15,920,383 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to concatenate all columnB where columnA are the same? USING SQL 200 Pin
coolestCoder7-Dec-07 4:00
coolestCoder7-Dec-07 4:00 
QuestionIs this a viable stored procedure? Pin
Ranger495-Dec-07 2:27
Ranger495-Dec-07 2:27 
AnswerRe: Is this a viable stored procedure? Pin
pmarfleet5-Dec-07 3:18
pmarfleet5-Dec-07 3:18 
GeneralRe: Is this a viable stored procedure? Pin
Ranger495-Dec-07 5:38
Ranger495-Dec-07 5:38 
GeneralRe: Is this a viable stored procedure? Pin
Pete O'Hanlon5-Dec-07 10:41
mvePete O'Hanlon5-Dec-07 10:41 
QuestionConnecting from VB.NET to an online mySQL server? Pin
Benny_Lava5-Dec-07 1:54
Benny_Lava5-Dec-07 1:54 
AnswerRe: Connecting from VB.NET to an online mySQL server? Pin
Pete O'Hanlon5-Dec-07 10:44
mvePete O'Hanlon5-Dec-07 10:44 
Generaldatabase design Pin
avvaru.murali5-Dec-07 1:35
avvaru.murali5-Dec-07 1:35 
Hi,
Thanks for your reply...

my problem is
iam using (MS-Access) database


ihave to store multiple items in one invoice number(primary)

ihave to design table like below format...

invoiceno items units
1 nokia1600 2
nokia6600 3
nokia6633 4
2 nokia1600 2
nokia1400 3
nokia1500 6
3 nokia1800 5
nokia1900 6




like this ....(database design) and coding in c# application

murali krishna

GeneralRe: database design Pin
coolestCoder5-Dec-07 4:13
coolestCoder5-Dec-07 4:13 
Generaldatabase design Pin
avvaru.murali5-Dec-07 1:22
avvaru.murali5-Dec-07 1:22 
GeneralRe: database design Pin
Ujjaval Modi5-Dec-07 1:29
Ujjaval Modi5-Dec-07 1:29 
GeneralRe: database design Pin
avvaru.murali5-Dec-07 1:32
avvaru.murali5-Dec-07 1:32 
GeneralRe: database design Pin
Ujjaval Modi5-Dec-07 1:39
Ujjaval Modi5-Dec-07 1:39 
GeneralRe: database design Pin
avvaru.murali5-Dec-07 1:42
avvaru.murali5-Dec-07 1:42 
GeneralRe: database design Pin
Ujjaval Modi5-Dec-07 1:44
Ujjaval Modi5-Dec-07 1:44 
GeneralRe: database design Pin
avvaru.murali5-Dec-07 1:48
avvaru.murali5-Dec-07 1:48 
GeneralRe: database design [modified] Pin
Eric.W28-Dec-07 15:45
Eric.W28-Dec-07 15:45 
GeneralWhy sql query is not running...? in MSACCESS 2000 Pin
Pankaj - Joshi5-Dec-07 0:02
Pankaj - Joshi5-Dec-07 0:02 
GeneralRe: Why sql query is not running...? in MSACCESS 2000 Pin
GuyThiebaut5-Dec-07 0:57
professionalGuyThiebaut5-Dec-07 0:57 
GeneralRe: Why sql query is not running...? in MSACCESS 2000 Pin
Pankaj - Joshi5-Dec-07 1:12
Pankaj - Joshi5-Dec-07 1:12 
GeneralRe: Why sql query is not running...? in MSACCESS 2000 Pin
Support1235-Dec-07 1:28
Support1235-Dec-07 1:28 
GeneralRe: Why sql query is not running...? in MSACCESS 2000 Pin
Pankaj - Joshi5-Dec-07 16:44
Pankaj - Joshi5-Dec-07 16:44 
QuestionHow to find the sql servers on network [modified] Pin
aswini4-Dec-07 20:41
aswini4-Dec-07 20:41 
AnswerRe: How to find the sql servers on network PinPopular
Rajesh R Subramanian4-Dec-07 20:48
professionalRajesh R Subramanian4-Dec-07 20:48 
GeneralRe: How to find the sql servers on network Pin
Vasudevan Deepak Kumar4-Dec-07 21:25
Vasudevan Deepak Kumar4-Dec-07 21:25 

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.