Also, when I run my query based on your above code, everything returns as 1 for average.  I know that is not correct.

select created_date, avg(Cases6) 
from [dbo].[tmp_CasesAssigned]
group...

I think you are on the right track here.

Instead of an average for each day , he wants just 1 average per date range (weekdays) for 6 cases, 7 cases,...

I think I must be saying this wrong.  This is the quesiton that was asked of me:  What is the average number of days that physicians had the following number...

I changed the way I did this to try to make it easier.  I've calculed the case assignments and put in totals.  If cases 6 has a value of 1...

Here's the data:

Created_Date Pathologist Cases6 cases7 cases8

2022-06-01 Best Rocha M.D., Alejandro NULL NULL NULL

2022-06-01 May M.D., Rebecca NULL NULL 1

2022-06-01 Bourne M.D., T. David NULL NULL 1

2022-06-01 Murphy M.D., Joel...

Ok, I created a report that has a count of the # of cases assigned per day.  Each column contains a count based on a specific # of day's. See...

I don't need to find out open cases only cases assigned.  I'm unclear why I need to bring in a calendar table (even though I do have one), when I...

I had to add two extra ticks at the end:

ROM DISK = '''

* @backupPath + @backupFile + ''' WITH STANDBY = N''D:\TelcorLogDump\ROLLBACK_UNDO_Telcor.BAK'''

I figured out why the exec @cmd wasn't working. I was filtering out the files before it got to the cursor. Now I have one last problem. I am getting...

I should still be able to restore each log in standby mode.  I changed the exec @cmd to a select @cmd and I got no results. Something is going wrong...

Here is  the answer I came up with.  It's works for me. Thanks 🙂

select

*,

LTRIM(RTRIM(REPLACE(REPLACE(IIF(LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client Called], CHARINDEX('on',[Time Client Called]), 15),13))) is null, null, LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client Called], CHARINDEX('on',[Time Client Called]), 15),13)))),...

0

I got this working. Thank you all for your assistance.

select

*,

LTRIM(RTRIM(REPLACE(REPLACE(IIF(LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client

Called], CHARINDEX('on',[Time Client Called]), 15),13))) is null, null,

LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client Called], CHARINDEX('on',[Time

Client Called]), 15),13)))), 'a', ''),'t',''))) as "Date Client Called",

IIF(LTRIM(RTRIM(RIGHT(SUBSTRING([Time Client...

Thank you for your feedback, and I'm so happy there are people like you out helping those of us that just don't get it...  I tried your code.  I posted...

I'm sorry, I had to step away and was not able to respond to my post.  I apologize for that.

The date could be 2/1/2022 or 12/1/2022

The time could be 3:27...

I got really whacky results using this:  patindex('%[0-9]%/[0123][0-9]/[2][012][0-9][0-9]%'