Database reported: The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'.
General SQL Error
The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'.
declare @GN int
declare @ContentItemID int
declare @NavTree table (
declare @Items table (
ContentItemID int primary key,
/* Select the group number, based on the content template */
select @GN = NavGroupNum
where TemplateID = ?
/* Query the nav structure to find the set of items that will be returned */
insert into @NavTree
S.AncestorContentItemID, S.ParentContentItemID, S.ChildContentItemID,
S.Depth, S.DisplayOrder, S.NavGroupNum, PCI.ItemNumber
from SM_NavigationStructure S
left join CM_ContentItems PCI ON S.ParentContentItemID = PCI.EntityID
where S.NavGroupNum = @GN
and S.AncestorContentItemID is null
and Depth <= ?
/* Pick out the exact set of items to return */
insert into @Items ( ContentItemID, DisplayOrder, Depth, ParentItemNumber )
select CI.EntityID, S.DisplayOrder, S.Depth, S.ParentItemNumber
from Entities E
join CM_ContentItems CI ON E.EntityID = CI.EntityID
join @NavTree as S on CI.EntityID =
where E.IsActive = 1
and CI.EntityID not in (
from SM_NavigationStructure join Entities on SM_NavigationStructure.AncestorContentItemID = Entities.EntityID
where Entities.IsActive = 0
and CI.EditableProduct = 0
and CI.DatePublished is not null
and ( CI.ReleaseDate is null or DateDiff(d,ReleaseDate,getdate()) >= 0 )
and ( CI.ExpireDate is null or DateDiff(d,getdate(),ExpireDate) > 0 )
and CI.DateArchived is null
/* Now, select all of the actual content item data, as determined by the nav tree */
CI.TemplateID, CI.ItemNumber, CI.DatePublished,
CI.LoginRequired, CI.VisibilityException, CI.VisibilityRestriction,
F.FieldID, IsNull(F.GroupNum,1) AS GroupNum,
F.FieldName, F.FieldType, F.Maximum,
CIF.ContentItemFieldID, IsNull(CIF.RepNum,1) AS RepNum,
CIF.FldString, CIF.FldText, CIF.FldInt,
CIF.FldDate, CIF.FldDecimal, I.Depth, I.ParentItemNumber,
NIC.TargetURL, NIC.TargetWindow, NIC.UseURLVariables, I.displayorder
from CM_ContentItems CI
join Resources R ON CI.EntityID = R.EntityID
join @Items as I on CI.EntityID = I.ContentItemID
left join CM_Fields F ON CI.TemplateID = F.TemplateID
left join CM_ContentItemFields CIF ON CI.EntityID = CIF.ContentItemID AND F.FieldID = CIF.FieldID
left join SM_NavItemConfiguration NIC on NIC.EntityID = CI.EntityID
order by I.DisplayOrder ASC, CI.ItemNumber, GroupNum, RepNum, F.FieldID
There is definitely a skill to consulting and, just like sales, there are very specific techniques and approaches. There are many courses, books and workshops available to teach you consulting techniq ...
While there are an infinite number of great ideas that could help increase your leisure sales we obviously had to make some choices! In addition to the now obvious tip of mastering the art of consulti ...
Obviously, most if not all of the tips in the previous chapter can work for corporate agencies as well. There are however some things that every corporate agency should know when it comes to developin ...
Now you have ten fun tips and a helpful approach to building your consulting skills. You might want to try one or you might want to try them all. If you just dont have the time or interest to give the ...