RE: sql vs excel

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

Date: Tue, 22 Feb 2005 01:11:03 -0800

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: DTS error -21472887 (80040E21)
    ... Please do not post the same question independently to multiple newsgroups. ... Please see my reply in .msde ... can be cut and pasted into Query Analyzer is appreciated. ... > Trying to run a DTS package from a stored procedure using xp_cmdshell but ...
    (microsoft.public.sqlserver.security)
  • RE: sql vs excel
    ... "Mike Epprecht (SQL MVP)" wrote: ... > You can create a DTS package in SQL server and then have MSDE run it. ...
    (microsoft.public.sqlserver.programming)
  • Re: Is it MSDE or SQLServer
    ... The files maintain their original modified datetime, ... SQL Server MVP ... > properties (their actual creation datetime, not the install datetime). ... Since MSDE could be ...
    (microsoft.public.sqlserver.msde)
  • DTS vs Job Problem for 2 Digit Date format
    ... I've create a DTS package to load a text Document to a ... existing table into SQL,one of the field is a datetime ... 2049 for a 2 digit year of 01/01/49 but went i execute the ...
    (microsoft.public.sqlserver.dts)