No, I am referring to the username that is used when logging in, not the Display Name.  You cannot change the username for the login.

Why can't we change the username?  It's 2022 for petes sake.  This is annoying for members that have been around for years.

I should've written the complete update statement:

Parameters:

@StoreID int,

@CategoryID int,

@ReferenceID int = NULL

UPDATE MyTable

Set MyStatus = 'Closed'

WHERE StoreID = @StoreID

AND MyCategoryID = @CategoryID

AND MyStatusID IN ('Open', 'Acknow')

AND (@ReferenceID IS NULL OR...

Jeff,

I am looking at your sample and I have to ask one question:

By using master.sys.all_columns, aren't you limited to 1000 days?

I am looking at generating a row for each date...

Where is the minimum of 6 specified? Was I sleeping? I was thinking the same as the previous post but didn't understand where 6 came from?

Looks like I solved this issue by doing the following:

Connected to the master as sa.

Executed the command: GRANT IMPERSONATE ON LOGIN::mylogin to mycallerlogin;

Then in my stored procedure did a...