I got your point.

I have succeeded to migrate a table from SQL Server by importing it the table to Excel, and from Excel sheet to SQLite using Python. The relations between tables I guess I should do it manually.

No, that's not true. For instance, I have installed a net framework for a C# application, but still doesn't run, so, what can I do? To find out why that application is not working?

I know that tools, they simply don't run on my machine. They are C# apps and probably needs some net framework to install. But instead of digging to see why they are not run, I am concentrating to a reliable tool/solution (which I didn't find yet).

Is there any tool/solution to export the tables and then data from SQL Server to SQLite?

Yes, that's worked:

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
UNION
SELECT S.id, S.name FROM
(SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416) AS S

but soon as I put ORDER BY:

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
UNION
SELECT S.id, S.name FROM
(SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416 ORDER BY 2) AS S

Error:

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

I have tried:

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
UNION
SELECT b.id, b.name FROM
(SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416)

But it doesn't like it:

SQL
Executing SQL directly; no cursor.
Incorrect syntax near ')'.
Statement(s) could not be prepared.

Did I understand correctly your thought?

I have tried:

SELECT a.id, a.name FROM my_table a WHERE a.id = 10416
SELECT b.id, b.name FROM
(SELECT b.id, b.name FROM b.my_table b WHERE b.parent_id = 10416)

But it doesn't like it:

Executing SQL directly; no cursor.
Incorrect syntax near ')'.
Statement(s) could not be prepared.

Did I understand correctly your thought?

SQL Server (from Microsoft)

Is there possible to get an UNION in such a way that second part of UNION to be ordered ? I have:

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2 ORDER BY 3

The select from table1 will always get one row, and I need to order just records that come from table2, which could be more than one row ... it is possible to achieve that by SQL ? P.S. I am using SQL Server.

If you need excel in a C++ app, you can consider using this library: GitHub - troldal/OpenXLSX: A C++ library for reading, writing, creating and modifying Microsoft Excel® (.xlsx) files.[^] Less overhead than COM Automation !

I have read that post, I didn't noticed any solution with relative height, I've read not very carefully though.

Excellent ! It works. Thanks!

I need to center a text vertically (and horizontally) along the whole page, and for that I need to setup the height property as relative, respectively whole page. I have tried:

body {
font-family: Arial;
color: #f9f9ff;
background-color:#293138;
}

.center-text {
height:100%;
display: flex;
flex-direction: column;
justify-content: center;
}

Test

How can I achieve this ?

Yes, its working now, thank you a lot !!

Thank you a lot Jeremy. It works for this test, however, I don't think I would go with this solution, because the rest of my html pages are not made it with you approach, and I guess will be difficult to control that pattern several times:

		Tuesday
		2023-03-15
	

	

		![](MyImage.png)
	

	

		text text text text text text text text text  
		text text text text  
		text text text text text text text

You see, the text from the first box should be ceneterd aligned, as long the last box (the right one) should have left - top text centered.

I am struggle (I know alost nothing about html) to insert three div's inside a div, something like this: Untitled hosted at ImgBB — ImgBB[^] I have succeeeded to put only the fist div (that one with date), but the next ones (image + texts) I cannot (yet). How can I add the next two (image + mult line texts) ? Here is y trial (didn't work correctly):

		Tuesday
		2023-03-15
	

	

		![](www.test.com/img/etc.png)
	

	

		text text text text text text text text text text text text  
		text text text text text text  
		text text 

Can you guide me to solve this task ?

It works now, thanks a lot !

Thank you Richard a lot. As you see, the vertical alignment of the second div is not correct, and I don't know why, I am not a web developer at all.

Yes, I know, but the trick is that the second div has no vertical correct alignment, and I don't realise why:

Horizontal and Vertical alignment


.container {
	height: 200px;
	width: 400px;
	border: 2px dashed #4b2869;
	display: table-cell;
	text-align: center;
	vertical-align: middle;
	position: relative;
}
.container1 {
	height: 200px;
	width: 400px;
	border: 2px dashed #4b2869;
	display: table-cell;
	text-align: center;
	vertical-align: bottom;
	position: absolute;
}

container

container1