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

SpeedSkaterFan (9/1/2014)

---

Hi all,

I would like to use SSIS to get data from a mySQL database to SQL Server.

I have created a project incl package. In this package I have added...

Not certain there was a comprehension of the punchline:-P

😎

Here is somewhat a generic sample, should get you passed this hurdle. This is not a complete solution but rather a demonstration of the technique.

😎

First the schema and the sample...

Quick questions below

😎

First table that I am deleting from, i'm inserting the new values into. The reason I have to delete from that table is to avoid duplicate...

Guitar_player (9/1/2014)

---

Hi Eiriksson,

There are also quite records like 'ABC DEF 210...

Here is another method, find the last character which is not space or numeric

😎

USE tempdb;

GO

;WITH SAMPLE_DATA(ID,Column1) AS

(SELECT ID,Column1 FROM

(VALUES

(1,'ABCD 123')

,(2,'XY 567')

,(3,'ghj 001')

,(4,'RUT')

,(5,'PUT')) AS X(ID,Column1)

)

,T(N) AS (SELECT N FROM (...

cliffgettings (8/29/2014)

---

Jack Corbett (8/29/2014)

---

Sounds like a good use for RowNumber() something like this (since I don't have your schema I'm just guessing at some things see the first...