Viewing 15 posts - 1 through 15 (of 16 total)
what about seq(10,20,by=2) --> from 10 to 20 and the step is equal to 2
June 14, 2017 at 12:26 am
Is really this is the correct answer ?
:w00t::w00t::cool::cool:
October 1, 2015 at 12:42 am
Kindly read my previous post and the way that you should send the param @date
the @date should be send in this format 'Feb 2012' without the DAY
November 10, 2014 at 7:29 am
You have to use the date format like that "Feb 2012" without the 'Day'
go try it and enjoy it 🙂
Rabih
November 10, 2014 at 4:34 am
What about this function with this date format?
CREATE FUNCTION dbo.[fnGetMonthDays]
(
@DATE DATE
)
RETURNS INT
AS
BEGIN
RETURN DAY(DATEADD(DAY,-1,DATEADD(MONTH,1,CONVERT(DATE,@DATE,101))))
END
SELECT dbo.fnGetMonthDays(CONVERT(DATE,'Feb 2012'))
--29
November 10, 2014 at 1:22 am
Ohhhhh!!!
I didn't see the word "individual" 😉
Good question Steve
Have a good day
Rabih
November 10, 2014 at 12:58 am
Maybe it is the same shirt and you re changing the color of it and the design each friday 😛
October 31, 2014 at 1:19 am
I run the query and I got the below result :
DATABASE Name : Master
-----------------------------
0.713591993212924
0.713591993212924
0.713591993212924
0.713647892126698
0.713647892126698
0.713647892126698
0.713647892126698
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713722424011731
0.713852854810538
0.713871487781797
0.713871487781797
0.713908753724313
0.713908753724313
0.713908753724313
and if i run it on other DB I ll get the below result
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713591993212924
0.713852854810538
0.713852854810538
0.713852854810538
0.713852854810538
0.713852854810538
0.713852854810538
so in the...
September 30, 2014 at 12:43 am
I know that I can do it from any front end but I need to send it to a user in this format when he call procedure.
The problem is they...
September 11, 2014 at 5:55 am
as I understand,
"To calculate the number of days between date1 and date2, you can use either Day of year ("Y") or Day ("D"). When interval is Weekday ("W"), DateDiff returns...
January 24, 2014 at 3:30 am
I think we need more clarification about your case
But i have a solution for you as i understand from your question
Declare a table and then select your column you...
January 18, 2014 at 5:30 am
Viewing 15 posts - 1 through 15 (of 16 total)