Install Error with Sept CTP

Hi all,
I am running into install error when prompted "PLEASE INSERT DISC
2" when I am installing with virtual drive using Daemon Tools instead of from
CD or DVD. I am a Universal MSDN Download Subscriber, but apparently MSDN don't support install issue with beta version of their product. I am stuck with not able to use this app, and any help is much appreciated.

Sincerely,
-Lawrence
Lawrence, A possible problem is that you didn't notice that some builds of Sept CTP come as two separate images - Server and Tools. I assume you downloaded Server only. Andrew Watt MVP - InfoPath wrote in message news:4aa66c60-7142-4d86-ba1c-77895be5c54d@.discussions.microsoft.com...
> Hi all,
> I am running into install error when prompted "PLEASE INSERT DISC
> 2" when I am installing with virtual drive using Daemon Tools instead of
> from
> CD or DVD. I am a Universal MSDN Download Subscriber, but apparently
> MSDN don't support install issue with beta version of their product. I
> am stuck with not able to use this app, and any help is much
> appreciated. >
> Sincerely,
> -Lawrence|||you need to download both .ISO files, servers and tools. Just load the tools .iso file in the same drive, and you should be fine.
|||To be clear, there are two files you need to download:

Disk1: en_SQL2005_DEV_Servers_Sept2005.iso
Disk2: en_SQL2005_DEV_Tools_Sept2005.iso

You need both of them.|||Great! I did not know Tools ISO would also be needed together with the Server ISO. Typically installation uses one ISO, and Server contains all necessary components. Was that mentioned in MSDN that Tools is also required? This has caused considerable confusion.

Thanks for your assistance!
-Lawrence

instalation mistake

I have made a mistake when I have installed SQL server.
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
Ales
If I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:

> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>
|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pe v diskusnm pspvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>

instalation mistake

I have made a mistake when I have installed SQL server.
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
AlesIf I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:

> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pe v diskusnm pspvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>

instalation mistake

I have made a mistake when I have installed SQL server.
I have installed Personal edition instead of standard edition.
How to change sql server edition from personal to standard if I have some
databases active?
AlesIf I were you, I would backup the DBs, uninstall personal and install
standard and then restore the DBs. Barring that, is it possible to run an
instance of standard side by side and transfer the DBs through a dump and
load? Unless you can upgrade editions(don't beleive you can), you are going
to ave to backup and restore anyway.
"Ales Baranek" wrote:
> I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>
>|||Hi,
It requires downtime.
(info from books online)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
Thanks
Hari
SQL Server MVP
"Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>I have made a mistake when I have installed SQL server.
> I have installed Personal edition instead of standard edition.
> How to change sql server edition from personal to standard if I have some
> databases active?
> Ales
>|||And what about the databases?
SQL personal is with SP3 now and upgrade will be without any SP. I will have
to install this SP3 on the new standard edition. Does it affect databases?
Ales
"Hari Prasad" <hari_prasad_k@.hotmail.com> pí¹e v diskusním pøíspìvku
news:%23yFWGy3oFHA.1372@.TK2MSFTNGP10.phx.gbl...
> Hi,
> It requires downtime.
> (info from books online)
> To upgrade a SQL Server 2000 installation to a different edition of SQL
> Server 2000
> 1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
> you want to install into your CD-ROM drive. If the compact disc does not
> autorun, double-click Autorun.exe in the root directory of the compact
> disc.
>
> 2.. Select SQL Server 2000 Components, select Install Database Server,
> and then setup prepares the SQL Server Installation Wizard. At the Welcome
> screen, click Next.
>
> 3.. In Computer Name dialog box, select Local Computer or Remote
> computer.
>
> 4.. In the Installation Selection dialog box, click Upgrade, Remove, or
> Add Components to an existing instance of SQL Server, and then click Next.
>
> 5.. In the Instance Name dialog box, click Next.
>
> 6.. In the Existing Installation dialog box, click Upgrade your existing
> installation, and then click Next.
>
> 7.. If Setup detects that you are doing an edition upgrade, the Upgrade
> dialog box appears. Click Yes, Upgrade my <text specific to the upgrade>
> to upgrade the feature set of your current installation, and click Next.
>
> 8.. After the upgrade is completed, you are prompted as to whether you
> want to install additional components. If you click Yes, the Select
> Components dialog box appears. Accept the defaults or select the
> additional components you want to install, and then click Next.
> You can select an item in the Components list, and then select items from
> the related Sub-Components list. Click to select items you want to
> install; clear the check box of the items you do not want to install.
> 9.. When you are finished specifying options, in the Start Copying Files
> dialog box, click Next.
>
> 10.. In the Setup Complete dialog box, click Yes, I want to restart my
> computer now, and then click Finish to complete the edition upgrade.
> Thanks
> Hari
> SQL Server MVP
>
> "Ales Baranek" <barda@.staryhrozenkov.cz> wrote in message
> news:OXkcO42oFHA.3608@.TK2MSFTNGP15.phx.gbl...
>>I have made a mistake when I have installed SQL server.
>> I have installed Personal edition instead of standard edition.
>> How to change sql server edition from personal to standard if I have some
>> databases active?
>> Ales
>>
>

Inserting Zero instead of Null

Hi Guys,

I have the following SQL Code:

SELECT TOP (100) PERCENT

CAST(Item AS nvarchar(32)) AS Item,

CAST(Customer AS nvarchar(12)) AS Customer,

CAST(Warehouse AS nvarchar(12)) AS Warehouse,

MAX(CASE WHEN InvMonth = 'INV1' THEN CAST(Qty AS numeric(8, 0)) END) AS INV1,

MAX(CASE WHEN InvMonth = 'INV2' THEN CAST(Qty AS numeric(8, 0)) END) AS INV2,
MAX(CASE WHEN InvMonth = 'INV3' THEN CAST(Qty AS numeric(8, 0)) END) AS INV3,

MAX(CASE WHEN InvMonth = 'INV4' THEN CAST(Qty AS numeric(8,0)) END) AS INV4,

MAX(CASE WHEN InvMonth = 'INV5' THEN CAST(Qty AS numeric(8, 0)) END) AS INV5,
MAX(CASE WHEN InvMonth = 'INV6' THEN CAST(Qty AS numeric(8, 0)) END) AS INV6

FROM MVXReport.DMSExportStage1
GROUP BY CAST(Item AS nvarchar(32)), CAST(Customer AS nvarchar(12)), CAST(Warehouse AS nvarchar(12))
ORDER BY Item, Customer

And i am getting the following Results:

T100 APGL 10 1 6 2 1 3 3
T100 AUTOONE 10 NULL NULL NULL NULL NULL NULL
T100 CBCNSW 10 NULL NULL NULL NULL NULL NULL
T100 CBCQLD 10 NULL NULL NULL NULL 2 3
T100 CBCSA 10 NULL NULL NULL NULL NULL NULL
T100 CBCVIC 10 NULL NULL NULL NULL NULL NULL

I would like to know how to insert a 0 (zero) when the qty is null.. I have tried :

MAX(CASE WHEN InvMonth = 'INV1' THEN (CASE WHEN QTY IS NULL THEN (CAST(0 AS numeric(8, 0))) ELSE CAST(Qty AS numeric(8, 0)) END) END) AS INV1,

But it didnt seem to work.. If someone could point me in the right direction that would be wonderful..

thanks

Scotty

You could use COALESCE function for this task. Try change

CASE WHEN QTY IS NULL THEN (CAST(0 AS numeric(8, 0))) ELSE CAST(Qty AS numeric(8, 0)) END

to COALESCE(QTY,0)

|||

Try something like this:

isnull( Qty, 0 )

in each location where you have just Qty.

|||

Thanks Guys,

I have tried both of your solutions, but i am still getting null values. I can see why, as in the file that i am building these columns from, not every customer/Item every month has a record.. Hence why it is bringing back NULL..

Any other ideas...

thnkas

scotty

|||try this one instead

SELECT TOP (100) PERCENT
CAST(Item AS nvarchar(32)) AS Item,
CAST(Customer AS nvarchar(12)) AS Customer,
CAST(Warehouse AS nvarchar(12)) AS Warehouse,
COALESCE(MAX(CASE WHEN InvMonth = 'INV1' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV1,
COALESCE(MAX(CASE WHEN InvMonth = 'INV2' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV2,
COALESCE(MAX(CASE WHEN InvMonth = 'INV3' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV3,
COALESCE(MAX(CASE WHEN InvMonth = 'INV4' THEN CAST(Qty AS numeric(8,0)) END),0) AS INV4,
COALESCE(MAX(CASE WHEN InvMonth = 'INV5' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV5,
COALESCE(MAX(CASE WHEN InvMonth = 'INV6' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV6
FROM MVXReport.DMSExportStage1
GROUP BY
CAST(Item AS nvarchar(32)),
CAST(Customer AS nvarchar(12)),
CAST(Warehouse AS nvarchar(12))
ORDER BY
Item
, Customer|||

use

MAX(Isnull(CASE WHEN InvMonth = 'INV1' THEN CAST(Qty AS numeric(8, 0)) END,0)) AS INV1

--or

Isnull(MAX(CASE WHEN InvMonth = 'INV2' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV2