No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi Guys , i have faced a sql command problem. That is currently i have 2 different table [ICODE]a) Select ID, Name from Table1 where ID >=1 and ID ID <=3 ID | Name 1 | Alan 2 | Amy 3 | Andrew [/ICODE] [ICODE]b) Select ID,Sum(Points) as [Total] from …
|
|
|
I experiencing problem in executing query on between date command. I got wrong result. [CODE]SELECT approval_date FROM itemdetail WHERE approval_date BETWEEN '01/01/2011' AND '15/01/2011'[/CODE] My Record in Mysql Database: |Approval Date| 05/01/2011 10/12/2010 12/12/2010 15/12/2010 10/01/2011 |Result| Like above Need result |Approval Date| 05/01/2011 10/10/2011 Anyone could help me. how …
|
|
|
Dear all. I need help regarding on my error.. this is the sample code: [CODE] Private Sub GetDetails(ByVal id As String) Dim conString As String = (ConfigurationManager.ConnectionStrings.Item("ItemListing").ToString) Dim objConnection As New MySqlConnection(conString) objConnection.Open() Dim sdr As MySqlDataReader Dim sSQL As String = " SELECT i.SuppCode,s.SuppName,s.telno,s.Faxno,s.email,s.Salesman,s.Mobileno,s.add1," & _ " i.masterefno, i.invoicerefno,a.remarks, …
|
|
|
1.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.Description,pos_cashreceiptpayment.ReceiptNo,SUM(TotalCost) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.Description LIKE 'Raw%' AND pos_cashreceiptdetail.LocationCode = pos_cashreceiptpayment.LocationCode AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' GROUP BY pos_cashreceiptpayment.ReceiptDate,pos_cashreceiptdetail.ReceiptNo[/CODE] 2.[CODE]SELECT pos_cashreceiptdetail.LocationCode,pos_cashreceiptpayment.TerminalCode,pos_cashreceiptpayment.ReceiptDate, pos_cashreceiptdetail.ShortDescription,pos_cashreceiptpayment.ReceiptNo,SUM(Totalprice) FROM pos_cashreceiptdetail,pos_cashreceiptpayment WHERE pos_cashreceiptdetail.ShortDescription LIKE 'Food Stall%' AND pos_cashreceiptdetail.ReceiptDate = pos_cashreceiptpayment.ReceiptDate AND pos_cashreceiptdetail.ReceiptNo = pos_cashreceiptpayment.ReceiptNo AND pos_cashreceiptdetail.ReceiptDate BETWEEN '2010-10-06' AND '2010-10-20' … 
|