No need for a performance problem caused by a scalar udf. There's a simple formula explained in the following article that can help you simplify your code.

http://www.sqlservercentral.com/articles/ISNUMERIC()/71512/

SELECT

...

Using the OVER clause and the REPLICATE function, you could achieve this.

SELECT WarehouseNumber,

ItemDescription,

Quantity = REPLICATE('?', COUNT(*) OVER( PARTITION BY WarehouseNumber,...

Are you merging or you're just updating? If you're just updating, use UPDATE.

Here are some general examples:

UPDATE t

SET value = s.value

FROM TargetTable t

JOIN SourceTable s ON t.id = s.id

...

That would have implied additional work.

Maybe something like this?

select rcp.CalendarPeriodId

,rc.CalendarId

,rcp.CalendarYearId

,rcp.PeriodNumber

...

sys.user (2/25/2016)

---

Luis Cazares (2/25/2016)

---

Dodgier according to who?

If your problem is that you have too many columns in the GROUP BY clause, you could use a different approach.

I used a CTE...

Dodgier according to who?

If your problem is that you have too many columns in the GROUP BY clause, you could use a different approach.

WITH cteCrsSub AS(

SELECT...

Maybe something like this:

SELECT String,

SUBSTRING( String, CHARINDEX('yesterday', String), CHARINDEX('tomorrow', String) - CHARINDEX('yesterday', String) + 8 /*LEN('tomorrow')*/)

FROM(VALUES('Learn from yesterday, live for today, hope for tomorrow. The...

Is it too early for these answers? http://www.sqlservercentral.com/Forums/Topic1764225-3411-1.aspx

Try this

Lynn Pettis (2/24/2016)

---

Luis Cazares (2/24/2016)

---

The set-based loop might be faster. The example shown in the article is basically the same as this one and the improvement...

Bohemian (Rhapsody)

rodjkidd (2/24/2016)

---

Grumpy DBA (2/24/2016)

---

jasona.work (2/24/2016)

---

http://www.sqlservercentral.com/Forums/Topic1763775-3412-1.aspx

/Me leans back, grabs bucket of popcorn

Sure sounds like Gail answered the original question, yet for some reason the OP decided to focus on the comments...

The set-based loop might be faster. The example shown in the article is basically the same as this one and the improvement was noticeable.

If there's a PASS user group near you, you could start there. It doesn't need to be from PASS, but it would be the obvious choice.

For general public speaking,...