I'm not sure I fully understand the requirements.

Do you need the first and last [activityId] = 0 / IN (0, 1) in the partition regardless, or does some other row...

WITH cteRowNum(GroupName,AgentName,AgentEmail,

TicketsCompleted, RowNums) AS (

SELECT GroupName,AgentName,AgentEmail,TicketsCompleted,

DENSE_RANK() OVER(PARTITION BY GroupName ORDER BY TicketsCompleted DESC) AS RowNums

FROM Table

WHERE AgentName IS NOT NULL

)

SELECT cteRowNum.GroupName,cterowNum.AgentName,cteRowNum.AgentEmail, cteRowNum.TicketsCompleted

FROM cteRowNum

WHERE cteRowNum.RowNums = 1;

I assume you could have a Function2 and then data for it.  If so, there needs to be something to order the rows: an identity column, a datetime, etc..  Do...

Perhaps you could create a view with the columns in your (client's) preferred order?  It it was a full view, it should be updatable and therefore the view name could...

SELECT
    SUM(CASE WHEN HowManyDays <= 30 THEN thisAmt ELSE 0 END) AS aging_0_30,
    SUM(CASE WHEN HowManyDays >= 31 AND HowManyDays <=...

(1) Use differentials rather than full backups for most backups.  For example, daily diffs and only, say, weekly full backups.

(2) If you're not already using backup compression, and particularly if...

The value needs to be a string:

STRING_SPLIT('1008,1009,1011,1014',',')

A NULL value should not cause an error, ASCII(NULL) should just return NULL.

How do you define "week number"?  Are the first 7 days of the month "week 1", or is it based on specific day of the week?  For example, all weeks...

Increase the size of  your tempdb files.

Inside that same db, run this command:

EXEC sys.sp_help tblstudent

or this:

SELECT * FROM sys.columns WHERE name = 'tblstudent'

Either of those should give you info about the table to compare to the...

"tblstudent" already exists -- with a different number of columns -- so the create table statement is failing, but the insert still tries to execute.

If, as you say, you are querying by a single, unique PK value, the lookup should be quick...

I'll take a look at it a bit later today.

You're welcome.  Yeah, OUTER APPLY is pretty useful, like here when you kinda want a join but only want 1 row, not all of them.