Flexible table columns width, rows independent?

Hello,

i have HTML table with 3 rows.
the third row contains in the middle three columns that contains extraordinary long phrasesphrases which cause columns above these long columns to be long too and that looks bad, because above rows contains images so spacing is different.

How can i set the HTML table columns width to be flexible, i mean so the wide third row columns does not influence width of the columns in other rows of the same table?
SEMrush

This is my table code, i would possibly try to convert it into <div> but since the code seems difficult and me beginner, i am asking regarding hack to tweak current HTML table code, unless someone have time to turn it into div for me.

 

How to Auto -delete rows in mysql database

I am building an online ticketing system where users reserve their ticket before proceeding to the payment activity to make sure that their desired seat is not reserved by someone else while they are trying to validate the payment. A boolean is set to update and set to true upon completion of the payment. However, upon failure, the system might not always get the response and I will like to be able to delete all entries which have not been set to true after existing for 60 seconds. In summary I want a

`DELETE * FROM tickets WHERE reserved_time > 60 seconds AND paid_for = false`  

And I want it to run continiously so that users who can’t pay for their tickets 60 seconds after reservation can release the tickets immediately. I know it’s a long shot but thanks for any attempts .

user interface – aligning columns on all rows with recyclerView

I have a recycler view to show a list of rows from my db. The data in each column in my db does change slightly in length and whilst I can format each row nicely, subsequent rows will format the data independently, so each row is ok in singularity, but I would like all columns to line up over all rows.
I could do this by setting the width to a fixed value, but that’s not good coding.
I would like a way of working out the max column width for each column on every row, and set all rows to have those max column widths for each column.

I am using a customer recycler view adapter if this helps.

Thanks

google sheets – Locking a formula when adding rows

Currently I have this formula in there

=IF('Form Responses 3'!G$20="","",COUNTIF('Form Responses 3'!G$1:G$167,F20))

It does what I want it to do if I go in a tweak it later, but I don’t want to go in a tweak it

Because it’s a form responses tab, every time a new form is submitted it adds a new row in and my reference cell changes. I’ve done some research and tried out the INDIRECT function (=IF(INDIRECT('Form Responses 3'!G$20)="","",COUNTIF('Form Responses 3'G$1:G$167,F20)), but I can’t seem to get the reference cell to stay G20.

My formula is on a different tab in cell C4.

oracle – How to get rows based on the where inside a column?

I am working with Oracle and I have a table like this:

| id | wh |
|—-|——–|
| 1 | 1 = 1 |
| 2 | 1 != 1 |
| 3 | 1 != 2 |

I would like to perform a ‘select * from Where table’, where the condition of the where is what is inside the ‘wh’ column. That it was iterating through rows determining if the ‘wh’ column is valid or not according to the ‘wh’ field of that row.

For example in row 1 it would be: ‘select * from table where 1 = 1’, in row two: ‘select * from table where 1! = 1’ and so on.

Google Sheet color rows 2 by 2

I cannot seem to find a way on how to color 2 rows in a row. All tutorials are to color alternating rows.

Namely, this is the situation

A1:O1 Header Title
A2:02 Header Subtitle
A3:O3 Name
A4:O4 Value
A5:O5 Name
A6:O6 Value
A7:O7 Name
A8:O8 Value
...

Title rows are colored manually.
I need to color rows 3 and 4 in 1 color, rows 5 and 6 in another color. Then again rows 7 and 8 in the first color. And so on.

Any ideas what custom formula in the conditional formatting should be?

I cannot use unique formula as nothing is unique here.

sql server – Filter rows if value exists in different columns

We’re on SQL Server 2016 and 2019

I have a data-set where I’m rolling up a parent/child relationship. I’m doing this because some of the parent rows will return a SalesValue of 0 when their children will the value we’re looking for.

Here’s my query:

SELECT ART.StockCode
     , BOM.Component
     , ART.QtyInvoiced
     , ART.Invoice
     , ART.SalesValue
     , ART2.SalesValue
  FROM TABLE1 ART
  JOIN TABLE2 IM
    ON IM.StockCode = ART.StockCode
  LEFT OUTER JOIN TABLE3 BOM
    ON BOM.ParentPart = ART.StockCode
   AND IM.KitType = 'K'
  LEFT OUTER JOIN TABLE4 ART2
    ON ART2.StockCode = BOM.Component
   AND ART2.Invoice = ART.Invoice

And the data it returns

StockCode   Component   QtyInvoiced    Invoice     SalesValue   SalesValue2
315128      NULL        1.000000             1         154.32          NULL
317324      NULL        1.000000             1          68.31          NULL
317350      NULL        1.000000             1         428.90          NULL
318482      NULL        1.000000             1         171.24          NULL
320058      NULL        1.000000             1          28.58          NULL
320058      NULL        1.000000             1          28.58          NULL
320058      NULL        1.000000             1          28.58          NULL
900550      NULL        1.000000             1        2396.08          NULL
900572      NULL        1.000000             1        1448.84          NULL
900581      NULL        1.000000             1        2017.96          NULL
901012      900581      1.000000             1           0.00       2017.96
901012      317350      1.000000             1           0.00        428.90
901012      317324      1.000000             1           0.00         68.31
901062      900572      1.000000             1           0.00       1448.84
901062      318482      1.000000             1           0.00        171.24

What I’m trying to do is exclude any StockCode that has a value in the Component field that has the same Invoice number

In the example above, we’re looking to exclude stock codes 900581, 317350, 317324, 900572, and 318482 because they already exist in the Component field.

Here’s what I’m going for:

StockCode   Component   QtyInvoiced    Invoice     SalesValue   SalesValue2
315128      NULL        1.000000             1         154.32          NULL
320058      NULL        1.000000             1          28.58          NULL
320058      NULL        1.000000             1          28.58          NULL
320058      NULL        1.000000             1          28.58          NULL
900550      NULL        1.000000             1        2396.08          NULL
901012      900581      1.000000             1           0.00       2017.96
901012      317350      1.000000             1           0.00        428.90
901012      317324      1.000000             1           0.00         68.31
901062      900572      1.000000             1           0.00       1448.84
901062      318482      1.000000             1           0.00        171.24

How to delete rows from a SharePoint list using PnP PowerShell?

You can delete a list item/row using below command:

Remove-PnPListItem -List "Demo List" -Identity "1"

Where -Identity is the ID of the list item, or actual ListItem object.

Microsoft Official Reference: Remove-PnPListItem

If you want to remove all items from a SharePoint Online list then check below reference:

Remove all items from a SharePoint Online list using PnP PowerShell

Additional Reference: Get-PnPListItem – Using this command first you can fetch the list items (single item or multiple items) and then you can delete the list item using above command.