😀 Nice One 😀

what about seq(10,20,by=2) --> from 10 to 20 and the step is equal to 2

:w00t::w00t::w00t::w00t::w00t:

Is really this is the correct answer ?

:w00t::w00t::cool::cool:

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

You have to use the date format like that "Feb 2012" without the 'Day'

go try it and enjoy it 🙂

Rabih

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

Ohhhhh!!!

I didn't see the word "individual" 😉

Good question Steve

Have a good day

Rabih

Smart question :-):-)

thank you Dave

rabih

Maybe it is the same shirt and you re changing the color of it and the design each friday 😛

Very nice question!:-)

rabih

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...

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...

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...

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...