Look into BOL on Triggers and use of the "inserted" and "deleted" tables...

Is this code and a table structure you cannot change?  Why not use an IDENTITY field rather than searching for a new when someone else could be in that table? ...

Like I said, I threw this together without testing it.  This should solve that problem:

SELECT GroupCode, COUNT(*) AS MyCount, T.MyTCount

FROM myTbl

   INNER JOIN( SELECT GroupCode, COUNT(*) AS...

Still not returning any values: 

IF EXISTS( SELECT * FROM dbo.sysobjects WHERE id = object_id( N'dbo.GetInternationalCodes') AND xtype IN( N'FN', N'IF', N'TF'))

DROP FUNCTION dbo.GetInternationalCodes

GO

CREATE FUNCTION dbo.GetInternationalCodes( @AwardID integer)...

Haven't tested this, but:

SELECT GroupCode, COUNT(*) AS MyCount, T.MyTCount

FROM myTbl

   INNER JOIN( SELECT GroupCode, COUNT(*) AS MyTCount

                       FROM myTbl

                       WHERE compliant = 'T'

                       GROUP BY...

I cannot vouch for its 'literary license', (I think another Department issues those...). 

As for its basis - I fully concur.  Our Congress does not have the authority to "give"...

Thanks Peter.  That is exactly correct and it has been a real booger for me with the versions of SQL Server.  I hear tell Yukon or SQL Server 2005, (or...

Please don't cross-post.  Most people look at numerous locations on this site. 

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=228528&post=true

Answer(s) to the first question are the AVE and STDEV functions.  Look them up in BOL.  That should provide you with what you want.  (Unless you need code - in...

Thanks for being "Committed". 

<a href="Curses'>http://www.sommarskog.se/dynamic_sql.html">Curses & Blessings of Dynamic SQL</a>

(I think I must be terminal...)   

Make sure SET QUOTED_IDENTIFIER { ON | OFF } is set to OFF and use double quotes around your Dynamic SQL statement. 

Also, read the following:  <A href="Curses'>http://www.sommarskog.se/dynamic_sql.html">Curses & Blessings...

I do not see how a Trigger would be fired for records such as this..., I am assuming these are 'old' records which would probably not be accessed, hence a...

Glad I could help...

Return your "Detail" resultset to a different predifnied table. 

I believe you stated that your summary information is built from that.  Build that at the end within your calling SP and...

I guess this is really more for thought than comment. 

I replied so the Site Owner does not have to generate a "No reply..." message.