Yes, i also found some what odd behavior of sysdepends table. I did some early search on it, but didnt find any useful info.

hope this helps.

i have created weekoff's table according to your given structure and some assumption. Please find test table and a function to find total working hrs...

Table and data:

create table...

Thanks Markus...

as i told earlier, i had left to try to solve my problem as i switched to SS2K5; but i would like to apply this solution now. Though,...

A query with ordering on DateTime filed will perform slower than query with ordering on int filed, as to sort on datetime value, sql server has perform internal conversion on...

I have some confusion here...

according to above structure, you can get detail about the week day and week off in general.

eg.

MondayWorkDay = true

MondayWorkStartTime =...

Such SPs might not edit any table info; may used to fetch data from tables only.

Is that so? Please check it and let me know. it will help to...

I doubt if this is possible. I was having the same problem when i...

Hey, my testing DB doesn't hv views or pk (:hehe:), so left to chk that...

here is the reviesed code...

/* **********************************************************

To check dependency as per object, use following values as

input...

You can use temporary table instead stored procedure into where clause.

eg,

create table #spResult ({columns as result of your sp})

insert into #spResult exec YourSP ({input parameters})

select * from yourtalble

where col...

Hope this helps you,

http://www.windows-tech.info/15/1c5bec6464df5582.php

@rajesh-2.vr,

you can start with above solution by Eswin. OR give your db structure (table for main task info., holiday info etc).

Sorry, i misunderstood your pt earlier...

I tried to make changes according to your pt. please check this.

/* **********************************************************

To check dependency as per object, use following values as

input of the...

please check below links,

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/f8a9a6bd-99ae-4f0f-8ba6-8a1d3326d2a9/

http://www.google.co.in/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&q=sql+server+2008+filestream+feature+is+disabled&btnG=Search&meta=&aq=3&oq=sql+server+2008+filestream

Do you have any information stored in your db for holidays?

If you are new to Backup & Restore, i suggest to visit the following links to have in depth idea about Backup and restore in SQL Server.

http://msdn.microsoft.com/en-us/library/ms186858.aspx

http://msdn.microsoft.com/en-us/library/ms186865.aspx

http://msdn.microsoft.com/en-us/library/ms191455.aspx