select the 2 rows having max date: TSQL pretty much writees the same way the question was outlined:

if there are two records with the same max date:

SELECT TOP 2 *...

Your example below was what I expected;

project is at the top of the data pyramid, but The grouping on the query looks ok to me;

so....how is are the numbers...

INSERT is a reserved word...I think you have a column named INSERT

change the column name or wrap it in brackets or dbl quotes:

[INSERT]

or "INSERT"

can you tell us why the numbers are "wrong"? grouping to get totals is pretty straight forward;

i don't think it makes a difference, but your first table is THardware, is...

i suspect the issue is you used all INNER Joins...that means ther MUST be data in all 5 tables for every project....intuitively, for example, i doubt every project has travel...

if it helps, this article, because it has screenshots, let me set up a full text on one of my tables in about a minute:

http://www.userscape.com/helpdesk/index.php?pg=kb.page&id=142

yeah i think this is a situation where you just have to jump right in with full text indexing. what you need is exactly what it was designed for, and...

for others reading brd's issue, we kind of kicked around searching via CHARINDEX on the same issue here:

needing to develop a sql search for all words,...

obviously, that would cost a...

they don't really get executed first or second.... it's more like ALL constraints, including whether a column is nullable or not, all get evaluated prior to the the insert or...

hmmm... thinking about it, i think you have to test the count > 1 and EXCLUDE those indexes istead;

a table with no rows simply will not return results in the...

Marios Philippopoulos (4/20/2009)

---

I need a script that will list all indexes in a database that SHOULD be defined as UNIQUE (based on the data distribution) but are not.

Does anyone have...

well the db will not get smaller... a db stays at a certain size in order to save space for future work...but the space used/space free will change.

run sp_spaceused on...

you cannot do this.

a query with a group by does not expose data so it can be updated.

you must...

i read up on RamSAN thanks to you guys;

I'm jealous, quite frankly.

seems to be faster than a bat outta...well

but it's not a cheap solution either. that's some big money to...

does truncating force a rebuild(resetting?) on statistics if auto-update statistics is ON?

i know there is a threshold of 20% rows changed before the auto update occurs, but since truncate...