Skip to content

Instantly share code, notes, and snippets.

@swaters86

swaters86/FindCCEbyGUIDORTITLE.sql

Last active August 29, 2015 14:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save swaters86/5e54ef96051bae295cb3 to your computer and use it in GitHub Desktop.
Save swaters86/5e54ef96051bae295cb3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
FindCCEbyGUIDORTITLE.sql
/* select by cceobjectguid */
select top 100 *
from cce.dbo.CCE_Objects aa (nolock)
inner join cce.dbo.CCE_Status bb (nolock)
on aa.Site = bb.Site and aa.Module = bb.Module and aa.Class = aa.Class and aa.RowGUID = bb.CCEObjectGUID
where aa.Site='PN' and aa.Module='3' and aa.Class='301' and bb.CCEObjectGUID='8EBB449B-427E-4CBE-9C87-154C042A3970'
/* select by title */
select top 100 *
from cce.dbo.CCE_Objects aa (nolock)
inner join cce.dbo.CCE_Status bb (nolock)
on aa.Site = bb.Site and aa.Module = bb.Module and aa.Class = aa.Class and aa.RowGUID = bb.CCEObjectGUID
where aa.Site='PN' and aa.Module='3' and aa.Class='301' and Title='Large Tonnage Machines 2000 Tones + Injection Molding'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment