Further on the previous solution, here is an executable sample

😎

USE tempdb;

GO

;WITH BASE_DATA(NNAME,NGROUP) AS

(SELECT NNAME,NGROUP FROM (VALUES

('Bill','Finance')

,('Nancy','Ops')

,('Bill','IT')

...

Out of curiosity, what Oracle version/edition/OS are you on?

😎

I'm glad that optimism prevails:-D

😎

Ed Wagner (9/2/2014)

---

Eirikur Eiriksson (9/2/2014)

---

Lynn Pettis (9/2/2014)

---

Curious how the code that our silver spooner posted even worked. After declaring all the variables I still have a bunch of red...

Total lack of...

Quick thought, if the workset is large, I would recommend the Tally table version, see the IO statistics below

😎

Tally table

Table 'Workfile'. ...

Try this, much easier to use replace than concatenation

😎

USE tempdb;

GO

DECLARE @PARAM_DATE_TOKEN NVARCHAR(10) = N'{{@PARAM_DATE}}';

DECLARE @PARAM_DATE_VALUE NVARCHAR(10) = N'2014-08-08';

DECLARE @STR_TEMPLATE NVARCHAR(MAX) = N'''SELECT CAST(CAE_RDB_ENTRY_DATE as Date), *

FROM OPENQUERY(LS_RDB_DWH, ''''SELECT *...

A quick window function solution

😎

USE tempdb;

GO

CREATE TABLE #TotalRevenue_Investments ( [Month] INT,[Year] INT,TotalRevenue INT,Descr VARCHAR(100),Company VARCHAR(100))

INSERT INTO #TotalRevenue_Investments

( Month ,

Year ,

TotalRevenue ,

Descr ,

Company

)

SELECT 1,2014,12,'Late Sales','US Late Sales' UNION

SELECT 2,2014,44, 'Late Sales','US...

Welsh Corgi (9/2/2014)

---

I'm trying to create a Character string so that I can execute dynamic SQL.

The date is going to change.

DECLARE @Select VARCHAR (50)

DECLARE @SQLQuery VARCHAR (500)

DECLARE @PreSelect CHAR (1)

DECLARE...

phingers (9/2/2014)

---

Thanks, that works great on my sample data, but when I try it against the real table with more rows it returns the following error:

The maximum recursion 100 has...

ajmoon1313 (9/1/2014)

---

Thank you all in advance to new blogger and SQL user,

I've been task to pull daily report that covers Thursday throught Wednesday (date field as varchar(10) 2014-09-02)

for example today...

skeezwiz (9/1/2014)

---

yes I know its a star-schema, but its not for the purpose of a warehouse/cube solution. This is a day to day system and the only design change...

Quick thought, redesign the recursive iteration approach, it is a real performance killer, use a tally table instead.

😎

SpeedSkaterFan (9/1/2014)

---

Hallo Eirikur,

I don't think that is the solution

The linked server only allows me a small portion of the things I want to do

1 of the tables I need to...

Now he has put the bat aside and instead taken up the lynching of...