July 20, 2008 at 11:47 pm
Hi,
I have two tables , Table_A and Table_B and the same rows in both the tables. The rows have a column called ID which has multiple rows corresponding to it.
Columns are
Id CourseId Group Starttime EndTime Facultyid
I am trying to match every row in the first table with every row in the second table.
Eg :
If the Table_A.Starttime <> Table_B.Starttime ,where Table_A.ID=Table_B.ID, I want to show an error "Starttime does not match"
If the Table_A.Endtime <> Table_B.Endtime ,where Table_A.ID=Table_B.ID, I want to show an error "Endtime does not match"
I am illustarting an example below:
Table_A
Id CourseId Group Starttime EndTime Facultyid
123 AAA 3 0800 0930
July 21, 2008 at 12:29 am
Is this homework? If so, can you be explict about what kind of help your school's policy allows us to give you?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 21, 2008 at 2:52 am
SELECT A.ID,
CASE
WHEN a.StartTime != b.StartTime THEN 'Start Time doesn't match'
WHEN a.EndTime != b.EndTime THEN 'End Time doesn't match'
ELSE 'Record Not found in TableB'
END
FROM
TableA a INNER JOIN TableB b ON a.ID = b.ID
hope the above query will help you..:)
July 21, 2008 at 4:19 am
;with wcte (AId, ACourseId, AGroup, AStarttime, AEndTime, AFacultyid,BId, BCourseId, BGroup, BStarttime, BEndTime, BFacultyid)
Select A.ID AId, A.CourseId ACourseId, A.Group AGroup, A.Starttime AStarttime, A.EndTime AEndTime, A.Facultyid AFacultyid,
B.ID BId, B.CourseId BCourseId, B.Group BGroup, B.Starttime BStarttime, B.EndTime BEndTime, B.Facultyid BFacultyid
FROM TABLE_A A INNER JOIN TABLE_B B OB B.ID = A.ID)
SELECT AId, ACourseId, AGroup, AStarttime, AEndTime, AFacultyid,
CASE
WHEN ASTARTTIME <> BSTARTTIME THEN 'START TIEM DO NOT MATCH'
WHEN AENDTIME <> BENDTIME THEN 'END TIEM DO NOT MATCH'
ELSE ''
END
FROM
WCTE
i hope it will help you.
Atif Sheikh
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply