InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 00:57:33 GMT20http://www.sqlservercentral.com/Forums/Topic1371366-92-1.aspx[quote][b]deepika_goyal (10/11/2012)[/b][hr]Hello!!,NO body has replied on thiss.Please give some suggestion.Thanks!![/quote]HelloYou are likely to get a much faster response if you provide DDL for your sample data. Here's your 'master' table, can you do the same with the 'slave' table? Make sure it runs without errors and that the data is correct before you post it. Thanks.[code="sql"]CREATE TABLE #Master ([No] INT, [Type] VARCHAR(20), [Version] VARCHAR(10), [Date] DATE)SET DATEFORMAT DMYINSERT INTO #Master ([No], [Type], [Version], [Date])SELECT 1, 'Sales', 'V1.0', '01/10/2012' UNION ALLSELECT 2, 'Consumption', 'V1.10', '29/10/2012' UNION ALLSELECT 3, 'Daily Needs', 'V1.01', '13/08/2011' UNION ALLSELECT 4, 'Overall', 'V2.01', '01/09/2012'SELECT * FROM #Master[/code]Fri, 12 Oct 2012 03:49:10 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1371366-92-1.aspxThanks Dave!!:-):-)will go through it.Regards,DeepikaFri, 12 Oct 2012 03:40:59 GMTdeepika_goyalhttp://www.sqlservercentral.com/Forums/Topic1371366-92-1.aspxThis sounds like a relational division problem,ie some rows, equal rows, more rows...Joe Celko has done a good write up on the subject, [url]http://www.simple-talk.com/sql/t-sql-programming/divided-we-stand-the-sql-of-relational-division/[/url]Fri, 12 Oct 2012 02:34:37 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic1371366-92-1.aspxThanks Dave for your reply..Still i have to Code, i want to know good approach so that i can start my development.please let me know any way.thanks a lotFri, 12 Oct 2012 00:11:32 GMTdeepika_goyalhttp://www.sqlservercentral.com/Forums/Topic1371366-92-1.aspxIF you show your code for the solution and the execution plan then you may get some suggestions on optimization.Fri, 12 Oct 2012 00:06:47 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic1371366-92-1.aspxHello!!,NO body has replied on thiss.Please give some suggestion.Thanks!!Thu, 11 Oct 2012 23:21:06 GMTdeepika_goyalhttp://www.sqlservercentral.com/Forums/Topic1371366-92-1.aspxDear All,Need some Suggestion.I have two tables one is Master and other one is slave.MY master table has some set of Data and slave tables contains data set from many slaves.Here is the sample data Master No. Type Version Date1 Sales V1.0 01/10/20122 Consumption V1.10 29/10/20123 Daily Needs V1.01 13/08/20114 Overall V2.01 01/09/2012 Slave Code No. Type Version DateS001 1 Sales V1.0 01/10/2012S001 2 Consumption V1.10 29/10/2012S001 3 Daily Needs V1.01 13/08/2011S001 4 Overall V2.01 01/09/2012S001 5 Electricity V5.01 18/10/2012S002 1 Sales V1.0 01/10/2012S002 2 Consumption V1.10 15/10/2012S002 3 Daily Needs V1.1000 13/08/2011S003 1 Sales V1.0 01/10/2012S003 2 Consumption V1.10 29/10/2012S003 4 Overall V2.01 01/09/2012S003 3 Daily Needs V1.01 13/08/2011S003 4 Overall V2.01 01/09/2012S003 5 Electricity V5.01 18/10/2012Now, i have to compare Master with slave and then Slave with Master.Here are conditions.1. IF my master and slave matches then report says MATCH2. IF my master and slave doesnt matches then report says MISMATCH3. IF my Master contains more data than slave then report says Missing at Slave4. IF my slave contains more data than Master then report says Missing data at Master.i know how to get the data, but i want quickest way as my slave table contains millions of record, i want my process to be very quick.Summarization of test cases.Final Report Master Slave StatusCode No. Type Version Date Version Date S001 1 ALL MatchS002 2 Daily Needs V1.01 13/08/2011 V1.10013 /08/2011 MismatchS002 3 Daily Needs V1.01 13/08/2011 V1.1000 13/08/2011 MismatchS002 4 Overall V2.01 01/09/2012 V5.01 18/10/2012 Missing in SlaveS003 5 Electricity V5.01 18/10/2012 Missing in Master PLease let me know if anybody have quick way to do it.thanksRegards.DeepikaThu, 11 Oct 2012 05:17:12 GMTdeepika_goyal