Try list at http://www.sqlmag.com/forums/messageview.cfm?catid=13&threadid=9801

Then it's a "min" versus a "top 1 order by desc"

If you have time, which IO is the the least expensive.

(I also like Joe Celko smarties)

/* Hope this helps */

Select t.*

From MyStats t

Inner join (Select Convert(Char(7),Stat_Date,111),Max(Session_Count)

...

Notice you use a left join?

Any value in custsatisfaction that's not contained in #Responses?

First statement counts all custsatisfaction records and second statement consider only records which links with custsatisfaction.

Any NULLS?

Declare @SList Varchar(1400),

@SFor Varchar(100)

-- Assumption |(pipe char) never in data!!!

Set @SList = '|joe|john|jay|'

Set @SFor='john'

Select Case When CharIndex('|'+@SFor+'|',@SList)>0

...

How about triggering a scheduled job to run which can do the work and allows the trigger to return. Up scaling maybe a problem if trigger is slow!

Out of curiosity, are you doing anything special with / in the event log!

Rational -> http://www.rational.com/index.jsp?SMSESSION=NO spring to mind!

MS Visio!

Should have an if UPDATE(column) in the update trigger. Only do the check if LinkId was changed.

-- Hope this helps a bit

Set NoCount on

GO

Create table Table1 (ID int identity(1,1) not null primary key, SomeText varchar(10) not null, LinkID int not null default -1)

go

Create Trigger InsertTrigger on...

That will be something to read!

Using something similar.

Created a user for the database and supply username/password in bcp command string.

Try the article at http://www.topxml.com/java/articles/clientside/

Select DB_ID(),DB_Name()

Select DB_Name()