I’m not sure that’s true, this group was working fine before, right?
A couple of your possible solutions above could work fine. Any time you were running into the “Column name ‘StopTime’…” errors, it had nothing to do with the various solutions you were trying, only that the column was in use twice in the group. If you fix that, you should be fine.
In your last screenshot, you have an expression item named “CIPRunID”, which I assume is running the SQL query “SELECT TOP 1 CIPRunID FROM cipruns WHERE stoptime is null ORDER BY id DESC”. Then you’re using it directly in the where clause. This is exactly what I would have suggested had I been quicker to get on this thread. As far as I can tell, you only need to do two thing:
- Uncheck “Store Timestamp”.
- Change the target of the “CIPRunId” to “read-only”
I will try this next week in my office after I return from out of town.[/quote]
that worked, thank you.
Biggest issue I am having converting a MySQL based application to a SQL Server application is the use of quotations. MSSQL has a definite purpose for a single ’ and a " . Once I discovered that, conversion became easier.