RE: sql vs excel

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 01:49:08 -0800

Sorry, post the wrong thread....

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> You can create a DTS package in SQL server and then have MSDE run it. MSDE
> has the runtime for DTS.
>
> Regards
> Mike
>
> "Nikolami" wrote:
>
> > Does anyone know solution for this:
> > if I insert recordset into database, depends on datetime, other record will
> > be change value.
> > Something like this:
> > If I insert new record with datetime other record will change value and the
> > same is when I update some record.
> >
> > 1;Nik;02.19.2005;1000;50
> > 5;Nik5;02.20.2005;1050;10 //insert new record, rest record
> > will change value
> > 2;Nik2;02.21.2005;1050;30 //2;Nik2;02.21.2005;1060;30
> > 3;Nik3;02.21.2005;1080;10 //3;Nik3;02.21.2005;1090;10
> > 4;Nik4;02.22.2005;1090;10 //4;Nik4;02.22.2005;2000;10
> >
> >
> >

Relevant Pages

  • Re: MSDE and DTS packages
    ... I'm guessing you want to import dts packages into MSDE (if not my ... If you have a SQL Server then you can also use enterprise manager to simply ... > I have exported the dts package to a text file, but when I import it into ... I have looked in MSDN and found the dtswiz with command line switchs, ...
    (microsoft.public.sqlserver.msde)
  • Re: Torn pages with DL560 and SmartArray 5302-128 controller
    ... Mike Epprecht (SQL MVP) wrote: ... > Mike Epprecht, Microsoft SQL Server MVP ... The replacement card is already ordered from CQP and should arrive shortly. ...
    (microsoft.public.sqlserver.server)
  • Re: Source control integration with MSSQL 2000.
    ... Mike Epprecht (SQL MVP) wrote: ... I am not in marketing. ... mention this is a public newsgroup, ...
    (microsoft.public.sqlserver.server)
  • Re: Number of SQL Server logins
    ... "Mike Epprecht (SQL MVP)" wrote in message ... > Can't find documentation, but master.dbo.syslogins does not use a counter. ... > "Oscar" wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: Linked Servers?
    ... "Mike Epprecht (SQL MVP)" wrote .. ... as far as I am aware....the two machines in the cluster are ...
    (microsoft.public.sqlserver.programming)