Drop Primary key constraint of (#) Hash

Hi there,

I have created a hash table. After using it, somehow the primary key
constraint of this hash table still exist in database. Which cause
error.

When I delete this constraint with Alter table Drop con...
It gives no table exist error.

Can anybody give any idea.

Thanks in Adv.,
T.S.Negi> I have created a hash table. After using it, somehow the primary key
> constraint of this hash table still exist in database. Which cause
> error.

I assume that by "hash table" you mean a temporary table? What makes you
think that the PK exists after the table is dropped? (Don't trust the output
of Enterprise Manager as that isn't always refreshed when you would expect
it to be) What error is caused and what is the code that produces the error?

--
David Portas
SQL Server MVP
--|||tilak.negi@.mind-infotech.com (T.S.Negi) wrote in message news:<a1930058.0408102110.40ec8809@.posting.google.com>...
> Hi there,
> I have created a hash table. After using it, somehow the primary key
> constraint of this hash table still exist in database. Which cause
> error.
> When I delete this constraint with Alter table Drop con...
> It gives no table exist error.
>
> Can anybody give any idea.
> Thanks in Adv.,
> T.S.Negi

I don't quite understand your issue - this works fine for me:

create table #t (col1 int not null)
alter table #t add constraint PK_t primary key (col1)
alter table #t drop constraint PK_t
drop table #t

It would be best to post your version of MSSQL, the exact error
messages you get, as well as some explanation of why you believe the
constraint exists but the table doesn't.

Simon

drillthrough on a L30 Days Calculation in Excel - somehow?

I understand that calculated measures can't be coupled with drillthrough, but maybe there's another way.

I define a calculated measure with a L30 days flag that starts on the last day with order data. Now if I use this flag in conjunction with the Order Sales measure, then I can do a drillthrough. Problem is, with excel (2000 version), how could I get last 30 days w/o using the calculated measure?

Is there a way to define a measure with a combination of attribute filters that would allow drillthrough and also be accessible from excel and last but not entirely needed: have the definition housed in the AS project so that it's logic is centralized and reusable?

What version of the Analysis Services do you have?

What calculation do you use to determinate current date and last 30 days?

|||

I'm using ssas 2005 sp2

The calculation is: SUM([L30 Days].&[Yes], [Sales])

|||You could try setting up a many to many relationship although this might require having two date dimensions, one that is linked to the actual date and one that is linked via an intermediate measure group to itself and the previous 29 days. Marco Russo's whitepaper on many to many relationships at www.sqlbi.eu shows how drilltrhough works with many to many relationships.

Drilldown and graphs

Is it possible to somehow create charts that support drilldown? E.g. a
pie-chart where you can click any area in the chart which will redirect you
to another report?
Thank you for any help.
Regards, Jakob.
--
http://www.dotninjas.dkYes you can do that. In the chart properties dialog on the Data tab, select
a Value and edit its properties. The Action tab contains what you're looking
for.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jakob Christensen" <jch@.REMOVEpension.dk> wrote in message
news:77AB990F-9281-403B-9514-019D7DF86382@.microsoft.com...
> Is it possible to somehow create charts that support drilldown? E.g. a
> pie-chart where you can click any area in the chart which will redirect
> you
> to another report?
> Thank you for any help.
> Regards, Jakob.
> --
> http://www.dotninjas.dk|||Thank you :-)
"Robert Bruckner [MSFT]" wrote:
> Yes you can do that. In the chart properties dialog on the Data tab, select
> a Value and edit its properties. The Action tab contains what you're looking
> for.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jakob Christensen" <jch@.REMOVEpension.dk> wrote in message
> news:77AB990F-9281-403B-9514-019D7DF86382@.microsoft.com...
> > Is it possible to somehow create charts that support drilldown? E.g. a
> > pie-chart where you can click any area in the chart which will redirect
> > you
> > to another report?
> >
> > Thank you for any help.
> >
> > Regards, Jakob.
> >
> > --
> > http://www.dotninjas.dk
>
>