Not the best but try :

Create Table Test(GroupId Int,TaskId Int,Created smalldatetime)

Go

Insert Test Values(1,2,'04/30/03 10:00')

Insert Test Values(1,4,'04/30/03 10:15')

Insert Test Values(2,9,'04/30/03 09:00')

Insert Test Values(2,6,'04/30/03 09:05')

Go

Select a.GroupId,

...

Try:

SELECT * FROM Product

WHERE Description LIKE '%'+@Desc+'%'

Example:

Declare @d varchar(8000),

@arg varchar(10)

Select @d='ABC''DEF',

@Arg='C''D'

Select @d

Select Case When @d...

Try the articles at

http://www.sqldts.com/default.aspx?6,103,246,0,1

http://www.sqldts.com/default.aspx?6,103,103,5,0

See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11664&FORUM_ID=8&CAT_ID=1&Topic_Title=datetime+function&Forum_Title=T%2DSQL

Note about syslanguages.

An article which maybe of interest to you about "The Call-Costs Problem".

Title: Counting the Costs

URL: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=27592

Oops should have been

Select Convert(char(10),GetDate(),101)

Select Convert(char(8),GetDate(),101)

Or then

Select Convert(char(8),HDate,101)

Quick and dirty try scptxfr.exe of MS.

Found it under Program Files\Microsoft SQL Server\MSSQL\Upgrade, SQL 2000.

Scheduled a job from TSQL and add file to VSS one can get a bit of...

BOL 2000: See OPENROWSET, example towards the end for Access and SQL, alternatively OPENDATASOURCE

Try

Select f.Col1,f.Col2

From (Select r.Zipcode

...

BOL 2000: See Shrinking the Transaction Log.

See article at http://www.databasejournal.com/scripts/article.php/1492301

Warning: DO A COMPLETE BACKUP BEFORE HAND.

Neat trick!

Is this update part of a 'bigger' transaction?

Maybe worth while to start at web and work through COM+, if relevant, to SQL checking where every transaction is started/committed.

What is...

Mod your trigger and add

Exec master..xp_logevent 60000,'Trigger For Insert Table1 Starting',informational

Exec master..xp_logevent 60000,'Checking block1 etc.',informational

Exec master..xp_logevent 60000,'Trigger For Insert Table1 Return!',informational

Do an update and check the SQL Server log in...

Agree with Andy Warren.

TSQL can be a mini program in itself, but one needs to have the complete picture before starting to code.

Too much of a speed freak to...