You are welcome

Follow the game

set @ACCOUNTTIME= ISNULL(@ACCOUNTTIME,0)

Am I missing something ?

WHERE left(column, 2) in (select SearchItem from SearchTable)

Will return true when at least one of the search items is found!!

but the construct:

colum_name Like searchpattern and column_name...

the procedure sp_sproc_columns was "meant" to do that

UNFORTUNATELY COLUMN_DEF (which is is what you are after) is HARDCODED to:  convert( nvarchar(4000), NULL) 

 The...

sp_pkeys @table_name =  'YourTableName'

select tr.[name] as Trigger_Name,

 p.[name]  as Table_Name,

 user_name(p.uid) as Table_Owner,

 case

   when OBJECTPROPERTY(tr.id, 'ExecIsTriggerDisabled') = 1 THEN 'Disabled'

   when OBJECTPROPERTY(tr.id, 'ExecIsTriggerDisabled') = 0 THEN 'Enabled'

   else 'UNKNOWN'

 end as Trigger_Status

from

          sysobjects p  join...

"count(column) = 0" statement.  This translate to count(column)'s non null values = 0

Believe me I know what time preassure can do to the delivered code. Some people just want to make it work quickly and don't take the time to think or...

Very Funny

truncate table and Select into

On how to track those statements I can't help you.

If you can use the sp_dboption to change the "select into/bulkcopy" to false those statements will...

the fact that you are retrieveing a TEXT field which potentially can go up to 2GB is way more important (performance wise) that the use of a datareader for its implementation

SET XACT_ABORT ON

Dam! got my own medicine (Beat me by a minute )

Yep, got Lucky today

A calendar table may not look as sexy as a function but is so flexible that is usually the method that I tend to recomend for this kind of things!

Cheers!

For once! I got it first