RESOURCE_SEMPAHORE wait type is due to the memory pressure created by the queries. In simple your queries asking more memory from the server to execute them. you 1st need to...

Good question. Thanks for sharing

Usually Not-Matched records are generated because of an exception in data or the lookup table does not have the current snapshot of the data you are loading.

i would suggest if...

Nice and easy. Thanks for sharing

John Mitchell-245523 (8/10/2015)

---

What do you want in the other two columns? Is this a homework...

As per you desired result, this isn't that much hard to write the query for this.

-------- for 2014-2015

select ID

, STATUS

, START_DATE

, END_DATE

, date_year

from remp_year

Where date_year = '2014-2015'

and STATUS = 'Active'

order...

please share your desired output as well.

nice question. Thanks for sharing Koen

nice to see your name in posted by 🙂

Well to understand this you will have to look at the actual execution plan for this update statement.

There you will find the Stream Aggregate operator in the plan. for detail...

I donot think you are loosing any thing. It a simple understanding issue. for the sake of understanding i have created an example below to give you an idea about...

For the sake of the question, no you cannot convert the Int to Unique Identifier. Having said that, you have generate unique identifier for these int values.

and you can do...

very nice question and good knowledge base. Thanks for sharing

Sorry for the delay. Caught up in the work

Following is the query will give you the desire result. in case of any query/ question do let us know.

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

Adam Angelini (6/30/2015)

---

You can only use = to assign values to variables. If you need to filter on >=0, you need to put that logic in the body of your...

great question. thanks for sharing