User bio
404 bio not found
Member since Feb 1, 2021
Pinned posts:
Posts:
show all 43
Replies:
show all 361
David Hockenbroch · May 11 go to post

I'm not sure it'll be much better performance-wise, but you could make it something like:

AND ((TOURINFO.TNR = TNRHead.TNR) OR (TOURFIND.TNR IS NULL AND SGNRFIND.TNR = TNRHead.TNR = TNRHead.TNR))
David Hockenbroch · Apr 29 go to post

What I've found a written about here may be relevant, but I'm  not sure how to address that issue in your specific use case.

David Hockenbroch · Apr 27 go to post

I have the added wrinkle of writing software for the millwork industry in America. The ' and " are used to denote units of length (feet and inches respectively) so it is pretty common for them to be in the data too, especially in descriptive fields. Ultimately, we usually end up using a | as a separator instead of a , .

Open Exchange applications:
sqljsonadaptor
iris-watched-status
Certifications & Credly badges:
show all 1
Followers:
show all 5
Nimisha J.
Ashok Kumar T.
Dewey H.
Prasanth A.
Roman P.
Following:
David has not followed anybody yet.