SQL උදව්වක්

[samsmuthu]

මචංලා SQL Support එකක් please,

මම ගාව table 2 ක් තියෙනවා.
Eg.: Table A , Table B

මට Output එකක් ගන්න ඕනි මේ විදිහට Table C

මචං Please , මේකට query එකක් කියපල්ලාකෝ

 

[RuPe_EK]

You have the Enroll_Num and CalendarDate in TimeAtte_MacLog table.

So SELECT * FROM TimeAtte_MacLog <WHERE> ORDERBY Enroll_Num,CalendarDate

 

[හෙනයා]

 

[dildude]

Table a cross join table b

 

[sanoka]

Poddak table B eka 'select * ' ekak pennapan columns tika balaganna

 

[විල්සන් මාමා]

Foreign key ekak nadda bun Table A and Table B athara

 

[bitch_please]

TABLE A eka natuwa wade karann apuluwan nw machan ??

 

[samsmuthu]

Wede Goda

Machang, wede goda.

DECLARE @Enroll_Num INT
DECLARE @Date_1 DATETIME
DECLARE @Date_2 DATETIME

DECLARE Enroll_Num_Cursor CURSOR FOR
SELECT DISTINCT Enroll_Num
FROM TimeAtte_MacLog
WHERE CalendarDate BETWEEN '2017-02-01' AND '2017-02-28'
ORDER BY Enroll_Num ASC

OPEN Enroll_Num_Cursor

FETCH NEXT FROM Enroll_Num_Cursor INTO @Enroll_Num

WHILE @@FETCH_STATUS = 0
BEGIN
SET @Date_1 = '2017-02-01'
SET @Date_2 = '2017-02-28'
WHILE @Date_1 <= @Date_2
BEGIN
INSERT INTO TimeAtte_MacLog
(
TimeMac_ID,Enroll_Num, CalendarDate, PDate
)
SELECT
0, @Enroll_Num, @Date_1, @Date_1

--PRINT CAST(@Enroll_Num AS VARCHAR(4)) + ' - ' +
-- CAST(@Date_1 AS VARCHAR(20))

SET @Date_1 = DATEADD(dd, 1, @Date_1)
END
FETCH NEXT FROM Enroll_Num_Cursor INTO @Enroll_Num
END

CLOSE Enroll_Num_Cursor
DEALLOCATE Enroll_Num_Cursor

Try Karala Balanna. Kawada hari ona weyi.

 

[charith84]

left join කුකුලොහ් ...