I'm trying to run a SQL SELECT query from a Report using the EXEC command in Report Designer, but the documentation for it is very limited and I'm having trouble getting it to work. Can someone help me?
The SELECT query I'm trying to run is this:
select prefix, middle, revision, copy_no, file_name, left(action_date,11), person_code from documents left join document_copies on documents.document_id = document_copies.document_id left join doc_copy_files on document_copies.copy_id = doc_copy_files.copy_id left join doc_source on doc_copy_files.file_id = doc_source.pdm_file_id left join object_audit_info on documents.document_id = object_audit_info.object_id left join persons on object_audit_info.person_id = persons.person_id where documents.status = 'N' and documents.class_id = '108' and documents.template = 'N' and current_revision = 'y' and has_other_revs = 'y' and (file_name is not null and file_name not LIKE '%eB Historic%') and object_type = 3 and action_type = 1 order by prefix, middle, revision, copy_no
Thanks
nice
Surprised with the information!
geometry dash lite