RE: RE: SQL Server 2005

RE: RE: SQL Server 2005

 

  

Trevor,
A million thanks!


________________________________

From: tweir [mailto:mssqldba-ezmlmshield-x62046399.[Email address protected]
Sent: Mon 10/31/2005 9:21 AM
To: LazyDBA Discussion
Subject: Re: RE: SQL Server 2005



Looks Like I found the answer to one:

Easy Package Configuration:

http://www.sqlis.com/default.aspx?26

Trevor

From: "tweir" <mssqldba-ezmlmshield-x79601566.[Email Address Removed]
Subject: Re: RE: SQL Server 2005
Date: Fri, 02 Sep 2005 12:38:22 -0400




Ed,

From what I understand about the Integration Services in the BETA, if
you can't directly convert your existing DTS Package, you can run a
utility named DTS2000 to run your existing packages.

According to a post on the Microsoft Forums,

"You have the choice of whether to install the DTS2000 runtime or not
when you install SSIS"

One thing I did find (actually more like did NOT find) about
Integration Services is that there does not appear to be any means of
using Dynamic Properties tasks. I don't know if anyone has found a way
around this.

Trevor

----- Original Message -----
From: Edwards Ed <mssqldba-ezmlmshield-
x60659917.[Email address protected]
Date: Friday, September 2, 2005 10:14 am
Subject: RE: SQL Server 2005

> Ken,
> Thanks.
>
>
> -----Original Message-----
> From: Ken Ross
> [mailto:mssqldba-ezmlmshield-x90406431.[Email address protected]
> Sent: Friday, September 02, 2005 9:37 AM
> To: LazyDBA Discussion
> Subject: RE: SQL Server 2005
>
>
> It's still there... sort of (know how I said both those system queries
> "worked"?)
>
> DTS has "transformed" into Integration Services in 2005:
>
> http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx
>
> http://msdn.microsoft.com/sql/sqlwarehouse/ssis/default.aspx
>
> I've not used it (yet) myself but looks like they've taken the
> best of
> DTS, added "fuzzy logic" to it (and a number of other goodies) and
> renamed it. What I can't tell you is how well existing DTS
> packages will
> "upgrade" to IS (I'm sure there will be some kind of wizard for this
> though).
>
> Ken
>
>
> -----Original Message-----
> From: Edwards Ed
> [mailto:mssqldba-ezmlmshield-x13105583.[Email address protected]
> Sent: Friday, September 02, 2005 9:29 AM
> To: LazyDBA Discussion
> Subject: SQL Server 2005
>
> To All,
> Is it true that the DTS packages are being replaced in SQL Server
> 2005? If so, what will replace the DTS packages?
>
>
> -----Original Message-----
> From: tweir
> [mailto:mssqldba-ezmlmshield-x7740652.[Email address protected]
> Sent: Friday, September 02, 2005 9:25 AM
> To: LazyDBA Discussion
> Subject: Re: RE: Need Query Help
>
>
> You can use either of the 2 - DISTINCT --OR-- GROUP BY in the inner
> query; both will work fine, but use 1 or the other - do not combine
> them. In other words use 1 of the following for the inner query:
>
> select DISTINCT CustomerID,ProductMainGroupID
> from YourView
> where ProductMainGroupID in (2,3,12)
>
> OR
>
> select CustomerID,ProductMainGroupID
> from YourView
> where ProductMainGroupID in (2,3,12)
> group by CustomerID,ProductMainGroupID
>
>
> You do not need to use the DISTINCT clause in the inner query if
> you are
> using the GROUP BY clause. Both of the above queries will return the
> exact same results.
>
> Trevor
>
> ----- Original Message -----
> From: Ahmad Maredia <mssqldba-ezmlmshield- x13964844.[Email address
> protected]
> Date: Friday, September 2, 2005 8:18 am
> Subject: RE: Need Query Help
>
> > Sorry about the comment. I did obviously miss the point.
> >
> > However the Query given below will not give the required output
> as
> > well.A slight modification will make it work:
> >
> > select innerquery.CustomerID
> > FROM (
> > select DISTINCT CustomerID,ProductMainGroupID
> > from YourView
> > where ProductMainGroupID in (2,3,12)
> > group by CustomerID,ProductMainGroupID
> > ) as innerquery
> > Group by innerquery.CustomerID
> > Having Count(*) = 3
> >
> > -----Original Message-----
> > From: tweir
> > [mailto:mssqldba-ezmlmshield-x47603771.[Email address protected]
> > Sent: Friday, September 02, 2005 4:57 PM
> > To: LazyDBA Discussion
> > Subject: Re: Need Query Help
> >
> >
> > Sorry, I missed the alias after the subquery:
> >
> > select innerquery.CustomerID
> > FROM (
> > select CustomerID,ProductMainGroupID
> > from YourView
> > where ProductMainGroupID in (2,3,12)
> > group by CustomerID,ProductMainGroupID
> > ) as innerquery
> > Group by innerquery.CustomerID
> > Having Count(*) = 3
> >
> >
> > ----- Original Message -----
> > From: <[Email address protected]
> > Date: Friday, September 2, 2005 7:22 am
> > Subject: Re: Need Query Help
> >
> > > Chakry, try this...
> > >
> > > select CustomerID
> > > FROM (
> > > select CustomerID,ProductMainGroupID
> > > from YourView
> > > where ProductMainGroupID in (2,3,12)
> > > group by CustomerID,ProductMainGroupID
> > > )
> > > Group by CustomerID
> > > Having Count(*) = 3
> > >
> > > Trevor
> > >
> > >
> > > ----- Original Message -----
> > > From: Chakry <mssqldba-ezmlmshield-x10575189.[Email address
> > protected]> Date: Friday, September 2, 2005 1:08 am
> > > Subject: Need Query Help
> > >
> > > > I have a view like this
> > > >
> > > > CustomerId ProductMainGroupId
> > > > ------------------------------
> > > > 2748 3
> > > > 2748 3
> > > > 2748 2
> > > > 2748 3
> > > > 2748 3
> > > > 2748 3
> > > > 2748 12
> > > > 2748 3
> > > > 2748 3
> > > > 2750 3
> > > > 2750 3
> > > > 2750 3
> > > > 2761 2
> > > > 2761 2
> > > > 2761 2
> > > > 2762 3
> > > > 2762 3
> > > > 2764 3
> > > > 2764 3
> > > > 2764 3
> > > > 7865 2
> > > > 7867 2
> > > > 7867 2
> > > > 7867 12
> > > > 7867 12
> > > > 7867 12
> > > > 7867 12
> > > > 7867 12
> > > > 7867 12
> > > >
> > > > I need to find CustomerIds who bought products belongs to
> > > > ProductMainGroup2,3 and 12(all the 3). From the above list
> > > answer
> > > > is 2748.
> > > > Can anybody help me with a query for the same.
> > > >
> > > > Thanks & Regards,
> > > > Chakry.
> > > >
> > > >
> > > >
> > > > -------------------------------------------------------------
> --
> > --
> > > --
> > > > --
> > > > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST
> REPLY
> > > > Website : http://www.LazyDBA.com To unsubscribe:
> > > > http://www.lazydba.com/unsubscribe.html
> > > >
> > > >
> > >
> >
> >
> > -----------------------------------------------------------------
> --
> > --
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website
> > : http://www.LazyDBA.com To unsubscribe:
> > http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> >
> > -----------------------------------------------------------------
> --
> > --
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website
> > : http://www.LazyDBA.com To unsubscribe:
> > http://www.lazydba.com/unsubscribe.html
> >
> >
>
>
> -------------------------------------------------------------------
> --
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
>
> -------------------------------------------------------------------
> --
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
> -------------------------------------------------------------------
> --
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> -------------------------------------------------------------------
> --
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>

MS Sql Server LazyDBA home page



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page