Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Date field comparision - without time running slow

    PW Your solution takes longer - 202 seconds.

    Lowel - I did try datediff and it takes 93 seconds -

    your example (takes 93 seconds)

    select * from C_Tracked_Item_Hist

    where datediff(d,ActivityDate,getdate()) > 7

     

    my...

  • RE: Date field comparision - without time running slow

    Field alredy has an index. If I do the following it runs fast, but I would like an alternate/better approach...

    DECLARE

    @sqlstr nvarchar(4000),

     @DT DATETIME,

     @DE char(13)

    SET @dt = DATEADD(day, -7,...

  • RE: MSDE Maint. plan problems

    ? Please direct me to where I can set-up a maintenance plan. Is my problem that I was trying to do via enterpirse manager and not osql?

    Thanks,

    Sam

  • RE: Linked servers and OSQL utility.

    Throwing out things to try/check:

    Has your firewall changed where it would deny port 1433  connections.  Example Windows firewall can deny connection to the remote database. If it is turned on, check to make sure that...

  • RE: help comparing 2 tables

    SELECT DISTINCT name

    FROM table1

    WHERE NOT EXISTS

    (SELECT name FROM table2 WHERE table1.name = table2.name)

  • RE: Generating Access DB from a SQL Server schema

    Why not use MSDE on the disconnected machines (free lite version of SQL)? You can have them run scripts to update their local schema as it changes....

Viewing 6 posts - 1 through 6 (of 6 total)