Bookmark lookup (Why)

I can't figure out why i have a bookmark lookup cost on ValidVendorPackages
on the below proc:
Select PriceViewHotelPrice.price as Totalprice, PriceViewHotelPrice.Docid
from price_view PriceViewHotelPrice Inner Join
(
select C1.Priceid as Pid,C1.VendorPackageId from
(
select distinct(HA.PriceId), HA.VendorPackageId from Criteria HA Inner Join
(
select VendorPackageId from ValidVendorPackages
where (Vendor = @.Vendor or @.Vendor = '')
and (Sitecode = @.Sitecode or @.Sitecode = '')
and (PackageType = @.PackageType or @.PackageType = '')
and (RequiredItems = @.RequiredItems or @.RequiredItems = -1)
)HB on HA.VendorPackageId = HB.VendorPackageId
and
(
CriteriaId in
(
select CriteriaID from ValidItemCriteria
where Destination = @.Destination
and LengthOfStay = @.LengthOfStay
and Ages = @.Ages
and ComponentType = 'H'
and (ValidItemType = @.HotelValidItemType_1 or @.HotelValidItemType_1 = '' )
and (ItemValue = @.HotelItemValue_1 or @.HotelItemValue_1 = '' )
)
)
) C1
) HotelCriteriaPriceId on PriceViewHotelPrice.priceid =
HotelCriteriaPriceId.Pid
and PriceViewHotelPrice.keydate between @.KeyDateMin and @.KeyDateMax
and ((PriceViewHotelPrice.price) between @.PriceLow and @.PriceHigh or
@.PriceLow = -1)
and (PriceViewHotelPrice.Volatility between @.VolatilityMin and
@.VolatilityMax or @.VolatilityMin = -1)
and (PriceViewHotelPrice.AvgMinsUpdateInterval between
@.AvgMinsUpdateIntervalMin and @.AvgMinsUpdateIntervalMax or
@.AvgMinsUpdateIntervalMin = -1)
Order by TotalPrice
can anyone see why?
will
On Wed, 15 Dec 2004 11:55:04 -0800, we7313 wrote:

>I can't figure out why i have a bookmark lookup cost on ValidVendorPackages
>on the below proc:
Hi we7313,
Without knowing your table structure, indexes, etc, I can't do anything
but guess. Peruse at your own risk :-)
Looking at this part of the query:
>select distinct(HA.PriceId), HA.VendorPackageId from Criteria HA Inner Join
>(
>select VendorPackageId from ValidVendorPackages
>where (Vendor = @.Vendor or @.Vendor = '')
>and (Sitecode = @.Sitecode or @.Sitecode = '')
>and (PackageType = @.PackageType or @.PackageType = '')
>and (RequiredItems = @.RequiredItems or @.RequiredItems = -1)
>)HB on HA.VendorPackageId = HB.VendorPackageId
>and
>(
>CriteriaId in
>(
>select CriteriaID from ValidItemCriteria
>where Destination = @.Destination
>and LengthOfStay = @.LengthOfStay
>and Ages = @.Ages
>and ComponentType = 'H'
>and (ValidItemType = @.HotelValidItemType_1 or @.HotelValidItemType_1 = '' )
>and (ItemValue = @.HotelItemValue_1 or @.HotelItemValue_1 = '' )
>)
>)
I think that the optimizer has decided to start with reducing the number
of matching rows in Criteria by checking the CriteriaId in (...)
condition. Criteria rows that match are then used in the join against
ValidVendorPackages (note: the derived table is easily transformed in a
simple join; the optimizer will probably execute it as a simple join).
Obviously, you have a nonclustered index on the column VendorPackageId in
ValidVendorPackages. In order to check the other conditions (on Vendor,
Sitecode, PackageType and RequiredItems) as well, SQL Server has to fetch
the complete row. The nonclustered index used to find the VendorPackageId
will also contain the values for the clustered index on this table: they
serve as a pointer to the complete row. SQL Server will now take these
values and use them to navigate the clustered index down to the row that
corresponds to the index entry. This action (using the clustered index
values stored in the nonclustered index to find the row) is called a
bookmark lookup.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

Book on Business Intelligent Reports ?

Does any one know of a good reference or book dealing specifically with Business Intelligent Reports? I need to figure out how to fully utilize the reports.

Thanks
CalSurely someone has an answer to this question.

Calsql

Bold on Matrix subtotal

Hello all,
Does anyone know how to make a subtotal column on a matrix report bold? I
can bold all data but can't seem to figure out how to only do the subtotal
column.
Thanks!!Hi,
Matrix subtotal properties can be set by clicking on the green triangle in
the upper right corner of the "subtotal" text box. You could also right-click
on this triangle and select "properties".
"anthonysjo" wrote:
> Hello all,
> Does anyone know how to make a subtotal column on a matrix report bold? I
> can bold all data but can't seem to figure out how to only do the subtotal
> column.
> Thanks!!|||When I do this it just bolds the header not the data. The only way I can get
the data in that column bolded it to bold it all....
"Gavin R" wrote:
> Hi,
> Matrix subtotal properties can be set by clicking on the green triangle in
> the upper right corner of the "subtotal" text box. You could also right-click
> on this triangle and select "properties".
> "anthonysjo" wrote:
> > Hello all,
> >
> > Does anyone know how to make a subtotal column on a matrix report bold? I
> > can bold all data but can't seem to figure out how to only do the subtotal
> > column.
> >
> > Thanks!!|||Use InScope()
eg: in the Text-Field for the Value goto Properties-Font-FontWeight
use something like =IIF(InScope("RowGroupName") AND InScope("ColGroupName"),
"Normal", "Bold")
This will format all Subtotals (Multiple Groups, Row-Subtotals and
Col-Subtotals) to Bold.
If you need more control use multiple IIFs.
Read the Help for InScope.
And search this Forum for InScope for more hints.
LG HOLAN
"anthonysjo" wrote:
> When I do this it just bolds the header not the data. The only way I can get
> the data in that column bolded it to bold it all....
> "Gavin R" wrote:
> > Hi,
> >
> > Matrix subtotal properties can be set by clicking on the green triangle in
> > the upper right corner of the "subtotal" text box. You could also right-click
> > on this triangle and select "properties".
> >
> > "anthonysjo" wrote:
> >
> > > Hello all,
> > >
> > > Does anyone know how to make a subtotal column on a matrix report bold? I
> > > can bold all data but can't seem to figure out how to only do the subtotal
> > > column.
> > >
> > > Thanks!!

Bold Axis

I have a line chart with ammounts both above and below 0, and I would
like to make the grid line for 0 be bold, but I can't figure out how to
make this happen. I know in the format box for the line thickness I
need something like this:
=Iif('?=0, 2pt, 3pt)
I just can't think of what I'm comparing with. There has to be
something I'm missing.Did you get the answer if so please let me know
i tried with iff(me.value=0, 1pt,2pt)
but no result
If u got answer please provide me the answer
"MegaGreg" wrote:
> I have a line chart with ammounts both above and below 0, and I would
> like to make the grid line for 0 be bold, but I can't figure out how to
> make this happen. I know in the format box for the line thickness I
> need something like this:
> =Iif('?=0, 2pt, 3pt)
> I just can't think of what I'm comparing with. There has to be
> something I'm missing.
>

Blank Page...

I cannot figure out why I have a blank page in front of my report. I have
hunted and hunted to see what I have set that would be causing this. The
blank page is generated when I print to paper, Adobe or Excel but not in the
preview.
Any suggestions?
Thanks!On Apr 18, 10:16 am, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> I cannot figure out why I have a blank page in front of my report. I have
> hunted and hunted to see what I have set that would be causing this. The
> blank page is generated when I print to paper, Adobe or Excel but not in the
> preview.
> Any suggestions?
> Thanks!
Firstly, you will want to make sure that all of your controls'
properties (where possible) are set to 'Fit table on one page if
possible.' Make sure that none of the controls' properties have a page
break after groups, etc. If this does not resolve the issue, try to
put the table controls, etc inside a rectangle. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you - the second suggestion did the trick!
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176911441.964042.82780@.b58g2000hsg.googlegroups.com...
> On Apr 18, 10:16 am, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
>> I cannot figure out why I have a blank page in front of my report. I have
>> hunted and hunted to see what I have set that would be causing this. The
>> blank page is generated when I print to paper, Adobe or Excel but not in
>> the
>> preview.
>> Any suggestions?
>> Thanks!
> Firstly, you will want to make sure that all of your controls'
> properties (where possible) are set to 'Fit table on one page if
> possible.' Make sure that none of the controls' properties have a page
> break after groups, etc. If this does not resolve the issue, try to
> put the table controls, etc inside a rectangle. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 18, 1:57 pm, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> Thank you - the second suggestion did the trick!
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176911441.964042.82780@.b58g2000hsg.googlegroups.com...
> > On Apr 18, 10:16 am, "Chris Marsh" <cma...@.synergy-intl.com> wrote:
> >> I cannot figure out why I have a blank page in front of my report. I have
> >> hunted and hunted to see what I have set that would be causing this. The
> >> blank page is generated when I print to paper, Adobe or Excel but not in
> >> the
> >> preview.
> >> Any suggestions?
> >> Thanks!
> > Firstly, you will want to make sure that all of your controls'
> > properties (where possible) are set to 'Fit table on one page if
> > possible.' Make sure that none of the controls' properties have a page
> > break after groups, etc. If this does not resolve the issue, try to
> > put the table controls, etc inside a rectangle. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

blank lines

This may be an incredibly easy fix, but I can't figure it out!

I'm working with xp_sendmail, and I'm trying to get it send out 2 separate queries.

The problem is that in the body of the e-mail, it puts the right after each other, so it's kind of bad to look at.

Is there any way I can insert a few blanks lines in between these 2 queries ? I tried a simple "print ' ' ", but I get access violation errors.

Suggestions?Well, this may not be an elegant solution, but you can always place a few statements like:

select ''

between your queries to add some blank space. Actually, this may print line separators defpending on your connection configuration, but you can also try something like this:

select char(13) + char(13) + char(13) + char(13) + char(13)

...which will pad your output with five carriage returns.

blindman|||Well that works, but as you said, the line separator shows up, which is kind of an eyesore. Do you or anyone else know any workarounds to this?|||Use the Char(13) method and you can include as many line-feeds as you want and you should only get one separator for the statement.

blindman