Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
More from the grouping
Message
 
 
À
15/09/2010 16:40:07
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01481344
Message ID:
01481357
Vues:
15
>>Do you store somewhere the already processed IDs? Without storing this info, can you explain again how can you filter (your idea) already processed records?
>
>We rely on the LastUpdate field, which is the name given to the calculated Event.DateTime field. This is stored on the server. On the next round trip back to the client, we take everything higher than that. However, we will collect back some RO_No that we already processed, because, as you may have seen, there is no way for us to check the data locally with some kind of flag.

I see, I think I have an idea.

Do you store the LastDate processed somewhere and Pass this date to get everything up from that date?

Post your query again.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform