## sql server – sp_executesql not accepting multiple types

I have the following table:

``````CREATE TABLE (dbo).(Settings)(
(Id) (int) IDENTITY(1,1) NOT NULL,
(Key) (varchar)(50) NOT NULL,
(Value) (nvarchar)(max) NULL,
``````

CONSTRAINT (PK_Settings) PRIMARY KEY CLUSTERED
(
(Id) ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON (PRIMARY)
) ON (PRIMARY) TEXTIMAGE_ON (PRIMARY)
GO

I’m trying to run this query

`exec sp_executesql N'INSERT INTO Settings ((key), (value)) VALUES (@k6,@v6), (@k8,@v8)' , N'@k6 nvarchar(4000), @v6 nvarchar(4000), @k8 nvarchar(4000), @v8 bit', @k6=N'DefaultLocale',@v6=N'eb', @k8=N'ReCaptchaIsEnabled',@v8=1`
unfortunately, I’m getting this error:

``````Conversion failed when converting the nvarchar value 'eb' to data type bit.
``````

When I remove the bit definition or remove Nvarchar definition it working well. From what I see, I cannot mix different value types in this query.
Can you tell me why?
Thank you

## confluence – How to create multiple rows with shortcut in table on Ubuntu

In confluence is a short-cut to create another row in a table with “Ctrl+Alt+Downarrow”.
However, I can’t use this shortcut, because I am using Ubuntu 20.04 and this shortcut switches between multiple workspaces.

The problem is, I need a table with 20 rows and the only option that I have is to create a fresh table is to create a new table (which has 3 rows per default) and then add 17 rows manually with my mouse.

Is there any other way to create more rows? How can I enable this shortcut for Ubuntu?

## C-Norm of multiple derivatives

We’re calculating Trapezoid and Simpson’s rule estimates for definite integrals. For the error, we need the C-norm of the first – fourth derivatives. How do I enter this into Mathematica? As of right now I’ve been using other calculators to find the max value of the derivatives on an interval.

## javascript – Multiple audio player – arrow keys & space

I am creating a Vue component of an audio player.

And I am having some difficulties in finding the ideal way to get the arrow keys and space to work.

I have found a solution, however I think it is not the best, nor the most effective. I’ve added a listener to the DOM in the component, but the problem is that I will have multiple players along the page, so I will have multiple DOM listeners.

Is it a good solution or is there a better one?

``````    // component code
...

if ( !state.isPlaying )
return;

switch ( event.keyCode ) {
case 32:
pause();
break;
case 37:
audio.currentTime -= 2;
break;
case 39:
audio.currentTime += 2;
break;
default:
break;
}
});
$$```$$
``````

## google sheets – Filter cells based on multiple data in 2 columns

Hi,

I need to create a conditional filter where at least 3 of the numbers in either cell is greater than 60. I have highlighted the rows in bold that qualify.

The first one (lets call them a1 and b1 ) do not qualify as only 1 number is over 60

The second row (a2 and b2) qualifies as there are 3 numbers in that row over 60, 74,85,80

It does not matter if the numbers of 60 are in a single cell in the row or a mixture of both as shown below

Thank you, I look forward to your solution

## 7 – View with multiple node arguments using an entity reference

We have a node type called: MEETING
On Meeting we have a user entity reference called: PARTICIPANTS
I create several MEETING’s and reference 2 users: USER1 AND USER2

Now I want to build a dynamic view we can use URL arguments in contextual filters to show all meetings with USER1 and USER2

I create a view called VIEWMEETINGS
I set PARTICIPANTS field as the contextual filter and check “Allow multiple values”

view path settings are MYSITE/VIEWPARTICIPANTS/%

If I go to MYSITE/VIEWPARTICIPANTS/USER1 OR MYSITE/VIEWPARTICIPANTS/USER2 the view loads all MEETINGS where that user is referenced

The problem is when I go to MYSITE/VIEWPARTICIPANTS/USER1,USER2 it does not load?

How can I create a view that will show me all MEETINGS where both USER1 and USER2 are referenced?

I want both of these views to show the same results
MYSITE/VIEWPARTICIPANTS/USER1,USER2
MYSITE/VIEWPARTICIPANTS/USER2,USER1

## Google Sheets: How to compare multiple rows/data ranges AND display the MATCHING/duplicate values

As the title reads, I am using google sheets and have MULTIPLE data (columns) ranges of varying sizes (different row counts). The goal is to combine the data into a single dataset AND only show items that are “duplicated”

This is my data (sample), from EVE Echoes:

``````------Dataset 1-------
-----A-----|-----B----
Asteroid       Yield
-----------|----------
Jaspet-----|-1,033.00
Gneiss-----|---455.00
Arkonor----|---300.00
Kernite----|---216.00
Spodumain--|---178.00
Pyroxeres--|---113.00
Plagiocase-|----43.65

------Dataset 2-------
-----X-----|-----Y----
Asteroid       Yield
-----------|----------
Hedbergite-|---193.00
Gneiss-----|---91.08
Hemorphite-|---79.20
Spodumain--|---29.70
Dark Ochre-|---25.20
Omber------|---24.75
Kernite----|---21.60

------Dataset 3-------
-----O-----|-----P----
Asteroid       Yield
-----------|----------
Crokite----|---39.48
Jaspet-----|---20.16
Dark Ochre-|---19.35
Pyroxeres--|---13.50
Hemorphite-|----6.43
Hedbergite-|----3.70
``````

In the data (sample) above, I am only providing 3 different datasets, but keep in mind that there is no “same row-count” EVER. Nor there’s a “same dataset count”; could be 3 data sets (like in this sample), only one, or hundred’s of data sets.

Comparing datasets, the desired outcome should be these values with duplicates:

``````------------------------
|-Data with duplicates-|
------------------------
Dark Ochre
Gneiss
Hedbergite
Hemorphite
Jaspet
Kernite
Pyroxeres
Spodumain
``````

Already tried a number of approaches, all failed. Tried using FILTER():

`=FILTER({A:A; X:X; O:O}, COUNTIFS({A:A; X:X; O:O}, UNIQUE({A:A; X:X; O:O})>1))`

Query didn’t help either:

`=QUERY({A:A; X:X; O:O}, "SELECT Col1 WHERE Col1 IS NOT NULL AND COUNT(Col1)>1 GROUP BY Col1")`

Anything I have tried results in errors. There’s also the problem of headers and empty cells

## entities – Drupal 7 View with multiple node arguments using Entity Reference

We have a node type called: MEETING
On Meeting we have a user entity reference called: PARTICIPANTS
I create several MEETING’s and reference 2 users: USER1 AND USER2

Now I want to build a dynamic view we can use URL arguments in contextual filters to show all meetings with USER1 and USER2

I create a view called VIEWMEETINGS
I set PARTICIPANTS field as the contextual filter and check “Allow multiple values”

view path settings are MYSITE/VIEWPARTICIPANTS/%

If I go to MYSITE/VIEWPARTICIPANTS/USER1 OR MYSITE/VIEWPARTICIPANTS/USER2 the view loads all MEETINGS where that user is referenced

The problem is when I go to MYSITE/VIEWPARTICIPANTS/USER1,USER2 it does not load?

How can I create a view that will show me all MEETINGS where both USER1 and USER2 are referenced?

I want both of these views to show the same results
MYSITE/VIEWPARTICIPANTS/USER1,USER2
MYSITE/VIEWPARTICIPANTS/USER2,USER1

## design – How to share data among multiple subscribers?

Data is supposed to be received in sequence, by a subscriber.

Every data item published cannot be dropped.

Data items have relationship among them

Publishers and subscribers are distributed.

Each data item is structured with pre-defined attributes.

What should be the shared communication mechanism , for a publisher to send data to subscriber?

Graph db…

## pathfinder 1e – AoO from multiple Mythic abilities

Short answer : I would rule that you get exactly one attack of opportunity, and it must be with your shield.

Reasoning : The below text in the Combat Chapter, under Attacks of Opportunity seems to be saying a given action should only provoke once.

This feat does not let you make more than one attack for a given opportunity, but if the same opponent provokes two attacks of opportunity from you, you could make two separate attacks of opportunity (since each one represents a different opportunity).

During this time, whenever a creature misses on a melee attack against you, it provokes an attack of opportunity from you.

Mythic Shield Master says

if a foe in reach makes an attack against you and misses by 5 or more that foe provokes an attack of opportunity from you. If a foe attempts to make a combat maneuver targeting your shield (such as sunder) and after the maneuver is resolved your shield is still in hand and not broken or destroyed, that foe provokes an attack of opportunity from you. You can only use this attack of opportunity to attack the foe with your shield.

In both cases, the thing provoking the AoO is missing an attack against you. The conditions for Shield Master include missing by 5 or more, but it’s still the miss of the attack that is the trigger. Therefore, I see this as just one oppotunity, not two.

If you were missed by less than 5, you would be able to make the AoO in any way you wished.