Temporary Table using SQL server

Explanation:

1. Temporary Table:

   • A temporary table (#TempEmotionStats) is created with the necessary columns: EmotionTypeId, Total, Icon, and TotalEmotionCount.
   • The data types (INT, NVARCHAR, BIGINT) are chosen based on typical use cases. Adjust as needed for your actual schema.

2. Data Insertion:

   • The INSERT INTO statement populates the temporary table with the results of your query.

3. NOLOCK:

   • The WITH (NOLOCK) hint is used to avoid locking issues. Use cautiously, as it may return uncommitted data.

4. Temporary Table Visibility:

   • The table (#TempEmotionStats) will be available only in the current session and automatically dropped once the session ends.