Posts tagged with sql by inigo2

Related tags:
database + (53)
mysql + (32)
query + (21)
access + (16)
server + (14)
resolved + (14)
programming + (11)
php + (11)
mssql + (6)
databases + (6)
Windows + (6)
sqlserver + (6)
oracle + (5)
Data + (5)
microsoft + (5)
dba + (4)

Users that often use this tag:
DakotaPaul (6)
arrowhead (3)
odinsdream (3)
Glendale (2)
omnipotentq (2)
desjardins (2)
maxwelton (2)
adipocere (2)
bleucube (2)
inigo2 (2)
apark (2)
mark7570 (2)
Wild_Eep (2)
Four Flavors (2)
AllesKlar (2)
derbs (2)
eas98 (2)
benjh (2)
dnash (2)
Nothing (2)

I have a (hopefully easy) SQL question. I'm working in MS Access. Simplifying things a bit, I have a table with a TaskID, and a TaskStatusID. I want to get a list of each TaskID, and the newest TaskStatusID for each. (Details follow.) [more inside]
posted by inigo2 on Apr 21, 2009 - 7 answers

SQL/MS Visual Studio help please! I have two tables. I need to present Table1 data grouped by SiteID, within time FROM and TO, on the report. Then I need to make one calculation on the report using Table 1 data totalled across all sites (and within FROM and TO) plus Table 2 data totalled between times FROM and TO. [more inside]
posted by inigo2 on Sep 10, 2008 - 10 answers