Generate Sql queries on the fly

BEGIN
DECLARE @TableName as nvarchar(50),@test as nvarchar(max)
SET @TableName = 'orders'
Print @TableName
SET @test = 'SELECT * FROM ' + @TableName
EXEC(@test)
END

SQL send an email from database mail

use Test
execute msdb.dbo.sp_send_dbmail
@profile_name='TEST',
@recipients = 'anemailadres@domainname.com',
@body = 'body of the mail',
@query = 'select * from orders',
@execute_query_database='',
@subject = 'subject of the mail',
@attach_query_result_as_file = 1

SQL With TIES Example

SELECT *
FROM QryCustomersWithMostOrders

Customer   OrderCount
A               3
B               3
C               1

SELECT  TOP 1  *
FROM QryCustomersWithMostOrders 
ORDER BY  OrderCount DESC

Customer   OrderCount

A               3

SELECT  TOP 1 WITH TIES *
FROM QryCustomersWithMostOrders 
ORDER BY  OrderCount DESC

Customer   OrderCount

A               3

B               3