First, we need some sample data

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

• This reply was modified 6 years, 5 months 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

            
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...