Looping Through Days Of The Week.

SET @firstdayofweek = dateadd(day,(datepart(dw,@dtm1)*-1)+1,@dtm1)

--WHILE cast(@firstdayofweek AS DATETIME)AS INTEGER(100))

CREATE TABLE #tmp_table(


childid INTEGER null

,br BIT null

,di BIT null

,te BIT null

,type integer default 0

,DaysOfWeek INTEGER

)


INSERT #tmp_table

SELECT DISTINCT sa.childid

,CASE WHEN sha.br & @mybit>0 THEN 1 ELSE 0 END

,CASE WHEN sha.di & @mybit>0 THEN 1 ELSE 0 END

,CASE WHEN sha.te & @mybit>0 THEN 1 ELSE 0 END

,0

,1



FROM


sessionAttendance sa

,simplehoursassignment sha

,session s

,child c