Number of days left in current month
<p>Number of days left in a given month
How do I find the number of days left in the current month?
Example if current month is November and todays date is 16/11/2016 
The Numbers of days in month – Elapse days = ? I want to do it dynamically
In my example  30 – 16 = 14</p>

<pre><code>declare @date date 
set @date='16 Nov 2016'
select datediff(day, @date, dateadd(month, 1, @date)) - 16 AS DaysLeft
</code></pre>