Hence, since SQL cannot store dates with a finer granularity than 3ms, the day ends at 23:59:59.997

Other times which can be stored correctly include 23:59:59.993 and 23:59:59.990.

I don't know what decode does, and I don't know exactly what you're trying to do, but have a look at the following and see if it helps.

SELECT job,

 sum(CASE...

Thanks, that's good to know. This is the first time I'm working with xml in SQL. Haven't touched xml since I was doing webdev some years back.

Agreed, name and...

I posted an example:

<FilterString><Sender /><OurReference /><Reference>PT21   </Reference><Direction /><Type /><Host /></FilterString>

Another example:

<FilterString><Status /><Sender /><Reference /><AccountNo /><DateFrom>2005-09-01</DateFrom><DateTo>2005-09-28</DateTo></FilterString>

It's the way the front end passes an array of parameters to SQL, so the only...

Can't drop the xml, short of rewriting the entire front end app (which isn't an option) and large portions of the back-end code

Basically (and very simplified), the front-end app calls...

Server: Msg 157, Level 15, State 1, Line 2

An aggregate may not appear in the set list of an UPDATE statement.

I thought of that first too, but a quick test...

only 15? I've got 978

Add the roles db_datareader and db_datawriter to the login faelogin. That will automatically grant them rights to read...

Update POSumTable

set ProductTotal = SumOfAmount,

     DiscountTotal = SumOfDiscount,

     TaxTotal = SumOfTax

FROM (SELECT POno, sum(b.Productamt) AS SumOfAmount, sum(b.DiscountAmt) AS SumOfDiscount, sum(b.TaxAmount) AS SumOfTax

   FROM ItemTable

   GROUP BY PONo

   ) SumOfProducts

WHERE SumOfProducts.POno =...

If you absolutely must use a cursor (which is completely unnecesary in this case, and in most cases where people use them) then al least dclare it with sensible options.

DECLARE...

By percentage, do you mean the percentage of records that have 1, 2 or 3 in them? If so, this should work. If not, please post example data and required...

Easiest is to do it in two steps

UPDATE Table2 SET Description='LightBrown', code='lb' WHERE Description IN ('tan','beige')

Then to remove duplicates

DELETE FROM Table2 WHERE ID NOT IN

   (SELECT MIN(ID) FROM Table2

    ...

A few points...

LEN(...) will always do a rtrim before it calculates the length. It's how the function works. If you retrieve the data you will see that the space is...

AFTER and FOR are synonyms of each other. They create the same trigger. The only types of triggers available in SQL 2000 are AFTER and INSTEAD OF

You can use the FOR...

True. If you only want movies with comments after a certain date (and by my reading that wasn't what was required. I read that he wants all movies with the...

Select [fields] FROM Movies INNER JOIN Comments ON [join clause]

WHERE CommentID IN

 (SELECT TOP 2 CommentID From Comments c Where Comments.MovieID=Movies.MovieID ORDER BY TimeStamp DESC)

Should work. You'll have to change...