Comments by kasbaba - CodeProject

kasbaba 5-Apr-19 1:59am View

This is corrected. Thanks for pointing out. Although I was using CAST in the query.

kasbaba 5-Apr-19 1:58am View

Hi Rob - yes. What i want to accomplish is a query which can show me the Point in Time data using the Audit (Log table) and the base data table.

And no it doesn't add 112 rows. A row is only inserted when something has changed. So we do not have any entries in the Log table for newly created items. Only if they change during their lifecycle would be expect them to see them in the log table.

Hope this makes sense.

kasbaba 4-Apr-19 9:12am View

Thanks CHill60 for the answer. I am using SQL 2008 R2. I don't want to use the last updated datetime as this would cause massive rework and I read somewhere that this methodology should not be used on large datasets.

In any case, I will try the SQL snippet you provided and let you know if it does / doesn't work.

Many thanks

kasbaba 16-Dec-18 13:44pm View

Also, I would suggest checking the Resource properties (Compile / CopyIfNewer, etc.)

kasbaba 4-Dec-17 8:23am View

Try

datagridview.currentcell = nothing

kasbaba 4-Dec-17 8:22am View

Try

datagridview.currentcell = nothing

kasbaba 12-Apr-17 10:40am View

Thank you for your answer. I agree loading those many items is not ideal. As I mentioned, it was a requirement. Thankfully, we found a way and it was load the data in batches and use Merging to allow the whole operation to work without overloading system resources.

Comments by kasbaba (Top 7 by date)