Sample Code for SQL multi-table row-to-column and cascading row-to-column Conversion

Two existing tables A and B

Table A stores product click logs, and table B stores products.

Display the clicks list of all items on the current day with the total number and sort by day
Copy codeThe Code is as follows:
Declare @ SQL varchar (2000)
Set @ SQL = 'select CONVERT (varchar (100), a. [Time], 23) as Time, count (B. title) as total'
Select @ SQL = @ SQL + ', sum (case B. title when ''' + Title + ''' then 1 else 0 end) as '+' ['+ Title +']'
From (select distinct title from B) as B
Set @ SQL = @ SQL + 'from A as a left join B as B on a. AId = B. Aid
Group by CONVERT (varchar (100), a. [Time], 23) order by CONVERT (varchar (100), a. [Time], 23) desc'
Exec (@ SQL)

Display result

Time	Total	Item 1	Product 2	Item 3
	5	1	0	4
	13	2	11	1