List of Contributions

Michelle Briggs

Contact Details

My Content

1 to 20 of 20 total

RE: Query Returns Number of Records But Won't Pull Data

Posted By Michelle Briggs 05-02-2025 09:49
Found In Egroup: Automate \ view thread
Hi, Sigrid- Removing the SPRAS joins fixed it. Thanks so much for the help, and have a great weekend! ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Query Returns Number of Records But Won't Pull Data

Posted By Michelle Briggs 05-01-2025 13:32
Found In Egroup: Automate \ view thread
Hi, Sigrid- I cannot do the preview run. It times out. The record count shows 552 (which is correct), so I'm not sure where the disconnect lies. ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Query Returns Number of Records But Won't Pull Data

Posted By Michelle Briggs 05-01-2025 13:31
Found In Library: Automate

RE: Query Returns Number of Records But Won't Pull Data

Posted By Michelle Briggs 05-01-2025 11:57
Found In Egroup: Automate \ view thread
Will do! Thanks for the help. ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Query Returns Number of Records But Won't Pull Data

Posted By Michelle Briggs 05-01-2025 11:38
Found In Egroup: Automate \ view thread
Hi, Jayasri- The record count is 552, so I don't know if that would be an issue. ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Query Returns Number of Records But Won't Pull Data

Posted By Michelle Briggs 05-01-2025 11:37
Found In Egroup: Automate \ view thread
Hi, James- I took your suggestion, and received this error message. Title of scheduled run: Schedule for [Table_20250430_162118]Reason for run failure: An exception occurred while running the Query script as an SAP background process. For details, enable SAP trace in the Studio Options box, re-run ...

Query Returns Number of Records But Won't Pull Data

Posted By Michelle Briggs 04-30-2025 16:34
Found In Egroup: Automate \ view thread
Hi! I have written a query that, when I check the number of entries, pulls the correct number. However, when I run the query, it times out and will not return the records. Any suggestions as to what could be causing this? ------------------------------ Michelle Briggs KIK Holdco Company Inc -- ...

RE: Query Is Timing Out

Posted By Michelle Briggs 03-26-2025 09:30
Found In Egroup: Automate \ view thread
Thanks! ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

Query Is Timing Out

Posted By Michelle Briggs 03-25-2025 13:33
Found In Library: Automate

Query Is Timing Out

Posted By Michelle Briggs 03-25-2025 13:33
Found In Egroup: Automate \ view thread
Hi. I have built a query for someone based on the tables/fields/joins they provided. The query keeps timing out, so I need to know what I am missing that will allow it to return the requested data. Any assistance is appreciated. ------------------------------ Michelle Briggs KIK Holdco Company ...

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-25-2025 13:03
Found In Egroup: Automate \ view thread
Thank you so much! I will give this a try. You have been extremely helpful. ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-25-2025 09:39
Found In Egroup: Automate \ view thread
Thank you so much for your help. The requestor wanted the data from ADRCT in the query, but if it is keeping me from pulling all accounts regardless of whether they have an e-mail address stored, I will delete it and they will need to manually add the ADRCT information. ------------------------------ ...

RE: Editing A Query Created By Another Developer

Posted By Michelle Briggs 03-24-2025 14:25
Found In Egroup: Automate \ view thread
Thank you. Is there a tutorial anywhere for editing another developer's query? ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-24-2025 13:28
Found In Egroup: Automate \ view thread
I attached the SQL table to the response. Here is the Excel version. ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-24-2025 13:28
Found In Library: Automate

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-24-2025 13:26
Found In Egroup: Automate \ view thread
Hi, Sigrid- We are on ECC. ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-24-2025 13:26
Found In Library: Automate

Editing A Query Created By Another Developer

Posted By Michelle Briggs 03-24-2025 12:07
Found In Egroup: Automate \ view thread
Is it possible for me to edit/update a query that was created and published by another developer? ------------------------------ Michelle Briggs KIK Holdco Company Inc ------------------------------

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-24-2025 12:05
Found In Egroup: Automate \ view thread
Thank you. I have a left outer join in the query, but it's still not returning fields with no data. The tables and joins are shown below. It will not let me create a left outer join with any table from ADR6 except for ADRCT. ------------------------------ Michelle Briggs KIK Holdco Company ...

Struggling with Table Joins to Return All Records in Studio Queries

Posted By Michelle Briggs 03-24-2025 10:33
Found In Egroup: Automate \ view thread
I am struggling with figuring out the table joins to return all data points in a query, even if the fields contain no data. The query is a Customer Master query where I want the e-mail addresses included, but I also want accounts who don't have an e-mail address entered included in the results. I apologize ...