Thanks to you all

thanks all for your answers.

I'll try different approach.

p.s - i'm workig on a html report that sent from sql.

yes I'm trying to update an int column to put varchar character.

i know that i can't update this column,but i think maybe there is something to do.

by the way how...

Animal Magic (1/31/2010)

update <tableA>

set <column> = case when B.<column> is null then...

how to use the case in the update statment for a value that is NULL in the column?

THX

now i want to update the null value to varchar like 'No Data'

Thanks but i found another way

DECLARE @TEMP_TABLE_HOLD_TOTAL_SECOND TABLE (TOTAL_SECOND BIGINT)

DECLARE @SQL_START_TIME DATETIME

DECLARE @CURRENT_DATETIME DATETIME

SET @CURRENT_DATETIME = GETDATE()

SELECT @SQL_START_TIME = create_date FROM master.sys.databases where name = 'tempdb'

INSERT INTO @TEMP_TABLE_HOLD_TOTAL_SECOND

SELECT DATEDIFF (ss,@SQL_START_TIME,@CURRENT_DATETIME)AS...

I'm working on a report info.

can you give me an example of ths datepart?

THX

can you show me little example that i can progress with it?

THX

what i meant is the email that sent to me i want to change the font size and color.

THX

THX i've managed with this proc.

can you give me an example of simple proc that have help in it?

THX

no.

it's design for sql 2005 and above.

sry.

can you help here with a little start example of the script that i'm looking for?

THX

maybe you can hep me different approach

i want to retrieve the last top 10 history job from the msdb..sysjobhistory for each job.

how i can write this syntax?

THX