Welcome to Sign in | Help

script de select sql server 2005

  •  12-24-2007, 6:45 PM

    script de select sql server 2005

    salut, am si eu nevoie de ajutor la un script va rog

    am o tabela structurata astfel

    CREATE TABLE [dbo].[Tasks] (
     [id_task] [int] IDENTITY (1, 1) NOT NULL ,
     [Fkeyincident] [int] NOT NULL ,
     [DataTask] [smalldatetime] NOT NULL
    ) ON [PRIMARY]
    GO

    datele in ea arata astfel

    ID_TASK                        FKeyIncident                      DataTask

    1                                    99999                              2007-10-12

    2                                    99999                              2007-10-12

    3                                    99999                              2007-10-13

    4                                    88888                              2007-10-25

    5                                    88888                              2007-10-28

    dupa cum v-ati dat seama mai exista o tabela de incidente. pentru fiecare incident exista unul sau mai multe taskuri...ce ma intereseaya pe mine este sa scot din tabela taskuri pe acelea care aparitin de acelasi incident(fkezincident) si care are data diferita(DataTask)

    multumesc mult

    alex.

     

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems