InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:09:38 GMT20http://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspx[quote][b]yogi123 (1/2/2013)[/b][hr][quote][b]Jason-299789 (1/2/2013)[/b][hr]this should work[code="sql"]Select * from #temp2EXCEPTSelect * from #temp1[/code][/quote]Thanks for your helpcan you please solve another way, so i can implement that in my real logic.Thanks For Your Help[/quote]Can you explain why this wouldn't work for you?Thu, 03 Jan 2013 09:01:10 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspx[quote][b]Jason-299789 (1/3/2013)[/b][hr]Ok, I didnt realise there was any other logic. This is a way to do it with a Left Join [code="sql"]Select t2.*from #temp2 t2Left Join #temp1 t1 on t2.StudentLocalID=t1.StudentLocalID and t2.ScheduleSchoolCode=t1.EnrollSchoolCodewhere t1.EnrollSchoolCode is Null[/code]Heres a way with a Not Exists[code="sql"]Select t2.*from #temp2 t2Where NOT EXISTS (Select 1 from #temp1 t1 Where t1.EnrollSchoolCode=t2.ScheduleSchoolCode and t1.StudentLocalID=t2.StudentLocalID)[/code]Either should enable you to add more logic.[/quote]Thank You so Much This works AwesomeThu, 03 Jan 2013 07:02:19 GMTyogi123http://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspx[quote][b]manikandanps (1/3/2013)[/b][hr]this should work!!!!!Select * from #temp2EXCEPTSelect * from #temp1[/quote]I already provided that solution but the poster needs to add more logic so I've provided the additional solutions, which should allow for more logic to be provided.Thu, 03 Jan 2013 00:36:36 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspxthis should work!!!!!Select * from #temp2EXCEPTSelect * from #temp1Thu, 03 Jan 2013 00:24:10 GMTmanik123http://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspxOk, I didnt realise there was any other logic. This is a way to do it with a Left Join [code="sql"]Select t2.*from #temp2 t2Left Join #temp1 t1 on t2.StudentLocalID=t1.StudentLocalID and t2.ScheduleSchoolCode=t1.EnrollSchoolCodewhere t1.EnrollSchoolCode is Null[/code]Heres a way with a Not Exists[code="sql"]Select t2.*from #temp2 t2Where NOT EXISTS (Select 1 from #temp1 t1 Where t1.EnrollSchoolCode=t2.ScheduleSchoolCode and t1.StudentLocalID=t2.StudentLocalID)[/code]Either should enable you to add more logic.Thu, 03 Jan 2013 00:07:31 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspx[quote][b]Jason-299789 (1/2/2013)[/b][hr]this should work[code="sql"]Select * from #temp2EXCEPTSelect * from #temp1[/code][/quote]Thanks for your helpcan you please solve another way, so i can implement that in my real logic.Thanks For Your HelpWed, 02 Jan 2013 10:44:45 GMTyogi123http://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspxthis should work[code="sql"]Select * from #temp2EXCEPTSelect * from #temp1[/code]Wed, 02 Jan 2013 10:41:40 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1401962-391-1.aspxHello Everyone,I need one query help[code="sql"]create table #temp1(StudentLocalID varchar(9),EnrollSchoolCode Varchar(3))create table #temp2(StudentLocalID varchar(9),ScheduleSchoolCode varchar(3))insert into #temp1 values ('003682153','305')insert into #temp1 values('003682153','303')insert into #temp1 values('003744930','305')insert into #temp1 values('003744930','332')insert into #temp2 values('003682153','305')insert into #temp2 values('003682153','303')insert into #temp2 values('003744930','305')insert into #temp2 values('003744930','303')insert into #temp2 values('003744930','332')[/code]I need to display unmatch ScheduleSchoolCode from EnrollSchoolCode of #temp2 only so desired output is[code="plain"]StudentLocalID ScheduleSchoolCode003744930 303[/code]Wed, 02 Jan 2013 10:39:32 GMTyogi123