AND ca_d.name in (''AHLTA','Attachmate Reflection CHCS Companion with Public Keys',

'Essentris','Dragon NaturallySpeaking','Nuance PDF...

Yep, it took about 4 seconds.

Put a PRINT statement right before the EXEC:

PRINT @SoftwareQuery

and have...

Igor Savin (4/27/2011)

---

This my table :

CREATE TABLE TAB1

(

curr tinyint NOT NULL ,

ddate smalldatetime NOT NULL ,

rate decimal(15, 4) NOT NULL ,

primary key (curr, ddate)

)

If "rate" didn't change in comparision...

Hunterwood (4/27/2011)

---

Hi Chris,

I don't know why, but it seems as if the CTE first follow one branch to the top, before following the next, but then all by a sudden...

Here's another solution.

with actuals as (...),

goals as (...)

INSERT INTO tmp_f_contrib_annual_agg (

--put column list in here

)

select

...

from actuals a

full outer join goals g

on g.credit_org_key =...

Hi Markus

I can't figure out how you have a 3.n in your third recursion.

Reference: http://msdn.microsoft.com/en-us/library/ms186243.aspx

Edit: added reference.

A recursive CTE can be difficult to interpret. I find it helps to map out the first few iterations using chained CTE's like this;

;WITH CTEAnchor (x) AS (SELECT x =...

Edit: Moved here.

-- Create some sample data

DROP TABLE #Temp

CREATE TABLE #Temp (Name VARCHAR(5), Attendances INT, Did_Not_Attends INT)

INSERT INTO #Temp (Name, Attendances, Did_Not_Attends)

SELECT 'North', 1, 2 UNION ALL

SELECT 'North', 2, 3 UNION...

Here's the old...

Martin, please can you post the code which works? This gives useful feedback to those who have responded to your request for assistance, and may also...

LutzM (4/26/2011)

---

bitbucket-25253 (4/26/2011)

---

I take exception to the words "very amateur". Read both and thoroughly enjoyed...

Grant Fritchey (4/26/2011)

---

I used to work for a medical software company. it was...

Is it me, or are the posted questions from developers working on medical systems a little worrying?