As per my understanding which could be wrong, your actual query will not bring the correct records. if you want to exclude the records, then you should follow LEFT Join...

Nice question. Thanks for sharing

As STEVE mentioned there are many ways.

Following is a solution as per the understanding i get 🙂

Declare @Source table (EventCol varchar(10), UpdateTime datetime)

Declare @destination table (EventCol varchar(10), UpdateTime datetime)

--------------...

in addition to the above question, is there any Trigger on this table ?

Nice question. Thanks for sharing

you need something like (Assumption is the parameters are for DateTime Type).

= IIF(

DateSerial(Year(Parameters!Report_From_Date.Value), Month(Parameters!Report_From_Date.Value), "1").AddMonths(1).AddDays(-1)

=

DateSerial(Year(Parameters!Report_To_Date.Value), Month(Parameters!Report_To_Date.Value), "1").AddMonths(1).AddDays(-1)

,1,0)

it will return '1' for equal, and '0' if not,

Explanation:

getting the month &...

your expression will fail if the years changes

something like this

From Date = 01 September 2013

To Date = 30 September 2014

Nice and easy. Thanks for sharing.

Nice question. Thanks for sharing

Very nice question. Thanks for share Subhash.

Koen Verbeeck (9/17/2014)

Hany Helmy (9/16/2014)

Still not convinced...

+1,...

Nice and easy, Thanks for sharing.

+10 🙂

+1, i remember in my earlier days...