Database

paul4everyone wrote:

I tried using a CROSS JOIN but the errors thrown shows that i am not formulating
the query properly at all.

(Select Max(Transaction_Date) From ThriftsTrans Where Transaction_Date 
Between '15/Dec/2013' And '18/Dec/2013' Group By Customer_ID)

Select Customer, Count, Credit, Debit, Balance, Date from
(
Select Customer_ID as Customer, (count(Credit) + count(Debit)) as Count, sum(Credit) as Credit, sum(Debit) as Debit
from ThriftsTrans Where Transaction_Date Between '15/Dec/2013' And '18/Dec/2013' Group By Customer_ID
) as a left join (
Select Customer_ID as Cust, Account_Balance as Balance, 
Transaction_Date as Date From ThriftsTrans Where Transaction_Date In 
(Select Max(Transaction_Date) From ThriftsTrans Where Transaction_Date 
Between '15/Dec/2013' And '18/Dec/2013' Group By Customer_ID)
) as b on a.Customer = b.Cust

select *
from table
where ((@endDate is null) or (enddate = @enddate)) and
      ((@deptid is null) or (deptid = @deptid)) and
      ((@employeeName is null) or (employeeName = @employeeName))

Jörgen Andersson wrote:

(DateTime)reader["MyDateTimeColumn"]; will convert the DateTime from the DB into a string and then convert it back to DateTime