I got it.

Thanks

Bhavesh

it's very difficult to generate new one. because it;s already generate by stored procedure and update record everynight.

I can not make in this table now.

I need to geterate table within fromdate and Todate.

and Use this table with left join to other table.

Select m.month,v.year, ID, Name from #Month m

lett join View_Data v on ...

Yes, because I need to use this functin in 20-25 stored procedure.

Can you explain me how can i do with Datediff ?

Thank you so much:-)

Thank You So much

🙂

Thanks

Bhavesh

Thank you so much

This is woriking for last of the month.

but if I want a output based on group by month ...then how can i get each month ???

yes, I have two seperate parameter . And Also i used Group by Month.

SO i want a Ouput based on Month end for each month.

Like 31 of jan

28 feb

31th...

But I have A names like

John hozack MD

CHRISTOPHERDODSON MD

And I dont Want last Two Words means I do not want MD then ??/?

Thanks

It's T-SQl

The function is nor returning right result set.

SELECT Common.InitialCap ('ABINGTON HEALTH LANSDALE HOSP')

ouput

ABINGTON HEALTH LANSDALE HOSP.

Please let me know if any change.

Thanks

Bhavesh

Thanks For all Reply.

Bhavesh

Thanks You so much,,

Jeff

It;s working fine.:-):-):-)