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
You dont have to be a technology pro to comprehend search engines. You probably realize that they can help or even hurt your chances of being found in popular search sites. You can put the marketing p ...
Chapter 2 - Statistically, revenue from commission sources alone has decreased over the years while revenue from fees has increased. It would seem then that an increasing number of agents are adopting ...
Chapter 3 - There are numerous studies and surveys within the industry regarding fees available from ASTA and other sources. For the purposes of this course we will examine some of the most important ...
Chapter 4 - Fee Models and Fee-Based Services - There are some fee programs that are now somewhat standard in the industry. For example, nearly all agencies charge some sort of fee for airline tickets ...
Chapter 5 - Corporate Travel and Fees - Corporate travel agencies were among the first to adopt fees, some even before the days of reduced and zero commission. So-called management fee contracts becam ...
Chapter 7 - A spreadsheet has been included with this course (courtesy of Future Proof Travel Solutions) to assist you with the basic calculations needed to determine your costs per transaction by pro ...
Chapter 8 -One of the most essential and fundamental business concepts is that of the value proposition. Your value proposition is basically the answer to the question: what I am getting for my money? ...
Chapter 9 -The challenges with fees faced by frontline travel agents are real. With potentially years of practice and habits (good and bad) developed selling travel without fees, there can be a legacy ...
Chapter 10 - Marketing is an important topic whether one is referring to fees or not. Marketing is often misunderstood to be primarily about advertising. Advertising is a significant aspect of marketi ...
Very few agencies go from no fees to fee-for all overnight. Even if you are completely committed to the idea of fees for your agency it is wise to think it all through and plan the implementation. The ...
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 ...
Managing a travel agency is not always easy, but there are external resources, this video addresses how SCORE, a nonprofit organization offering free business assistance to small business, that can he ...
Join us, as Paul Ruden, Senior Vice President of Legal & Industry Affairs, covers the range of activities that have been taking place in your association during 2008 and preview what is coming ahe ...
ARC ARC debit memos ASTA ASTA Agency Profile Code of Ethics Elections Governance History Education EDU home study course Model Agency Program Model Agent Program scholarships E-Library ELIB GDS GDS Ma ...