I found my problem.  Thank you!

The case statement in this SQL statement is not returning the correct results. It is returning all 1's.

Can someone point me in the direction where I am going wrong with...

I apologize for posting twice.  I didn't know there was a reporting services forum.  Thank you!

Thank you! I'll give it a try and let you know how it worked for me.  Looks like it should work fine.

Thank you!  This worked great!

Moving the fetch next statement fixed my issue.

Thank you!

Thank you for your reply.  I'm sorry for being such a beginner.  Can you give me an example of how I would use SET to acomplish what I am trying...

Thank you for your feedback.

If I wanted to insert multiple rows at one time with this stored procedure how would I modify the updated stored procedure to do that?

Here is what I came up with to return a list of all inserted ID's:

USE [Research]

GO

/****** Object: StoredProcedure [WEB].[sp_GetCasesFromPowerPath] Script Date: 1/31/2022 3:09:49 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE...

Does that just return the last inserted ID?

I'll work on providing DDL, I just came up  with a quick example because I can't share the actual ddl.  I'll have to create a test example this weekend and...