You can also use the following, which will take care of teh leap year

DECLARE @Year int = 2019;

SELECT PeriodID, EOMONTH(PeriodID + ' 01 ' + CONVERT(VARCHAR(4), @Year))...

Having a loop is an immediate red flag.  Are you sure you can't do it without a loop?

That said, if you can't avoid the loop, you can implement a retry...

If I understand the requirements, a simple UPDATE statement should do the trick.

This will increment every record by 5.

UPDATE YourTable
SET UniqueField = UniqueField + 5;

Although not recommended,...

This should also work

WITH cteSampleData AS (
  SELECT v.SampleString
  FROM ( VALUES ('P11034'), ('P1103'), ('P110345') ) v(SampleString)
)
SELECT  SampleString
      ,...

Hi, I am in a scenario where I need to manipulate some text. For example:

1. p11034  - If the first letter is 'p' and the count of characters to...

Let's work backwards on this.

To view records that you are trying to filter out

SELECT *
FROM ##FctLossData
WHERE ClaimNumber LIKE '836%'

However, ClaimNumber is made up of 2 fields

            
June 6, 2019 at 7:50 pm
            
#3650871

            
            
                                                
        

Reinstated

Please don't double post.

Further responses are available on https://www.sqlservercentral.com/forums/topic/count-of-entries-grouped-by-month-extracted-from-a-date

You need to add a GROUP BY

SELECT  DATENAME(MONTH, CAST(RecvdDate AS Date)) + ' ' + CONVERT(varchar(10), YEAR(CAST(RecvdDate AS Date))) AS 'MonthName'
     ...

Your function is a scalar function, which has terrible performance.

Below is an iTvf (inline table valued function) that will get the last business day

CREATE FUNCTION [dbo].[F_PreviousBusinessDay]
(
@DateInput DATE
)
/*...

If you are unable to change the structure of your DB, you could use a splitter function.  In SQL 2016, you have a built-in splitter function which I believe...

If you are unable to change the structure of your DB, you could use a splitter function.  In SQL 2016, you have a built-in splitter function which I believe should...

I have a situation whereas I need to include a column that is nonexistent in the table(s).  The primary table has a CreatedDate and an UpdatedDate field.  I need...

How nice it is to see this again - a bunch of folks working the hell out of a problem to come up with their solutions, each one faster...

Object names cannot be passed into sp_execute_sql.

On another note, there is no need to use nvarchar(max) for your object types.

  @table     ...