Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Hi..I need to create a function that accept parameter as date and number,add that number in date and find how many Sunday in that between and again add that Sunday in date and give that date .. it will be recursive.. plz proved the logic for that Thanks
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts
Posted - 2012-12-22 : 09:18:53
I was following what you are asking for until "...it will be recursive". Can you explain with some sample data? You can try using the following: