I've been following this thread... was thinking maybe some form of the following may be usable...
-- In T-SQL Create Table TestTable (ID Int, TestF Bit) -- Then change: -- Insert into TestTable (ID, TestF) Values (10, True) -- to something like: Insert into TestTable (ID, TestF) SELECT 10, True -- Won't Work, but Insert into TestTable (ID, TestF) SELECT 10, True From (Select 1 as True, 0 as False) DerivedTB -- or Insert into TestTable (ID, TestF) SELECT 10, False From (Select 1 as True, 0 as False) DerivedTB
where all but the new values are "constant" texts.
The problem is that the SQL CAN'T BE CHANGED
Yeh Noel, I hear ya. Just wanted to maybe give you some "ammo" or thoughts that might help.
Is the statement hard coded into an app some where, and is now being issued to SQLSrv. instead of Access?
I have no clue.
I didn't post the question
Yes, would be interesting to hear why the statement can't be changed.
If that's a third party app, I wouldn't hesitate to contact the vendor.
Just a thought!
Would there be any gain when this front-end would fire the query against an ADP project with linked SQL Server tables? I don't know what ADP exactly does, but the statement wouldn't need to be changed.