Database

pResults =
            (
                from d in context.PRODUCT_DEPARTMENT
                join da1 in context.PRODUCT_DEPARTMENT_AVATARS on d.Avatar_Primary equals da1.AvatarID into avatars
                from da1 in avatars.DefaultIfEmpty()
                where d.Deleted == false
                orderby d.Name                
                select new model_departments_index
                {
                    DepartmentID = d.DepartmentID,
                    Enabled = d.Enabled,
                    Deleted = d.Deleted,
                    Name = d.Name,
                    Description = d.Description,
                    Featured = d.Featured,
                    Rollback = d.Rollback,
                    Avatar_Primary_ID = d.Avatar_Primary,
                    Avatar_Primary_Image = new model_type_avatar
                    {
                        Name = da1.Name,
                        Alt = da1.Alt,
                        Data = da1.Data,
                        Type = da1.Type,
                        Url = da1.Url
                    },
                    Categories = 
                    (
                        from c in context.PRODUCT_CATEGORY
                        where c.DepartmentID == d.DepartmentID
                        select new json_product_categories
                        {
                            text = c.Name,
                            value = c.CategoryID
                        }
                    ).ToList()
                }
            ).ToList();
            pValue = pResults.Count();

SELECT DISTINCT (your 7 columns) FROM table

HobbyProggy wrote:

A lot of my DB query execution code uses transactions

select datediff(hh,'05:30:00','10:00:00') from tablename

<pre>
ALTER   FUNCTION [dbo].[fn_Split]
 (@List  varchar(8000), @Delimiter char(1))

RETURNS @Results table
 (Item varchar(8000),ID int Identity(1,1))

AS

begin
 declare @IndexStart int
 declare @IndexEnd int
 declare @Length  int
 declare @Word  varchar(8000)

 set @IndexStart = 1
 set @IndexEnd = 0

 set @Length = len(@List)
If @Delimiter = '' Set @Delimiter = ','

--Get rid of any tabs or returns
Set @List = Replace(@List,char(9),'')
Set @List = Replace(@List,char(10),'')
Set @List = Replace(@List,char(13),'')

while @IndexStart <= @Length
begin
    set @IndexEnd = charindex(@Delimiter, @List, @IndexStart)

    If @Delimiter = char(32) 
        set @IndexEnd = charindex(Space(1), @List, @IndexStart)

    if @IndexEnd = 0
        set @IndexEnd = @Length + 1

    set @Word = substring(@List, @IndexStart, @IndexEnd - @IndexStart)
    set @IndexStart = @IndexEnd + 1

    INSERT INTO @Results(Item)
    SELECT @Word
end

return
end