As per my understanding this is not what post required, your query will...

Its difficult to comment unless seeing the table structures, probably index seek becuase of some column used in where clause or join or in output column is not a part...

Why not implement replication if you very well have network connectivity between both servers, and set the replication end of the day?

Please reread my post. Use a dictionary, if necessary, to help you understand its meaning. I did not call anyone silly. I said that the post made you look silly...

Sergiy (5/24/2013)

---

Phil Parkin (5/24/2013)

---

The first post of this topic.

Not if "like that"...

Try this query... it is suffixing the requirement, but I feel there has to be some other way out to accomplish this.

SELECT D.FileId, D.filetype, COUNT(*)

FROM #Tab1 D

GROUP BY D.FILEID, D.FILETYPE

UNION...

Check you Database Mail setup, some problem with config or SMTP Server, from where the mail is being sent.

In that case instead of setting notification, you can configure alerts, which can set whenever error fires, and notification can be set for job succeded instead of completed.

To Set alert...

The subject should include as completed or failed, alongwith the job / alert name

Hi,

Need information about Micorosoft Certification Path for SQL Server, Planning to complete one.

Thanks,

Try this...

update foo

set b = 'this is'

OUTPUT DELETED.a INTO @foo2

from foo f

inner join bar b

on f.c = b.y

DELETED.a will update previous value and INSERTED.a will update the new value in...

Ells (5/24/2013)

---

2 Then I consider an invalid value say 'BANANA' if the integer is NULL in the target but then when checking against a real integer you would get an...

Eugene Elutin (5/24/2013)

---

WHERE

CASE WHEN TARGET.Column1 = SOURCE.Column1 OR TARGET.Column1 IS NULL AND SOURCE.Column1 IS NULL THEN 1 ELSE 0 END= 0

OR

CASE WHEN TARGET.Column2 = SOURCE.Column2 OR TARGET.Column2 IS NULL...

How about this solutions...

--- Create a InLine Function with ReportingDate Parameter --

CREATE FUNCTION fnMostRecentOrderDetail(@ReportingDate datetime) RETURNS TABLE

AS

RETURN

(

SELECT ProductId, SalesOrderDetailId, ModifiedDate,

ROW_NUMBER() OVER (PARTITION BY ProductId ORDER BY ModifiedDate DESC) RowNo

FROM...

Allocate mince? do you have a percentage breakup to do it, or just randomly will allocate ?