Hassle-free live chat software re-imagined for business growth. 2 users, always free.
select count(*) from tblOrgHours where RegID = 74 And ActivityDate = '07/01/2014' And ((HourTimeFrom >= '09:00:00.0000000' And HourTimeFrom <= '09:00:00.0000000') Or (HourTimeTo >= '10:00:00.0000000' And HourTimeTo <= '10:00:00.0000000') Or (HourTimeFrom < '09:00:00.0000000' And HourTimeTo > '10:00:00.0000000'))
|How would you modify a Stored Procedure in SQL Server 2008, so that the result set displays date field in format MM/DD/YYYY?||2||17|
|Anyway to make these 2 SQL statements into one?||13||27|
|ISDATE() not working properly on my table? Any suggestions.||7||12|
|Create formula that divides total amount by 30 or 31 depending on what month of the year it is looking at||5||26|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!