sharepoint online – compare rows in the same column

I'm working on validating a SharePoint list. One of the requirements is contained in column A. no serial number included These are the numbers that differ in a way only +1 from each other.

For example in column A:







In this example, the number in the top 4 lines only differs by +1 and should return an error in the validation.

I found a way to extract the number separately from the character. However, you still need help comparing the different lines to identify the +1 different and the return error.

I hope to have help from the community. Thank you in advance.

SQL Server – The PRIMARY fileset for the database CRM running out of space

I have a database for which I am getting errors as shown below.

The file group «PRIMARY» for the database "CRM" in the SQL instance "MSSQLSERVER" on the computer "prod" does not have enough space.

The SQL details in MB are as follows: The MDF file has now reached 249 GB.

CRM mscrm D: Program Files Microsoft SQL Server MSSQL10_50.MSSQLSERVER MSSQL DATA CRM.mdf 249157
CRM mscrm_log E: Program Files Microsoft SQL Server MSSQL10_50.MSSQLSERVER MSSQL Data CRM_log.LDF 5137

D and D drives have more than 50 GB of free space. C and Temp each have more than 30 GB and 20 GB of free space. No drive has insufficient space.

The growth is set as automatic in this database without restriction.

Any clues?

Thanks a lot
Hungry DBA

Mining Theory – Is There Only One Method? for miner and pool communication?

JSON-RPC as the protocol does not specify any other protocols that use it. Rather, it only defines the general structure that protocols that use JSON-RPC should use. JSON-RPC does not define methods. login is a method offered by protocols with JSON-RPC.

GBT, Stratum and Getwork use JSON-RPC. They are not themselves a JSON-RPC or a subset of JSON-RPC. Furthermore, none of them have one login Method.

There is no guarantee that all coins will use the same protocol (GBT, shift or network) or that they will use JSON-RPC. Coins usually use one of these or a similar value because they simply copy the existing code, but there is no guarantee.

Combinatorics – Only generate unique combinations if the input contains duplicates

I have a list of repeated items, such as

list = {a, a, b, c, c, c}

and I would like a list of unique Possibilities to choose 3 elements from it:

{{a, a, b}, {a, a, c}, {a, b, c}, {a, c, c}, {b, c, c}, {c, c, c}}

Unfortunately, "unique" in this sentence means two different things at the same time, and I cannot figure out how to achieve both types of uniqueness at the same time.

i could use Permutationswhose documentation regarding the input indicates that

Repeated elements are treated as identical.

But I'm going to have a lot of results that differ only by rearrangement, and I don't care about the order:

Permutations[list, {3}]

{{a, a, b}, {a, a, c}, {a, b, a}, {a, b, c}, {a, c, a}, {a, c, b}, {a, c, c}, {b, a, a}, {b, a, c}, {b, c, a}, {b, c, c}, {c, a, a}, {c, a, b}, {c, a, c}, {c, b, a}, {c, b, c}, {c, c, a}, {c, c, b}, {c, c, c}}

To eliminate the rearrangements, I could try using Subsets but instead by it is Documentation,

Different occurrences of the same element are treated as different.

As a result, I get a lot of duplicate results that I don't want because of the repeated elements of list::

Subsets[list, {3}]

{{a, a, b}, {a, a, c}, {a, a, c}, {a, a, c}, {a, b, c}, {a, b, c}, {a, b, c}, {a, c, c}, {a, c, c}, {a, c, c}, {a, b, c}, {a, b, c}, {a, b, c}, {a, c, c}, {a, c, c}, {a, c, c}, {b, c, c}, {b, c, c}, {b, c, c}, {c, c, c}}

[Aside from frustration, I can't imagine why Mathematica's permutation generation function treats repeated list items differently than the combination generation function.]

I could remove the duplicates from both results, but in both cases the full list of ambiguous results still needs to be calculated as an intermediate step, which I expect to be many orders of magnitude longer than the unique results.

Is it possible to get the result you want without first having to make an enormously longer list to get there?

Ecommerce – Hide a table from the ad (B2B ecommerce product detail page)

I have a B2B product details page.

We have a multi-vendor market, so like Amazon, we have multiple vendors for one product.

What are the options and the advantages or disadvantages for each option?

  • Show them in a modal
  • Show them on a separate page
  • View a table on the details page
  • Display them on one of our tabs (e.g. product description / downloads).
  • Show them as a collapsible part of the page (which opens when you click Show Suppliers).
    • Open a side wall (desktop) that has the full screen width on mobile devices (see, for example, the Amazon website).
  • Another option
  • – –

Enter the image description here

dnd 3.5e – Do known bloodline bonus spells need to be added to the class that qualified you for the feat?

Bloodline exploits (e.g. Air Bloodline) grant additional known spells and require you to be a spontaneous arcane caster.

But are these known spells only added to the class that qualifies you for the feat? Could you use some or all of the spells that are known from another class's magic list (e.g. Sha & # 39; ir, for a prepared caster who still needs to learn magic), instead of or in addition to your (e.g.) magician – add magic list?

I actually don't have that Dragon CompendiumThat's why I stay with D&D Tools as a reference. If the answer to this question is clearly stated in Dragon Compendium, I apologize.

C # – Collection of IDs or ID fields in a structure, how are they treated?

So I have two types of structures that are pretty much the same, but I'm curious to see how the structures are handled at runtime:

Structure A.

struct A{
 int id0;
 int id1;
 int id2;
 int id3;
 public void SetId(int index, int id){

    if(index == 0) id0 = id;
    elseif(index == 1) id1 = id;
    elseif(index ==2) id2 =id;
    elseif(index ==3) id3 = id;


Structure B.

struct B{

  int() ids = new int(4);

  public void SetId(int index, int id){

    if(index >= 0 && < 4)
      ids(index) = id;


They are basically identical in behavior, but I'm curious to see how C # deals with these two types of structures. Should structure B go to the heap where structure A can stay on the stack?

Would Structure A perform better because it doesn't assign a new array? Is structure B the wrong way to use a structure?

Basically, I'm looking for the advantages and disadvantages of each structure in terms of which one should be preferred.

Thanks a lot

up sell – Magento2, how you can use the object manager to get an upsell product on the category list

Note: First, it is not recommended to use the Object Manager directly on a file. Use only the Magento standard

The following code is only intended to show how we can easily get the upsell product on the category list page.

$objectManager = MagentoFrameworkAppObjectManager::getInstance();
$category = $objectManager->get('MagentoFrameworkRegistry')->registry('current_category');
$categoryId = $category->getId();
$categoryFactory = $objectManager->get('MagentoCatalogModelCategoryFactory');

$category = $categoryFactory->create()->load($categoryId);
$categoryProducts = $category->getProductCollection()

foreach ($categoryProducts as $product) {
    $current_product_id = $product->getId();
    $current_product = $objectManager->create('MagentoCatalogModelProduct')->load($current_product_id);
    if ($current_product) {
    $upSellProducts = $current_product->getUpSellProducts();

    if (!empty($upSellProducts)) {
        foreach ($upSellProducts as $upSellProduct) {
                $productId = $upSellProduct->getId();
                $product = $objectManager->create('MagentoCatalogModelProduct')->load($productId); 
                echo 'Upsell Product name---'.$product->getName().'

'; } } } }