Monday 16th of September 2019 10:22:39 PM
Our Services
Select Theme
Back
declare @test as table(
id bigint primary key identity(1,1),
name varchar(max),
dob datetime,
status bit)
insert into @test values('ilayaraja','09/Nov/1979',1)
insert into @test values('ilayaraja42','10/Nov/1979',1)
insert into @test values('ilayaraja 23','11/Nov/1979',1)
insert into @test values('ilayaraja 33','12/Nov/1979',1)
insert into @test values('ilayaraja 3','13/Nov/1979',1)
insert into @test values('ilayaraja 4','14/Nov/1979',1)
insert into @test values('ilayaraja 5','15/Nov/1979',1)


select * from @test where ((DATEPART(dw, dob) + @@DATEFIRST) % 7) NOT IN (0, 1)
 
     
     
Home | About Us | Products | Services |  Templates | Demo | Contact Us | Careers | Feedback | SiteMap
2005-2014 Logical Technologies. All Rights Reserved.