My solution was returning a float and involved converting to BINARY(8).

I never got time to fix a bug in it (I'm busy writing an upgrade for migrating our old...

I think I can see a way to do this. Let me iron some stuff out and I'll get back to you.

---

OK, I'm close. For starters, when you say "numerical...

yeshupandit_2002 (10/26/2012)

---

Hmmm but what if Skills are in different numbers for each ACCOUNTNO

Like

declare @skills TABLE

(

ACCOUNTNOVARCHAR(5),

...

Sorry, only just spotted your reply!

Gohloum (10/25/2012)

---

Thanks for those links! I have read the one on Tally and I completely understand the concept, especially from a performance issue. ...

Could you not just write it like this: -

UPDATE fi

SET fi.cor = 'Y', fi.tam = 'Z'

FROM (SELECT referencia

FROM arttamcor

...

SELECT ACCOUNTNO,

MAX(CASE WHEN rn = 1 THEN SKILL END) AS Skill1,

MAX(CASE WHEN rn = 2 THEN SKILL END) AS Skill2,

MAX(CASE WHEN rn = 3 THEN SKILL END) AS Skill3

FROM...

britinusa (10/25/2012)

---

Ok, so I am a little late ...

Migrating a db server from MS SQL Server 2000 to 2005.

In SQL 2000 editing a storedproc was easy. Properties...

Luis Cazares (10/25/2012)

---

I was so close, thanks to the QotD that made me remember the PARSENAME function.

My code

SELECT @HOLDER = ID

FROM #testEnvironment

WHERE PARSENAME( CAST(yourData AS NVARCHAR(MAX)),3) IS NULL

AND PARSENAME(CAST(yourData AS...

Good idea Mark. I also added an ugly XML split to count the number of "items", then modified the test script to clear the cache between each piece of...

Two solutions. . . this means performance check!! 🙂

Here's 1 million rows of sample data: -

SET NOCOUNT ON;

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

--1,000,000...

Gohloum (10/24/2012)

---

Oh my.... That is seriously COOL! :w00t:

OK, I noticed something. My original code pulls from Sunday to Saturday week periods, and includes the most recent sunday...

Are you using SQL Server 2005 ?

If so, change the solution to this: -

--== START OF SOLUTION ==--

DECLARE...

Gohloum (10/24/2012)

---

Oof... Just saw your reply. That went just a hair over my head. Would you mind adding a few comments in the code as the sections process...

Sorry, didn't see the join in there so provided a part solution.

Try this instead: -

--== START OF SOLUTION ==--

DECLARE @WEEKS INT;

SET @WEEKS = 12;

WITH CTE(N) AS (SELECT 1 FROM (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))a(N)),

CTE1(N)...

Sorry, took a bit longer than I expected.

I think you're after something like this: -

DECLARE @WEEKS INT;

SET @WEEKS = 12;

WITH CTE(N) AS (SELECT 1 FROM (VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1))a(N)),

CTE1(N) AS (SELECT 1 FROM...