Hi DesNorton, Thank you so much for this! It's a massive help and works when creating the task temp table. I am not able to get the script working...

First, we need some sample data

CREATE TABLE #Tasks (
    ID      int      NOT NULL
 ...

• This reply was modified 7 years ago by DesNorton.

Hi, I am passing parameter in my store procedure. declare @year datetime= '2019' select * from table where sportyear=@year How can I extract where if i pass in '2019',...

There is no need for the case statement.

This should do the trick

SELECT CONVERT(VARCHAR(10), DATEADD(DAY, -1, DATEADD(MONTH, 1, 'February' + ' 01 ' + CONVERT(VARCHAR(4), YEAR(GETDATE())))), 101) AS...

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

DECLARE @Year int = 2019;

SELECT PeriodID, EOMONTH(PeriodID + ' 01 ' +...

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

How to post data/code on a forum to get the best help.