that's the point...when a view is updatable, if you update the view, you are really updating the tables underneath the view.

the view is just a stored select statement, but as...

the view itself may be updatable...

UPDATE MYVIEW SET ContactName='Bob' Where ContactId=1 And ContactName='BOBBY'

can you tell us if that works? it really depends on the view...

you cannot do that;

While some programs, like SQLPlus for Oracle, interpret certain commands to change the connection or to direct the input to a file, SSMS and Query Analyzer only...

peace2007 here is what i use.

it is a stored procedure i wrote, which creates a trace.

It creates a trace and a view in the MASTER database; it includes a...

fairly straight forward. You need to take advantage of the OUTPUT command. this simple functionality kicks butt when playing with more than one row.

build a temp table to catch the...

since you are just setting the ReportId to a string plus the autoid, you could make the column a calculated field and be done with it:

Alter Table TestingWork ADD NewReportId...

kewl; once you post the actual functions, we'll be able to help; offhand, it looks like it could be replaced with a view that joins all your columns with joins...

need more detail;

is there 24 different formulas, one for each column in your customer table, or is it the same calculation, but placed in 24 functions? show us two of...

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...