so will it be

select CONVERT ( smalldatetime , start_date , 101 ) from table

yes there are FK as well like mgr_id like to manager table with mgr_id,

loc_id links with Location table,

and org_id likns organization table as well.

sorry to make it confusion on the query:

Tables:

Person : emp_id, org_id,mgr_id,loc_id

manger : Mgr_id, Name

Location : Loc_id, disc

Organization : org_id, disc

so now the question is :

org_id for all empid belong to...

It is one cell only!!

the colors work fine but only thing i want to achieve is i want to fill color only to the value of the field.

for example

fieldname.value...

yeah it is can be one cell but need to know how to fill color for the value of field.

Thanks

Also can it make the shade color only to the value of field and not whole cell? such if the value is 69.3 then it needs to color that part...

Hi,

It only does green even if the value of fiele is 69.9 which suppose to be different color!!

but backup_size!!

is it in kb or mb i need that in GB if possible!!

thanks

Pat

Hi the link doesn;t work!!

but i could not get the reports name which where executed!!

yes.

That's exactly i need to do!!

I understand that but how can i create audit and alert from it if you can help, i am too confuse!

Thanks

Pat

I have and after some packages goes fine and then it get stuck on one. but most of the time it goes fine through out!!!

I also tried

declare @StartDate datetime, @EndDate datetime

set @Startdate = dateadd(day, -2, getdate())

set @Enddate = dateadd(day, -2, getdate())

EXEC testproc @Startdate,@Startdate, 'All'

but resule

0 0 0

while if i do

exec testproc...