(SELECT [Value] FROM Lists where EntryID = (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT ...

[Read the rest of this article...]

DNN Region Lookup

Declare @PortalId int; Set @PortalId = 0; SELECT 'OwnerFirstName' = U.FirstName, 'OwnerLastName' = U.LastName, 'OwnerEmail' = U.Email ...

[Read the rest of this article...]

DNN Region Lookup SQL

I had a need for getting a property details for a SSR report and came up with the following store procedure  . . . I thought it might be useful t...

[Read the rest of this article...]

Ventrian Property Agent

Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems SQL

COALESCE (Transact-SQL)

ALTER TABLE MyTableName ADD CONSTRAINT DF_MyTableName DEFAULT GETDATE() FOR MyColumnName SQL, Alter Table