Tag Info

New answers tagged

0

As far as i have been able to read/research it seems that the answer is no. However i have found that I can merge 2 datasets to achieve what I wanted to do.


4

Isn't this what you're looking for ? CREATE TRIGGER [triggername] ON [table] AFTER INSERT, UPDATE AS BEGIN UPDATE [table] SET [table].Updated = Getdate() WHERE ID IN (SELECT ID FROM INSERTED) END GO


6

The problem is that it might (and knowing spatial indexes, probably will) assume that the spatial filter will be a lot more selective than the time filter. But if you have a few million records within 200km, then it could be significantly worse. You're asking it to find records within 200km, which returns data ordered by some spatial order. Finding the ...



Top 50 recent answers are included