Database

DateTime start = new DateTime(2007, 1, 1);
int num = 0;
while (DateTime.Compare(DateTime.Today, start) == 1)
{
    int day = (int)start.DayOfWeek;
    if (day > 0 && day < 6)
        num++;
    start = start.AddDays(1);
}

SELECT DATEDIFF (dd, '01/01/2007',getdate()) - (DATEDIFF (wk, '01/01/2007',getdate()) * 2)

CREATE function dbo.DateDiffWeekdays
(@fromdate datetime,
@todate datetime)
RETURNS int
AS 
begin
declare @procdate datetime, @enddate datetime
declare @weekdays int
set @procdate = @fromdate 
set @weekdays = 0

while (@procdate < @todate) 
begin
if (datepart(dw, @procdate + 1) <> 1) and (datepart(dw, @procdate + 1) <> 7)
set @weekdays = @weekdays + 1
set @procdate = dateadd(d, 1, @procdate)

end
---
if @todate is null 
set @weekdays = null

return @weekdays
end

CREATE FUNCTION WeekDaysBetween
(
@from datetime,
@to datetime
)
AS
BEGIN
DECLARE @num int
SET @num = 0
WHILE (DATEDIFF(day, @from, @to) > 0)
BEGIN
   DECLARE @day int
   SET @day = DATEPART(dw, @from)
   IF (@day > 1 AND @day < 7)
	SET @num = @num + 1
   SET @from = DATEADD(day,1 , @from)
END
RETURN @num
END

Harini Krishnaswamy wrote:

What is your question??

select name, filename from sysfiles

kaliem wrote:

I assume you are asking for your database MDF file location

kaliem wrote:

I assume any reply here would count a reply to this thread and anyone can view it. Sorry for any confusions.

kaliem wrote:

Because of nature of that query, I wanted be more specific.

Renuka Reddy wrote:

what is is and where we can use...

SELECT * FROM sysobjects