Question Robert Stephens · Nov 4, 2024 Select query not returning all results I'm running a query, joining nine tables together. When I run it with a SELECT COUNT(*) I get about 200,000 rows. When I run the SELECT with the columns I want, I get about 2,700 rows. Is there something inherent with the queries that limits the result set size, or anything I can do to make sure I'm getting back all the results? Rather, than trying to run it about 100 times limiting all previously gotten accounts. #Caché #InterSystems IRIS #InterSystems IRIS for Health 0 2 0 83
Question Robert Stephens · Oct 3, 2024 MRN Field What table would I find the MRN in? I'm trying to write a crystal report and pull that field, but I cannot seem to find it in any of the tables, to be able to add to the report. Thank you in advance for any help. #Caché #InterSystems IRIS for Health 0 2 0 96
Question Robert Stephens · Sep 30, 2024 Combine all rows in select into one comma delimited string I've got a select statement bringing back one value, I want to combine all rows into one comma delimited string. So for example: SELECT First Name FROM mydb.People I get a list of names: John Fred Sarah Carl Jane Julie Instead of having 6 rows in the result, I want one row, with one cell that has "John,Fred,Sarah,Carl,Jane,Julie" Is there a way to do that? #Caché #InterSystems IRIS 0 2 0 79
All posts
All posts
All posts