What would be the reason(s) that an Update trigger would not be able to handle this by comparing the before and after version of the records and writing a summary...

Without knowing more about the interrelationship of the fields and tables, my initial guess would be your WHERE clause is limiting the result set?

Toni

Yes. Smalldatetime only tracks to the minute level

Toni

You would join the tables and then get the count. -- better example

select f.fieldesc, count(o.fieldid)

from fruits f

left join orders o on f.fruitid =...

Try using Convert and Replace to change the comma to another character (like @) then change the '.' to comma(s) finally change the other character (@) to a dot. ...

You can use the CHECK constraint either when you create the table or add it via an ALTER command. In the check constraint you can check the value...

Glad to be able to help Wayne. At least I got the concept right 😉

oh and it is Toni (as in Toni Marie) not Tony (as...

TO expand on my prior post. The code below would return just 0x from the table

Toni /* added a second example */

declare @temp table...

did you try using DATALENGTH function to limit the length to 2? (Writeup from BOL is below)

Toni

DATALENGTH

Returns the number of bytes used to represent any expression.

Syntax

DATALENGTH...

To use the Index Tuning Wizard you can capture a workload via Profiler or use one from the Query Analyzer Query window. You specify the database, level...

Ok... I tested with all dates the same and it returns one row per account due to the Group by clause.

So I am still wondering what you saw Ananth?

Toni

Ananth, first you could add the TOP n clause to the outer select if you needed to;however, based on the specs I don't believe returning all the invoices is wrong...

Glad I could help

Ok.. maybe someone else can verify and/or adjust my observation but it looks like you are joining two tables with many-to-many relationship and getting lots of duplicate data.

This might...

Perhaps if you could supply some test data to be sure I am addressing the right problem that would help.

It would be good to see what you are actually trying...