Are you working for Skynet?

😎

ppritts (9/2/2014)

---

I had an SSIS Package that took data from a flat file and moved it into a SQL Server table. It was working OK, but I had to add...

Lynn Pettis (9/2/2014)

---

I...

😎

crazy_new (9/2/2014)

---

Just a quick question. In the inserted/deleted tables, does it contain all of the records of the last single transaction made? And if I use set based logic,...

As I said...

Ed Wagner (9/2/2014)

---

Thanks, but I guess...

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