Database

Amarni wrote:

select * from Table_name Where ID=2 and ID=4 and ID=5 while the Id in not the primery key

SELECT DISTINCT x.*
FROM x
INNER JOIN xy
ON x.x_id = xy.x_id
WHERE xy.y_id in (2,4,5)

hamidreza_buddy wrote:

whats the name of that control?

DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
DECLARE @cnt INTEGER
 
DECLARE cur CURSOR FOR 
    SELECT
        AbsentDate 
    FROM 
        #tmpTable
 
OPEN cur
 
FETCH NEXT FROM cur INTO @StartDate
WHILE @@FETCH_STATUS = 0
BEGIN
    SET @cnt = 0
    SET @EndDate = @StartDate
    WHILE @cnt < 6
    BEGIN
        SET @cnt = @cnt + 1
        SET @EndDate = DATEADD(d,1,@EndDate)
        WHILE (DATEPART(dw,@EndDate) IN (1,7)) OR
              (EXISTS(SELECT * FROM Holidays 
                      WHERE HolidayDate = @EndDate))
        BEGIN
            SET @EndDate = DATEADD(d,1,@EndDate)
        END
    END	
 
    IF ((SELECT COUNT(*) 
         FROM #tmpTable
         WHERE AbsentDate BETWEEN @StartDate AND @EndDate) > 5)
    BEGIN
        -- Save Date
        -- or do other desired processing
    END
 
    FETCH NEXT FROM cur INTO @StartDate
END
 
CLOSE cur
DEALLOCATE cur

Gilad Kapelushnik wrote:

My quersion is, which of the above is more suited for my application ?