Skip to content

Instantly share code, notes, and snippets.

@bdunnette

bdunnette/useful-aperio-queries.sql

Created January 16, 2018 18:10
Show Gist options
  • Save bdunnette/9a90f594696c3920a1bbe2b68252e09b to your computer and use it in GitHub Desktop.
Save bdunnette/9a90f594696c3920a1bbe2b68252e09b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
useful-aperio-queries.sql
-- Find files from specific data group
SELECT [ImageId],[CompressedFileLocation]
FROM [Aperio].[dbo].[Image]
WHERE [DataGroupID]=162
-- Update file location of given image
UPDATE [Aperio].[dbo].[Image]
SET [CompressedFileLocation]='\\gleason\images2\Projects\Giubellino\D17-1452-CompoundSpitzNevus.svs'
WHERE [ImageId]=76585
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment