drop out of stored procedure when found some data

Hi
I have a stored procedure which takes a while to run and returns some
data. I want to make
another version that just says is there some data to look at (boolean,
yes no). This should
run as quickly as possible so as soon as it finds theres any data to
look at it stops. Is
there any general way of doing this?
This has to work in oracle and sqlserver 2000.
Can this be done in SQL. I'm afraid I know very little about SQL so I
just don't know if its even possible?
thanks
fshard wrote:
> Hi
> I have a stored procedure which takes a while to run and returns some
> data. I want to make
> another version that just says is there some data to look at (boolean,
> yes no). This should
> run as quickly as possible so as soon as it finds theres any data to
> look at it stops. Is
> there any general way of doing this?
> This has to work in oracle and sqlserver 2000.
> Can this be done in SQL. I'm afraid I know very little about SQL so I
> just don't know if its even possible?
> thanks
> f
Use EXISTS:
IF EXISTS (SELECT ... /* something */)
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||> IF EXISTS (SELECT ... /* something */)
> --
> David Portas, SQL Server MVP
thanks for that, nice simple answer.

drop out of stored procedure when found some data

Hi
I have a stored procedure which takes a while to run and returns some
data. I want to make
another version that just says is there some data to look at (boolean,
yes no). This should
run as quickly as possible so as soon as it finds theres any data to
look at it stops. Is
there any general way of doing this?
This has to work in oracle and sqlserver 2000.
Can this be done in SQL. I'm afraid I know very little about SQL so I
just don't know if its even possible?
thanks
fshard wrote:
> Hi
> I have a stored procedure which takes a while to run and returns some
> data. I want to make
> another version that just says is there some data to look at (boolean,
> yes no). This should
> run as quickly as possible so as soon as it finds theres any data to
> look at it stops. Is
> there any general way of doing this?
> This has to work in oracle and sqlserver 2000.
> Can this be done in SQL. I'm afraid I know very little about SQL so I
> just don't know if its even possible?
> thanks
> f
Use EXISTS:
IF EXISTS (SELECT ... /* something */)
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||> IF EXISTS (SELECT ... /* something */)
> --
> David Portas, SQL Server MVP
thanks for that, nice simple answer.

driver's sqlallochandle on sql_handle_env failed

i have just installed sql clinet
(Microsoft SQL Enterprise Manager Microsoft Corporation Version: 8.0)
on windows XP sp2 . whenever i try to reg new sql servers through Enterprise
Mgr it gives me this error . it looks like its associated with ODBC . need to
figure out whats the problem
Thanks & Regards
Sid
Try applying SQL Server 2000 SP4 + Cumulative Hotfix Build 2187.
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en
http://www.microsoft.com/downloads/details.aspx?FamilyID=9c9ab140-bdee-44df-b7a3-e6849297754a&displaylang=en
http://www.microsoft.com/downloads/details.aspx?FamilyID=1705bd2f-1fb8-4ec8-b3db-0935361308c7&displaylang=en
http://www.microsoft.com/downloads/details.aspx?familyid=A643980A-26A4-44C1-9B50-53E20E7210B5&displaylang=en
http://www.microsoft.com/downloads/details.aspx?FamilyId=243A8A89-74D6-48FD-933F-32FF9D8459C2&displaylang=en
http://www.microsoft.com/downloads/details.aspx?FamilyId=2BB62F35-D041-42AC-98DA-6EC97168BE21&displaylang=en
Sincerely,
Anthony Thomas

"moharil" <sid_m15@.yahoo.com> wrote in message
news:DCFB87D2-813A-4707-8D8B-9EDB6E781058@.microsoft.com...
> i have just installed sql clinet
> (Microsoft SQL Enterprise Manager Microsoft Corporation Version: 8.0)
> on windows XP sp2 . whenever i try to reg new sql servers through
Enterprise
> Mgr it gives me this error . it looks like its associated with ODBC . need
to
> figure out whats the problem
> --
> Thanks & Regards
> Sid

Driver for paradox

Hi, I'm looking for driver to transfer data for paradox DB to sql DB,
It's the last version of the paradox and the DTS in the sql doesn't
help,
Someone have advice?Hi
The latest Microsoft driver for paradox should be in the latest version of
MDAC, if this is not suitable you should contact Borland.
John
"noam" wrote:

> Hi, I'm looking for driver to transfer data for paradox DB to sql DB,
> It's the last version of the paradox and the DTS in the sql doesn't
> help,
> Someone have advice?
>|||Hi
The latest Microsoft driver for paradox should be in the latest version of
MDAC, if this is not suitable you should contact Borland.
John
"noam" wrote:

> Hi, I'm looking for driver to transfer data for paradox DB to sql DB,
> It's the last version of the paradox and the DTS in the sql doesn't
> help,
> Someone have advice?
>

Driver for paradox

Hi, I'm looking for driver to transfer data for paradox DB to sql DB,
It's the last version of the paradox and the DTS in the sql doesn't
help,
Someone have advice?Hi
The latest Microsoft driver for paradox should be in the latest version of
MDAC, if this is not suitable you should contact Borland.
John
"noam" wrote:
> Hi, I'm looking for driver to transfer data for paradox DB to sql DB,
> It's the last version of the paradox and the DTS in the sql doesn't
> help,
> Someone have advice?
>

Drill through in migrated cubes ?

We have some migrated cubes that implemented drillthrough in Analysis Services 2000 and appear to have drill through in the migrated version if viewed through Proclarity. But when I look at the cube in the 2005 BI studio, I see no structure to implement this drill through. Nor am I able to drill through from the Management Suite--just Proclarity.

What's going on ?

Dan,

Drillthrough has gone through significant changes in AS2005. The following is a link to a good whitepaper on the topic:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_anservdrill.asp

What you are seeing in ProClarity is "backward compatibility" support that was built into our 6.1 release. If you build a "Drillthrough Action" in AS 2005 it will show up in the cube browser used by the BI Studio.

HTH,

- Steve

|||

Steve:

I appreciate the help, but am a little confused.

First, my group has implemented drill through in 2005 using the concept of a degernate dimension on new (i.e., NOT migrated) cubes.

Our confusion occurs becauses migrated cubes exhibit drill through when viewed in Proclarity, but do not have a degernate dimension when examined in the BI 2005 Development Suite.

So, where is Proclarity getting the drill through data from ?

The answer apparently must be that SQL Server Analysis Services 2005 implements an "alternate drill through capability" that cannot be built using the 2005 BI Suite at all, but can only be created by first building a cube in 2000, and then migrating it.

Is this true ?

So, why is this all relevant to us ? Because we wish to add a field to the drill thru in the migrated cube.

|||

Dan,

If you can email me a phone number at spontello@.proclarity.com we can discuss the specifics.

- Steve

|||

Steve,

Is there a way to turn off this "Drill to detail" feature at the PAS server level?

Or to map the "Drill to detail" action to a Drillthrough action that was specifically created by the cube designer?

Thanks,

JGP

|||

JGP,

This could be done by customizing the PAS code. If you want more details send me an email at spontello@.proclarity.com.

- Steve