Database

CREATE VIEW FirmOpen
AS
    SELECT
        FirmName,
        CASE
            GETDATE() BETWEEN OpenTime AND CloseTime THEN 1
            ELSE 0
        END AS IsOpen
    FROM 
        tblFirm
    INNER JOIN
        tblTime
        ON (tblFirm.FirmName = tblTime.FirmName)

Tomy1402 wrote:

Do all Tables above is in Normal Form?

karamchandrabose wrote:

Which normal form??

karamchandrabose wrote:

in certain areas normalisation might lead to performance hits, i.e if you are going to have to many reads in your tables, if u have more joins n such stuff, it will impact performance seriously.

CREATE FUNCTION [dbo].[RoundMinutes]
(@dDateTime datetime)
RETURNS DateTime AS  
BEGIN 
declare @minutes int
set @minutes =  datepart(n,@dDateTime)

set @minutes = case when @minutes < 7 then -@minutes
	when @minutes < 23 then -@minutes+15
	when @minutes < 37 then -@minutes+30
	when @minutes < 52 then -@minutes+45
	else 60-@minutes
end
return(dateadd(n,@minutes,@dDateTime)) 
END

select dbo.roundminutes(datefield) as RoundedDateField from mytesttable

r_palanivel83 wrote:

Anyone please tell me that we can work only with Database.MDF file without sql server in asp.net 2.0.