Code:
----------------------------------- CaseId | User | Timestamp ----------------------------------- 1 | 1 | 01/26/2011 2 | 3 | 03/12/2011 3 | 2 | 03/20/2011 4 | 1 | 04/16/2011 5 | 3 | 05/17/2011 6 | 1 | 05/06/2011 7 | 1 | 08/18/2011
9 results in 0.0014 seconds.
-
How can I do a "Grouped TOP 1"?
I dont know how to do this, given this table:
What I need to do... -
How to group data read from a file?
hi,
assuming i have a file that contains below data:
cell Bit
0 1
1 X
2 1
3 0
4 X
5 X
6 X
7 X
8 1
9 X
10 0
11 0
12 X
13 X
14 1
15 1
how can i group every 4 bits into a row? for eg:
ROW1=01X1
ROW2=XXXX
ROW3=00X1
ROW4=11XX
... -
How to overcome a deadlock in Admin privilege
I created a MS access database.
I had then created a Workgroup Information File using Tools->Security->Workgroup Administrator.
I created a password for my used id('kanagab' which is same as my windows logon id) and was using the db.
The user id 'kanagab' was a member of 'Admins' Group and 'Users' group
There was another user called 'admin' which was ONLY a member of 'Users' group (This is what has mislead... -
Ranking Query Is Too Large
I've got a ranking query that ranks the performance of teams in challenges.
The hierarchy of data is as follows:
teams have members
members have activities
activities have activitytypes
challenges have activitytypes
If I want to rank the performance all teams in a single challenge, this query works great:
...Code:SELECT t.teamID, t.teamName, scoring.challengeID, outerchallenge.name
-
Latest Date in a group function
I have a table that looks like this:
CustomerID ProductOrdered OrderDate OrderQuantity
0001 ProdA 1/1/2007 3
0001 ProdA 1/1/2008 2
0002 ProdB 1/1/2006 1
I'm only interested the LATEST order of each customer. I'm trying to use SELECT TOP, but somehow it doesn't work with Group function:
...Code:SELECT TOP 1 CustomerID,ProductOrdered,OrderQuantity,
-
Date difference records
I have a table called Customers, This table has CustomerName, Order, and Order Date:
Customer1 Order A 1/1/2006
Order B 1/6/2006
Order C 1/1/2009
Customer2 Order A 1/1/2007
Order B 1/1/2010
Order C 1/6/2010
We are not interested in records that their Order... -
Using infragistics, is it possible to group columns in excel using c# ?
So far, I have been researching and Microsoft.Offic e.Excel namespace is used alot, unfortunately with my work I have been ordered to use infragistics and so far I have had no luck with finding any function that can group columns together, does anyone know of any function or specific way of grouping columns? Just in case anyone misunderstands I mean grouping in the sense that you have a button or something visible there for you to have the choice... -
sql query groups and min value
Hi,
got a problem formulating sql query.
I got a table with datetime column and a double(float) column.
I set datetime interval, then the interval gets broken down to n equal timespans, then i select the minimum value row from interval.
end result is n rows with minimum double value, one each from each timespan..
any ideas??
with regards
Fr. -
Ms Access Help with Union & transposing data
Hi Guys,
I am a newbee to Bytes currently working on an MS Access database for one of my clients:
With respect, I'll get right to it:
I have 2 tables:
Table 1. TblTrip_Facts
Route Name , FactTypeId ,CustomerName ,RouteType
AISX1-0103 , 0 , TTMA , DEDICATED
AISX1-0104 , 0 , TTMA , DEDICATED
...
