mikaelnet

DECLARE @SharedFieldId UniqueIdentifier = '{BE351A73-FCB0-4213-93FA-C302D8AB4F51}' /* Shared checkbox */
DECLARE @UnversionedFieldId UniqueIdentifier = '{39847666-389D-409B-95BD-F2016F11EED5}' /* unversioned checkbox */
DECLARE @TemplateFieldId UniqueIdentifier = '{455A3E98-A627-4B40-8035-E683A0331AC7}' /* Template field */

-- Find all templates WHERE both "Unversioned" AND "Shared" is selected:
-- "Shared" will have precedense, so the "Unversioned" checkbox can be removed
SELECT * FROM SharedFields 
	WHERE FieldId=@UnversionedFieldId AND [Value] = '1'
	AND ItemId IN (SELECT ItemId FROM SharedFields WHERE FieldId=@SharedFieldId AND [Value]='1')

mikaelnet

SELECT * FROM (
    SELECT ItemId, FieldId, Value FROM [SharedFields] (nolock)
    UNION
    SELECT ItemId, FieldId, Value FROM [UnversionedFields] (nolock)
    UNION
    SELECT ItemId, FieldId, Value FROM [VersionedFields] (nolock)
  ) A
WHERE Value Like '%' + CHAR(0x01) + '%'
OR Value Like '%' + CHAR(0x08) + '%'
OR Value Like '%' + CHAR(0x10) + '%'

mikaelnet

public static class GuidUtils
{
	/// <summary>
	/// Creates a name-based UUID using the algorithm from RFC 4122 §4.3, using SHA1
	/// (version 5). This is useful for creating predictive Guid based on content.
	/// </summary>
	/// <param name="namespaceId">A known namespace to create the UUID within</param>
	/// <param name="name">The name (within the given namespace) to make the Guid from</param>
	/// <returns></returns>
	public static Guid Create(Guid namespaceId, string name)