Question: I have two sql temp table #Temp1 and #Temp2, and I want to get rowid which contain set of temp table two 

E.g. In table Temp2 have 4 record i want to search in temp table #Temp1 which contain userid departmentid set of record

```
CREATE TABLE #Temp1(rowid INT, userid INT, departmentid int)

CREATE TABLE #Temp2(userid INT, deparetmentid int)

INSERT INTO #Temp1 (rowid,userid,departmentid ) 
    VALUES  (1,1,1),(1,2,2),(1,3,3),(1,4,4),(1,2,1),
                (2,2,1),(2,2,2),(2,3,3),(2,4,4),
                (3,3,1),(3,2,2),(3,3,3),(3,4,4)

INSERT INTO #Temp2 (userid,departmentid ) 
        VALUES (2,1),(2,2),(3,3),(4,4)

DROP TABLE #Temp1

DROP TABLE #Temp2

```

i want output rowid 2 because it contain set of (2,1),(2,2),(3,3),(4,4)
one thing in rowid also contain same set of record it its have one more row mean 
when i search in temp1 table based on rowid 1 then i found 4 record and when i search rowid 2 then it contain 4 record so that it is same set of record which i found 

Thanks

Answer: 
**First we need to find the installed package. For that enable Windows Installer logging.**

1) In `run` open `gpedit.msc` or you can google how to open group policy editor

2) Expand in left panel `Computer Configuration -->Administrative Templates --> Windows Components --> Windows Installer`

3) On right panel open `Logging` and `Enable` it and in option Logging `voicewarmupx`

4) Restart your PC

**Now Windows Installer logging is enabled. Next we need to find and uninstall the conflicting package.**

1) Open windows `%temp%` (can be opened by typing %temp% in run) and delete all files. If something cant be deleted leave it. 

2) Run the `.NET Framework 4 installer` again. After the installer fails, close it.

3) Open windows `%temp%` again and open the log file (file would be MSIxxxxx.LOG, eg:MSI232f1.LOG)

4) Search for a line saying `PROPERTY CHANGE: Adding NEWERVERSIONDETECTED property. Its value is {xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx}'.` Value will be different depending on the package that is already installed.

5) Open command prompt and run `msiexec /uninstall {xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx}`

6) Now try installing `.NET Framework 4 Installer` again. This time it will succeed.

**Also don't forget to disable `Windows Installer logging`. Using the same way you enabled it.**
You can check if you allready installed .Net 4 in registry

Computer\HKEY\_LOCAL\_MACHINE\SOFTWARE\Microsoft.NETFramework\v4.0.30319