Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
More from the grouping
Message
 
 
To
15/09/2010 16:40:07
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01481344
Message ID:
01481357
Views:
16
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform