salut...am urmatoarele tabele

CREATE TABLE [dbo].[QASUsersProba] (
 [UserIdentification] [varchar] (150)  NOT NULL ,
 [UserLevel] [int] NOT NULL ,
 [DateCreated] [datetime] NULL ,
 [Status] [bit] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[QASUsersProba] WITH NOCHECK ADD
 CONSTRAINT [PK_QASUsersProba] PRIMARY KEY  CLUSTERED
 (
  [UserIdentification]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO

ALTER TABLE [dbo].[QASUsersProba] WITH NOCHECK ADD
 CONSTRAINT [DF_QASUsersProba_DateCreated] DEFAULT (getdate()) FOR [DateCreated]
GO

-----------------------------------------------------------------------------------------------------------------------------------------

CREATE TABLE [dbo].[QASLogInfoProba] (
 [QASLICounter] [int] IDENTITY (1, 1) NOT NULL ,
 [QASItemTime] [datetime] NOT NULL ,
 [QASUserName] [varchar] (50)  NOT NULL ,
 [QASItemType] [varchar] (50)  NOT NULL ,
 [QASStation] [varchar] (50)  NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[QASLogInfoProba] WITH NOCHECK ADD
 CONSTRAINT [PK_QASLogInfoProba] PRIMARY KEY  CLUSTERED
 (
  [QASLICounter]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO
-------------------------------------------------------------------------------------------------------------

CREATE TABLE [dbo].[CycleTimes_L01] (
 [CTCounter] [int] IDENTITY (1, 1) NOT NULL ,
 [assemblyPaletteID] [varchar] (16)  NOT NULL ,
 [SerialNumber] [varchar] (25)  NULL ,
 [startTime] [datetime] NOT NULL ,
 [endTime] [datetime] NOT NULL ,
 [timeInWsSeconds] [int] NULL ,
 [APLCounter] [int] NULL ,
 [QASStation] [nvarchar] (3)  NULL ,
 [QASLICounter] AS ([dbo].[FgetQASLICounter]([endtime], [QASStation])) ,
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CycleTimes_L01] WITH NOCHECK ADD
 CONSTRAINT [PK_CycleTimes_L01] PRIMARY KEY  CLUSTERED
 (
  [CTCounter]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CycleTimes_L01] WITH NOCHECK ADD
 CONSTRAINT [DF_CycleTimes_L01_QASStation] DEFAULT ('L01') FOR [QASStation]
GO

----------------------------------

CREATE TABLE [dbo].[CycleTimes_L02] (
 [CTCounter] [int] IDENTITY (1, 1) NOT NULL ,
 [assemblyPaletteID] [varchar] (16)  NOT NULL ,
 [SerialNumber] [varchar] (25)  NULL ,
 [startTime] [datetime] NOT NULL ,
 [endTime] [datetime] NOT NULL ,
 [timeInWsSeconds] [int] NULL ,
 [APLCounter] [int] NULL ,
 [QASStation] [nvarchar] (3)  NULL ,
 [QASLICounter] AS ([dbo].[FgetQASLICounter]([endtime], [QASStation])) ,
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CycleTimes_L02] WITH NOCHECK ADD
 CONSTRAINT [PK_CycleTimes_L02] PRIMARY KEY  CLUSTERED
 (
  [CTCounter]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO

ALTER TABLE [dbo].[CycleTimes_L02] WITH NOCHECK ADD
 CONSTRAINT [DF_CycleTimes_L02_QASStation] DEFAULT ('L02') FOR [QASStation]
GO

--------------------------------------------------------------------------------------------------------------------------------------

CREATE TABLE [dbo].[N_CompName] (
 [ID_CompName] [int] IDENTITY (1, 1) NOT NULL ,
 [Seria] [varchar] (10)  NULL ,
 [Nume] [nvarchar] (50)  NULL ,
 [recData] [datetime] NULL ,
 [recUser] [nvarchar] (50)  NULL ,
 [recStation] [nvarchar] (50)  NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[N_CompName] WITH NOCHECK ADD
 CONSTRAINT [PK_N_CompName] PRIMARY KEY  CLUSTERED
 (
  [ID_CompName]
 ) WITH  FILLFACTOR = 90  ON [PRIMARY]
GO

ALTER TABLE [dbo].[N_CompName] WITH NOCHECK ADD
 CONSTRAINT [DF__N_CompNam__recDa__0E8E2250] DEFAULT (getdate()) FOR [recData],
 CONSTRAINT [DF__N_CompNam__recUs__0B7CAB7B] DEFAULT (suser_sname()) FOR [recUser],
 CONSTRAINT [DF__N_CompNam__recSt__086B34A6] DEFAULT (host_name()) FOR [recStation]
GO

------------------------------------

  Trebuie sa iau UserIdentification din tabela QASUserProba adica fiecare utilizator sa verific perioada de timp
in care a fost logon si logoff in functie de fiecare zi verific daca a fost logat pe mai multe statii QASStation din QASLogInfo
...iau aceste QASStation si ma duc in CycleTimes_(QASStation) (Exemplu: CycleTimes_L01 sau L02.....pt N statii) intru in ea si calculez(adun) timeInWsSeconds pe ziua respectiva pt acel QASLiCounter pe fiecare QASStation iau si SerialNumber ultimele 3 si scot din N_CompName
Nume-le respectivului Componenet pe care a lucrat

cum pot scoate aceste rezultate .....ma intereseaza mai mult cum pot parametriza in functie de CycleTimes_(QASStation....L01...L02...) ca sa treaca pe unde trebuie si sa calculeze timpul de lucru.

e destul de greu de explicat....nu ma certati daca nu intelegeti nimic din intrebarea mea....e vina mea recunosc....dar de multe ori in timp ce va scriam o intrebare.....gaseam si raspunsul la ea :).....mi se clarificau si mie lucrurile mai bine....:)))