need original disk for sp1 install? please tell me i don't...

hello
installing sp1 requires the original cd? please tell me i don't... i really
don't want to shuffle tons of files around so i can extract a 600mb file
just to install a service pack.
man, i hate this about msft... i'm always digging up original cds for
updates. what a pain. what's the reason for this?
dushan bilbijaPerhaps they're trying to discourage piracy?
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Dushan Bilbija" <dbilbija@.msn.com> wrote in message
news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> hello
> installing sp1 requires the original cd? please tell me i don't... i
> really
> don't want to shuffle tons of files around so i can extract a 600mb file
> just to install a service pack.
> man, i hate this about msft... i'm always digging up original cds for
> updates. what a pain. what's the reason for this?
> dushan bilbija
>|||We did our best to ensure you would not need the original media when
installing SP1. Windows installer has some quirks about it that can make
this a difficult goal to achieve. I have seen this issue happen when config
files are copied over top of existing config files. The modified dates and
create dates confuse the installer and make it think it needs to recreate
the file.
If you send me the setup log file I can see if this is an issue we can
resolve for our next service pack.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Perhaps they're trying to discourage piracy?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > hello
> >
> > installing sp1 requires the original cd? please tell me i don't... i
> > really
> > don't want to shuffle tons of files around so i can extract a 600mb file
> > just to install a service pack.
> >
> > man, i hate this about msft... i'm always digging up original cds for
> > updates. what a pain. what's the reason for this?
> >
> > dushan bilbija
> >
> >
>|||you'd think that was the reason... but how would they achieve that with the
original cd? a nice cd burner takes care of that problem. a quick google
search gives you any cd key you need.
btw... where's the guide for vb.net and sql2005? :)
dushan
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Perhaps they're trying to discourage piracy?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > hello
> >
> > installing sp1 requires the original cd? please tell me i don't... i
> > really
> > don't want to shuffle tons of files around so i can extract a 600mb file
> > just to install a service pack.
> >
> > man, i hate this about msft... i'm always digging up original cds for
> > updates. what a pain. what's the reason for this?
> >
> > dushan bilbija
> >
> >
>|||hi daniel
i'll email you the log file... maybe it'll help debug the install.
in the meantime, i've found a workaround... i dnloaded the eval install, and
used that instead. the original cd is on our corporate network, and i didn't
have access to it.
thanks for the quick reply!
dushan
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23wLRh8ujEHA.2500@.TK2MSFTNGP09.phx.gbl...
> We did our best to ensure you would not need the original media when
> installing SP1. Windows installer has some quirks about it that can make
> this a difficult goal to achieve. I have seen this issue happen when
config
> files are copied over top of existing config files. The modified dates
and
> create dates confuse the installer and make it think it needs to recreate
> the file.
> If you send me the setup log file I can see if this is an issue we can
> resolve for our next service pack.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > Perhaps they're trying to discourage piracy?
> >
> > --
> > ____________________________________
> > William (Bill) Vaughn
> > Author, Mentor, Consultant
> > Microsoft MVP
> > www.betav.com
> > Please reply only to the newsgroup so that others can benefit.
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > __________________________________
> >
> > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > > hello
> > >
> > > installing sp1 requires the original cd? please tell me i don't... i
> > > really
> > > don't want to shuffle tons of files around so i can extract a 600mb
file
> > > just to install a service pack.
> > >
> > > man, i hate this about msft... i'm always digging up original cds for
> > > updates. what a pain. what's the reason for this?
> > >
> > > dushan bilbija
> > >
> > >
> >
> >
>|||oops... spoke too soon.
the install i have is enterprise edition... so i still need the cd.
dushan
"Dushan Bilbija" <dbilbija@.msn.com> wrote in message
news:Os9KZGvjEHA.3392@.TK2MSFTNGP15.phx.gbl...
> hi daniel
> i'll email you the log file... maybe it'll help debug the install.
> in the meantime, i've found a workaround... i dnloaded the eval install,
and
> used that instead. the original cd is on our corporate network, and i
didn't
> have access to it.
> thanks for the quick reply!
> dushan
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23wLRh8ujEHA.2500@.TK2MSFTNGP09.phx.gbl...
> > We did our best to ensure you would not need the original media when
> > installing SP1. Windows installer has some quirks about it that can
make
> > this a difficult goal to achieve. I have seen this issue happen when
> config
> > files are copied over top of existing config files. The modified dates
> and
> > create dates confuse the installer and make it think it needs to
recreate
> > the file.
> >
> > If you send me the setup log file I can see if this is an issue we can
> > resolve for our next service pack.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> > news:uvzPn1ujEHA.2544@.TK2MSFTNGP10.phx.gbl...
> > > Perhaps they're trying to discourage piracy?
> > >
> > > --
> > > ____________________________________
> > > William (Bill) Vaughn
> > > Author, Mentor, Consultant
> > > Microsoft MVP
> > > www.betav.com
> > > Please reply only to the newsgroup so that others can benefit.
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > __________________________________
> > >
> > > "Dushan Bilbija" <dbilbija@.msn.com> wrote in message
> > > news:%235YheoujEHA.2908@.tk2msftngp13.phx.gbl...
> > > > hello
> > > >
> > > > installing sp1 requires the original cd? please tell me i don't... i
> > > > really
> > > > don't want to shuffle tons of files around so i can extract a 600mb
> file
> > > > just to install a service pack.
> > > >
> > > > man, i hate this about msft... i'm always digging up original cds
for
> > > > updates. what a pain. what's the reason for this?
> > > >
> > > > dushan bilbija
> > > >
> > > >
> > >
> > >
> >
> >
>

Need Kick in right direction w/query take 2

Bumping this up to the top, scroll down a bit to see the original thread.
--
I have updated the DDL with the actual tables and a sample of table data of
what I am actually using.
http://damageinc.org/DDL.html (The DDL is too large to post, the message
gets kicked back to me)
AFter you enter that DDL
If you run the query..
SELECT Apps.AppName, Tests.TestCase, TestCases.Type
FROM
TestCases
LEFT OUTER JOIN Apps ON TestCases.AppID = Apps.ID
LEFT OUTER JOIN Tests ON TestCases.TestID = Tests.ID
WHERE
(
(
(Proj1 = '87' OR Proj2 = '87' OR Proj3 = '87' OR Proj4 = '87' OR Proj5 =
'87')
OR
(Proj1 = '88' OR Proj2 = '88' OR Proj3 = '88' OR Proj4 = '88' OR Proj5 =
'88')
)
AND (TestCases.Card = 'G71_D' OR TestCases.Card = 'G70_D' OR TestCases.Card
= 'G72_D' OR TestCases.Card = 'G73_D')
AND TestCases.OS = 'Windows Vista'
)
GROUP BY AppName, TestCase,TestCases.Type
You will see
AppName TestCase
Type
3D Mark 2003 Benchmark: 1600x1200x32 4xAA 8x Aniso D3D Benchmarks
3D Mark 2003 Benchmark: 1600x1200x32 4xAA 8x Aniso Games
3D Mark 2003 Benchmark: Default 2x AA 4x Aniso D3D
Benchmarks
3D Mark 2003 Benchmark: Default 2x AA 4x Aniso G ames
.
.
.
.
There are 97 tests there.
What I need is that 97 for the count, then the count of the most recent
pass/fail result(s) (if there is a result) for each of those tests.
Using
Select Count(*) As 'Count',
Sum(Case When Result = 'Pass' Then 1 Else 0 End) As 'Pass',
Sum(Case When Result = 'Fail' Then 1 Else 0 End) As 'Fail'
From Reports r
Where r.ReportDate In
(Select Max(r.ReportDate)
From Reports r
Inner Join TestCases tc On r.TestCaseID = tc.ID
Inner Join Tests t On tc.TestID = t.ID
Inner Join Apps a On tc.AppID = a.ID
WHERE
(
(
(tc.Proj1 = '87' OR tc.Proj2 = '87' OR tc.Proj3 = '87' OR tc.Proj4 = '87'
OR tc.Proj5 = '87')
OR
(tc.Proj1 = '88' OR tc.Proj2 = '88' OR tc.Proj3 = '88' OR tc.Proj4 = '88'
OR tc.Proj5 = '88')
)
AND (tc.Card = 'G71_D' OR tc.Card = 'G70_D' OR tc.Card = 'G72_D' OR tc.Card
= 'G73_D')
AND tc.OS = 'Windows Vista'
)
Group By a.AppName, t.TestCase)
Gives me
Count Pass Fail
25 2 23
Which is obviously wrong, since the Count should be 97.
I have to be overthinking something here...I think this works:
SELECT Count(*) As 'Count',
Sum (Case When r.Result = 'Pass' Then 1 Else 0 End) As 'Pass',
Sum (Case When r.Result = 'Fail' Then 1 Else 0 End) As 'Fail'
From Reports r
Inner Join TestCases tc On r.TestCaseID = tc.ID
LEFT OUTER JOIN Apps a ON tc.AppID = a.ID
LEFT OUTER JOIN Tests t ON tc.TestID = t.ID
Right Join (
SELECT a.AppName, t.TestCase, tc.Type, Max(Coalesce(r.ReportDate,
'1900-01-01'))As ReportDate
FROM TestCases tc
LEFT OUTER JOIN Apps a ON tc.AppID = a.ID
LEFT OUTER JOIN Tests t ON tc.TestID = t.ID
LEFT OUTER JOIN Reports r ON r.TestCaseID = tc.ID
WHERE
(
(
(Proj1 = '87' OR Proj2 = '87' OR Proj3 = '87' OR Proj4 = '87' OR Proj5 =
'87')
OR
(Proj1 = '88' OR Proj2 = '88' OR Proj3 = '88' OR Proj4 = '88' OR Proj5 =
'88')
)
AND (tc.Card = 'G71_D' OR tc.Card = 'G70_D' OR tc.Card = 'G72_D' OR tc.Card
= 'G73_D')
AND tc.OS = 'Windows Vista'
)
GROUP BY AppName, TestCase,tc.Type) x On r.ReportDate = x.ReportDate
Tom
"Lucas Graf" <lgraf2000@.comcast.net> wrote in message
news:%23zfcKfZmGHA.3880@.TK2MSFTNGP02.phx.gbl...
> Bumping this up to the top, scroll down a bit to see the original thread.
> --
> I have updated the DDL with the actual tables and a sample of table data
> of
> what I am actually using.
> http://damageinc.org/DDL.html (The DDL is too large to post, the message
> gets kicked back to me)
> AFter you enter that DDL
> If you run the query..
> SELECT Apps.AppName, Tests.TestCase, TestCases.Type
> FROM
> TestCases
> LEFT OUTER JOIN Apps ON TestCases.AppID = Apps.ID
> LEFT OUTER JOIN Tests ON TestCases.TestID = Tests.ID
> WHERE
> (
> (
> (Proj1 = '87' OR Proj2 = '87' OR Proj3 = '87' OR Proj4 = '87' OR Proj5 =
> '87')
> OR
> (Proj1 = '88' OR Proj2 = '88' OR Proj3 = '88' OR Proj4 = '88' OR Proj5 =
> '88')
> )
> AND (TestCases.Card = 'G71_D' OR TestCases.Card = 'G70_D' OR
> TestCases.Card
> = 'G72_D' OR TestCases.Card = 'G73_D')
> AND TestCases.OS = 'Windows Vista'
>
> )
> GROUP BY AppName, TestCase,TestCases.Type
>
> You will see
>
> AppName TestCase
> Type
> 3D Mark 2003 Benchmark: 1600x1200x32 4xAA 8x Aniso D3D Benchmarks
> 3D Mark 2003 Benchmark: 1600x1200x32 4xAA 8x Aniso Games
> 3D Mark 2003 Benchmark: Default 2x AA 4x Aniso D3D
> Benchmarks
> 3D Mark 2003 Benchmark: Default 2x AA 4x Aniso G ames
> .
> .
> .
> .
>
> There are 97 tests there.
> What I need is that 97 for the count, then the count of the most recent
> pass/fail result(s) (if there is a result) for each of those tests.
> Using
> Select Count(*) As 'Count',
> Sum(Case When Result = 'Pass' Then 1 Else 0 End) As 'Pass',
> Sum(Case When Result = 'Fail' Then 1 Else 0 End) As 'Fail'
> From Reports r
> Where r.ReportDate In
> (Select Max(r.ReportDate)
> From Reports r
> Inner Join TestCases tc On r.TestCaseID = tc.ID
> Inner Join Tests t On tc.TestID = t.ID
> Inner Join Apps a On tc.AppID = a.ID
> WHERE
> (
> (
> (tc.Proj1 = '87' OR tc.Proj2 = '87' OR tc.Proj3 = '87' OR tc.Proj4 =
> '87'
> OR tc.Proj5 = '87')
> OR
> (tc.Proj1 = '88' OR tc.Proj2 = '88' OR tc.Proj3 = '88' OR tc.Proj4 =
> '88'
> OR tc.Proj5 = '88')
> )
> AND (tc.Card = 'G71_D' OR tc.Card = 'G70_D' OR tc.Card = 'G72_D' OR
> tc.Card
> = 'G73_D')
> AND tc.OS = 'Windows Vista'
> )
> Group By a.AppName, t.TestCase)
> Gives me
> Count Pass Fail
> 25 2 23
>
> Which is obviously wrong, since the Count should be 97.
> I have to be overthinking something here...
>
>