No announcements
Found 1849435 threads
-
0 VotesSQL Question on how to calculate a beginning and ending date
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in ...Answered | 5 Replies | 6362 Views | Created by GoodSE - Saturday, August 11, 2012 2:51 PM | Last reply by --CELKO-- - Saturday, August 11, 2012 9:15 PM
-
0 Votes
How to get begin and end date of any quarter in sql server 2008
Since SQL is a database language, we prefer to do look ups and not calculations.Answered | 3 Replies | 16083 Views | Created by girishrastogi - Friday, August 30, 2013 7:19 AM | Last reply by --CELKO-- - Friday, August 30, 2013 3:09 PM -
0 Votes
dynamic begin/end dates for calculated measure
[Date].Answered | 2 Replies | 4669 Views | Created by rynacpro - Friday, April 16, 2010 11:13 PM | Last reply by Raymond-Lee - Monday, April 19, 2010 11:46 AM -
0 Votes
Calculating Start and End Dates From Predecessors in SQL
DECLARE @Test AS TABLE(ActID INT,ActName VARCHAR(50),Duration INT,Predecessor INT) INSERT INTO @Test VALUES(1,'Building Contract',2,NULL) INSERT INTO @Test VALUES(2,'Land ...Answered | 6 Replies | 1035 Views | Created by EmadKhanSpiderGrey - Wednesday, March 13, 2019 9:00 AM | Last reply by EmadKhanSpiderGrey - Thursday, March 14, 2019 8:05 AM -
0 Votes
Dynamic parameter for begin and end date
I have also (for testing) created another dataSet with a parameter id, so when you passed the id to it, it only give you a record with begin and end date ...Answered | 6 Replies | 2815 Views | Created by rv7a99cv - Tuesday, November 15, 2011 3:18 PM | Last reply by rv7a99cv - Tuesday, November 15, 2011 6:14 PM -
0 Votes
Begin Date<=End Date Report builder
Hi Everyone, I am trying to make a simple validation expression for a report on the two datetime input fields start date and end date.Answered | 1 Replies | 2735 Views | Created by helpdevelop - Thursday, May 30, 2013 8:26 PM | Last reply by Chongtham Rajen Singh - Friday, May 31, 2013 3:33 AM -
0 Votes
Calculate duration between start date and end date
I think your best bet would be to alter the function sufficiently so it will accept times instead of hours, and where you're making comparisons to the hour, use ...Answered | 2 Replies | 2293 Views | Created by hongngoc - Monday, May 5, 2014 5:33 AM | Last reply by hongngoc - Tuesday, May 6, 2014 3:17 PM -
0 Votes
Calculate start and end dates
Lesson 1: When you post this kind of question, you do yourself a service if you post: 1) CREATE TABLE statement for you table.Answered | 10 Replies | 2671 Views | Created by Kiwi Jonathan - Sunday, January 20, 2013 8:47 PM | Last reply by Naomi N - Tuesday, January 22, 2013 3:10 AM -
2 Votes
SQL 2008 - how to check date is End of Month date or not?
How can I check parameter pass date is "End of Month" date or not.Answered | 9 Replies | 20836 Views | Created by KM IT - Thursday, April 14, 2011 3:40 AM | Last reply by vinaypugalia - Thursday, April 14, 2011 12:28 PM -
0 Votes
Calculate Total Days from Start and End Date
Hi SharePointTech, You can create a calculated column named Totaldays, and set formula as “DATEDIF([Startdate],[Enddate],"d")”.Answered | 5 Replies | 1104 Views | Created by SharePointTech - Tuesday, May 3, 2016 5:28 AM | Last reply by Dean_Wang - Wednesday, May 18, 2016 8:46 AM -
0 Votes
Calculate Date with Exclusions
0 begin set @end_date = DATEADD(DAY,1,@end_date); if not (DATEPART(WEEKDAY,@end_date) = 1 or DATEPART(WEEKDAY,@end_date) = 7 or exists (select 1 from ...Answered | 4 Replies | 890 Views | Created by Guyatplacedotcom - Wednesday, January 13, 2016 6:38 PM | Last reply by Guyatplacedotcom - Wednesday, January 20, 2016 8:47 PM -
0 Votes
discover begin and end event
I am running a sql profiler to capture ssas cube performance data.Answered | 1 Replies | 5730 Views | Created by SSAS_5000 - Wednesday, February 2, 2011 9:46 PM | Last reply by Darren Gosbell - Thursday, February 3, 2011 6:07 AM -
0 Votes
Get begin and end date based on weeknumber and year
For creating a Timedimension see - How to create a time dimension in SQL Server With the timediemension your query will become quite simple.Answered | 3 Replies | 5185 Views | Created by VSempoux - Friday, January 23, 2009 9:40 AM | Last reply by gvee - Friday, January 23, 2009 11:08 AM -
3 Votes
how i calculate if a list of holidays present or not in between the Start and End Dates
I would request you to setup a tiny event handler on adding/editing leave request to find the date difference and the existance of Holidays (stored in a seperate list/ source) to ...Answered | 3 Replies | 5996 Views | Created by Charles Michel - Saturday, August 27, 2011 11:06 AM | Last reply by Charles Michel - Sunday, September 4, 2011 5:31 PM -
0 Votes
Simple SQL Date Question
But I guess your other point is valid - we wanted the upper limit to be current date, not the beginning of the next year.Answered | 7 Replies | 1531 Views | Created by Jumpy99 - Sunday, April 7, 2013 2:42 PM | Last reply by Naomi N - Monday, April 8, 2013 1:11 PM -
0 Votes
Emtpy begin/end is a syntax error?
So, I see that the SQL syntax dictates that there must be at least one statement between BEGIN/END.Answered | 5 Replies | 4625 Views | Created by Neo the 1 - Thursday, April 29, 2010 6:00 PM | Last reply by KJian_ - Tuesday, May 4, 2010 9:30 AM -
0 Votes
how do i calculate the dates in this scenario
" :-) My understanding of it was as follows: Row 1 = 1900-01-01 through the day before the customer begin ...Answered | 23 Replies | 1485 Views | Created by Jack Nolan - Monday, March 17, 2014 5:09 PM | Last reply by johnqflorida - Wednesday, March 19, 2014 4:04 PM -
0 Votes
BEGIN AND END INSIDE TRY BLOCK
First of all you can implement this without the BEGIN TRY\ END TRY blocks..Answered | 5 Replies | 1743 Views | Created by SQL Insane - Thursday, August 29, 2013 6:34 PM | Last reply by SQL Insane - Saturday, August 31, 2013 12:42 AM -
1 Votes
Date within range calculations
Think about the temporal dimensions and how they are different from spatial dimensions.Answered | 4 Replies | 1148 Views | Created by Vehlin - Friday, July 31, 2015 9:59 AM | Last reply by --CELKO-- - Saturday, August 1, 2015 2:16 AM -
0 Votes
Calculate a date
If you are trying to achieve in SSRS calculated field, you could try using this express: =DateAdd("d",14,Fields!Answered | 2 Replies | 857 Views | Created by JLL2019 - Wednesday, May 15, 2019 5:35 PM | Last reply by Lukas DreiKlein - Thursday, May 16, 2019 1:37 AM - Items 1 to 20 of 1849435 Next ›
No announcements
