NOT EXISTS with two subquery fields that match 2 fields in main query

Background: Two different document types in a document management system.
Both Doc Type A and Doc Type B have a Ticket #, and a Ticket Date.
What we’re looking for:
Doc Type A docs that don’t have a matching Doc Type B doc (NOT EXISTS) with the same Ticket # and Ticket Date.
There like are Doc Type B docs that have the same Ticket # but NOT the same Ticket Date. We want to ignore those.
Seems simple…. but I am stuck.
So far what I have is something like this:

SELECT distinct ki110.keyvaluechar AS "Ticket #",
ki101.keyvaluedate AS "Ticket Date"
 FROM itemdata 
left outer join hsi.keyitem110 ki110 on ( itemdata.itemnum = ki110.itemnum )
left outer join hsi.keyitem101 ki101 on ( itemdata.itemnum = ki101.itemnum )
ki101.keyvaluedate BETWEEN '01-01-2021' AND '01-31-2021'
AND ( itemdata.itemtypenum  = 178  ) -- this is Doc Type A

(select ki110.keyvaluechar, ki101.keyvaluedate
from itemdata, keyitem110 ki110 , keyitem101 ki101
where --(itemdata.itemnum = ki110.itemnum) --Ticket #

— ** the problem is here for Date: I need to say Date in Doc Type B doc is not the same as Date in Doc Type A doc using ki101.keyvaluedate)

AND itemdata.itemtypenum = 183) -- this  is DOC Type B

fastboot – ADB server version (40) doesn’t match this client (41) {Not using Genymotion}

Disclaimer: this is not a duplicate to this SO question as the source of the question is different and the answers don’t apply.* I hope, it is correctly placed in AE and that the note about not using Genymotion does not confuse the reader. The reason to include it in the title is that it is so dominantly present in other answers, but it does have nothing to do with this question, as I don’t use any emulator including Genymotion.

So I’m trying to install LineageOS on my Fairphone FP3+ using Windows 10, for which I need ADB. But: This also applies to other products with other respective versions – in this case, the device uses Android 10 (with Build number 8901.3.A-0054.20200929). I first installed the latest Android Studio from here but actually only needed the SDK Platform Tools which you can find here (not to be mistaken with the Command line tools from the link before). I ran the following command and got this output:

D:SetupsXXXXXLineage FP3platform-tools_30.0.5(ADB_1.0.41)>adb devices
adb server version (40) doesn't match this client (41); killing...
* daemon started successfully
List of devices attached

This SO question (mentioned in the disclaimer) didn’t help, as abd didn’t even print any devices. I also went through these linked questions: link 1, link 2, link 3; link and link 4 among others. Genymotion is as said not used here, but referred to in almost any Q/A except here, but also no soulution for me to be found there. I already checked the PC for any software that could have installed another adb version, but neither me nor cmd’s where could find any (4, 7, 8; 9, 11 or 10).

adb kill-server
adb start-server

Did also not change a thing as suggested here or here. I restarted all devices and software multiple times, shooted adb processes (6, 13 or 12).
I also reinstalled Android Studio to try it without using the cache as suggested in this SO answer from a possibly related question that unfortunately also has no leads. I can imagine that some questions like that one or this SO one could also be helped here.

sql – Match column name with data from other table

I have dynamically created a temp table #temp1 that create column dynamically based on a json string. The table will look like as below


|:---- |:------:| -----:|
| 1  | A   | B |
| 2  | C   | D |

I would like to fill in the value column in result table based on the #temp1 table

result table

| ID | type_id | value |
|:--- |:---:| ---:|
| 1  | 1   | A |
| 2  | 2  | B |
| 3  | 1   | C |
| 4  | 2   | D |

where the type_id can get from another table that specified the type and its id

type table

| ID | type_id | type |
|:--- |:---:| ---:|
| 1  | 1   | FRUIT |
| 2  | 2  | VEGE |

Please help!

Jenkins build number does not match number on Archiva

I have a Jenkins instance that automatically uploads artifacts to a remote Archiva repository. The artifacts uploaded include the build number, but it is only incrementing the builds sequentially so a failed Jenkins build causes the build numbers to become off. For example, my first build of MyProject uploads MyProject-1.jar to Archiva. If the next build fails, and then the third build succeeds, the artifact uploaded will be MyProject-2.jar, even though it was the third build on Jenkins. Is there a way to link these two build numbers for better tracking?

I am using Apache Archiva 2.2.0 and Jenkins 2.263.1

server – Do developers watch player match recordings for their online games?

When developers plan and decide on new buffs and nerfs, do they gather information from online game matches, recorded secretly from their servers’ data feeds and reconstructed / analyzed offline – for such data as player movement trajectories and popular paths, weapon preferences and gamestyle behaviour?

color management – Why don’t the values given by Argyll’s scanin match what I see in darktable or Gimp

I’m trying to do a variation of the color profiling flow given in this post about color profiling

I take an image of a Wolf Faust it8 target, turn off a bunch of the default processing that darktable does, change the input, output and internal profiles to linear rec709 RGB and export to tif.

When I use the eye dropper tool in darktable on the top right patch (A1) I get RGB of 59,51,51.
When I load the exported tif file into gimp, I get basically the same values. Great.

When I run Argyll scanin using the -o flag (which generates a list of measured values):

scanin -v -dipn -o IMG_1956it8.tif it8.cht

I get

A01 11.60257 8.594904 8.657046

totally different values. Why?

If I change the exported profile to srgb, the values are ballpark but still off by 10 or more (so unusable).

I understand why the srgb values off (At least I think I do), but why are the linear rec profiled values so wrong? It feels like scanin is ignoring or is confused by the profile.

As a last data point, when I look at the tif in feh, it looks way dark.

My files can be found here. Sorry it’s 60MB but it includes my input RAW/CR2 file.

Thanks for reading. 🙂

cubemap – Skybox from file at runtime in Unity: Error assigning 2D texture to CUBE texture property ‘_Tex’: Dimensions must match

I’m downloading skyboxes at runtime, and then I’d like to set them as the current scene’s Skybox.

After I successfully downloaded the desired cubemap into the ApplicationData folder, I’m trying to set them as skybox as following:

private void LoadSkybox(string path)
    var skyboxMaterial = new Material(Shader.Find("Skybox/Cubemap"));

    var skyboxData = File.ReadAllBytes(path);
    var skyboxTexture = new Texture2D(2, 2);
    skyboxTexture.LoadImage(skyboxData); //..this will auto-resize the texture dimensions, if I understood it correctly

    skyboxMaterial.SetTexture("_Tex", skyboxTexture);

    RenderSettings.skybox = skyboxMaterial;

The problem is that it fails to do so, because:

Error assigning 2D texture to CUBE texture property ‘_Tex’: Dimensions must match

UnityEngine.Material:SetTexture (string,UnityEngine.Texture)

The loaded texture’s dimensions are 700×525, and the file isn’t corrupted or anything.

If I

It works just fine.

Why doesn’t this work?

What other solutions are there?

special functions – Clebsch Gordan Coefficients: General Expression Does Not Match Specific Expression

The expression ClebschGordan({2, 0}, {4, 0}, {2, 0}) yields the correct result of Sqrt(2/7).

However the expression ClebschGordan({2, 0}, {l2, 0}, {2, 0})/. l2 -> 4 yields Indeterminate. Indeed, ClebschGordan({2, 0}, {l2, 0}, {2, 0}) evaluates to an algebraic expression numerator/((-4 + l2) (2 - l2)!) where numerator/.l2 -> 4 evaluates to Sqrt(2/7). This is indeed indeterminate.

Interestingly, the expression ClebschGordan({l2, 0}, {2, 0}, {2, 0}) /. l2 -> 4 gives the correct result, and ClebschGordan({l2, 0}, {2, 0}, {2, 0}) leads to a different algebraic expression that has the same values for 0<=l2<4 and the correct value for l2->4.

This would appear to be a minor bug, as it violates the simplest symmetry of the Clebsch Gordan coefficients.

SQL Server 2012 patching failure – The language of SQL Server instance MSSQLSERVER does not match the language expected by the SQL Server update

I’ve picked up the support for a SQL Server 2012 instance on a server at our German site and need to apply SQLServer2012SP4-KB4018073-x64-ENU.

The patching is failing with the installer showing error

The language of SQL Server instance MSSQLSERVER does not match the language expected by the SQL Server update. The installed SQL Server product language is German (Germany) and the expected SQL Server language is English (United States).

The server properties general tab (in SSMS) shows Language German (Germany), but the SERVERPOPERTY(‘LCID’) shows 1033 (US_English). The registry entry shows 1031 (German) as the install language (

enter image description here

Trying to use the German patch file SQLServer2012SP4-KB4018073-x64-DEU results in

This SQL Server setup media does not support the language of the OS, or does not have the SQL Server English-language version installation files. Use the matching language-specific SQL Server media; or install both the language specific MUI and change the format and system locales through the regional settings in the control panel

Any pointers as to a way forward so I can apply the patch?

Attempted patching after first suggested fix

enter image description here