In Access, the First and Last functions allow you to retrieve the first or last value (field) within a Group, where the order is not by that field (i.e., ordered...

But he's asking about First and Last, which don't have corresponding functions in T-SQL. I've wished for these at times myself.

Jay Madren

Just redirect to NUL.

e.g.

osql (...whatever...) > NUL

Jay Madren

You need to rerun the snapshot, which is not automatically done by sp_reinitmergesubscription.

Jay Madren

I'm glad it's working well for you.

As to your earlier post, I agree that you don't need the IF Update code in your insert triggers. Sorry for not getting...

Did you enable pull subscriptions in the publication? I think that's what it's referring to.

Jay Madren

Hmm... So you were able to register (and connect?) to the publisher in EM using the ip address, and map drives, but you can't ping it? Sounds like you...

Aha - there's your problem. The NOT FOR REPLICATION option only prevents the trigger from firing when a replication agent is performing the action (insert, update or delete). ...

I'm unclear of what you're trying to do here. You say you need to validate datetime values, but then you mention validating an existing datetime column. If the...

Yes, you should be able to see the other server. First, try a simple ping test. Do you have DNS or WINS setup to resolve the server name...

So, are you sure that the version of the trigger that got applied at the subscriber is the correct one? Just trying to think of explanations. I use...

The NOT FOR REPLICATION option goes before the AS keyword. If you really have it after the AS, you should have gotten an error when creating the trigger. ...

Sorry, I forgot about that. Like I said, I didn't test it .

This will work, as I did test it:

Update Table1...

Change the first line to

Select TOP 1 (A.TYSales-B.PYSales)/B.PYSales*100 As Comp_Sales,

If you want to round the result to, say, one decimal place then

Select TOP 1 ROUND((A.TYSales-B.PYSales)/B.PYSales*100, 1) As Comp_Sales,

Jay Madren

I haven't tested this, but something along these lines should work:

Update Table1 Set phone1 = min(addtlphone)

from Table1 inner join Table2 on Table1.keyvalue=Table2.keyvalue



Update Table1 Set phone2...