Database

TheJudeDude wrote:

when I dragged and dropped an OleDbCommand on the form:

OleDbCommand cmd = new OleDbCommand("UPDATE tables SET Subtotal = ? WHERE (TableNumber = ?)", connectionString);
cmd.Parameters.Add("@Subtotal", OleDbType.Single, 4).Value = decSubtotal;
cmd.Parameters.Add("@TableNumber", OleDbType.Char, 10).Value = strTable;

erdsah88 wrote:

The most denormalized thing ever. is this the fastest way we can get in reporting?

Colin Angus Mackay wrote:

Reporting databases tend to be denormalised because what is efficient for reporting is the complete opposite to what is efficient for OLTP.

john john mackey wrote:

Can you help? Should I just revert to coding up a "Recordset"?

GROUP BY datepart(year, POI_Time), datepart(month, POI_Time)

TRANSFORM Count(*) AS TotalByPartType
SELECT tbl_MainReportInfo.POI_Time
FROM tbl_MainReportInfo
GROUP BY DatePart("m",tbl_MainReportInfo.POI_Time)
ORDER BY tbl_MainReportInfo.POI_Time
PIVOT tbl_MainReportInfo.PartType;

SELECT h.Horse_Name, r.Rider_Name, s.Rider_NF 
FROM Stables AS s
INNER JOIN Horses AS h ON h.Id = s.IdHorses
INNER JOIN Riders AS r on r.Id = s.IdRiders
ORDER BY s.Rider_NF

gharry wrote:

But still one question remains, if a Rider_NF is not on the Country table it should be on the list, ?use a other type of join

kenn_rosie wrote:

What is a named variable and why use it?

SELECT TOP 10
    Customers.customerid,
    Customers.customername,
    Log.LastModified
FROM
    Customers
INNER JOIN
    (SELECT customerId, Max(dateModified) AS LastModified
     FROM CustomerLogs
     GROUP BY customerId) as Log
    ON (Customers.customerId = Log.customerId)
ORDER BY LastModified DESC

SELECT Type,Balance,Category
FROM Account
ORDER BY (CASE WHEN Category ="Current Assets" THEN 1
          ELSE WHEN Category = 'Net Property and Equipment'THEN 2
          ELSE WHEN Category ='Non current Assets' THEN 3
          ELSE WHEN Category ='Current Libality' THEN 4
          ELSE WHEN Category = Long Term Liablities'THEN 5
          ELSE WHEN Category = 'Equity' THEN 6
          ELSE WHEN Category = 'Sales' THEN 7
          ELSE WHEN Category ='Cost of Sales' THEN 8
          ELSE 0 END);