Without something to test this against and using Dwain's tip on the row_number, the following may do what you want

;WITH NewIDAllRecords AS (

SELECT

jobDB.num AS JobNumber,

DateAdd(minute, 570, jobDB.entered) AS...

True :Whistling:

Not knowing what the data is for, I suspect...

Assuming that your data is always in the format that you have indicated, you could try

create table #Table1

(

SONumber varchar(10)

)

create table #Table2

(

SONumber varchar(10)

)

insert #Table1

select '123'

insert #Table2

select '123/1'

select *

from #Table1 t1

left...

Luis Cazares (11/1/2012)

---

Be careful methexis, because both queries aren't the same. One uses MAX and the other uses SUM. In this case the show the same results but it won't...

Hi

Does this do what you want? I've used sum to aggregate the WholeACNet.

SELECT Region_Code,

[Original],

[RiverLakes_WWFL],

[RiverLakesSev123_WWFL]

FROM TestData

PIVOT (

SUM(WholeACNet)

FOR Description in (

[Original],

[RiverLakes_WWFL],

[RiverLakesSev123_WWFL]

)

) p

The only confusion has been pointed out by john.arnott. The alias of the "LEAD (Sales,1) OVER (ORDER BY Sales)" should have been "SalesGoal", not "Sales".

May be I am interpretting it...

Something else to go and investigate 😀 Could be...

Hi

I thought I would add in a LIKE query to see how that compared. It wasn't as bad as I thought it would be.

SELECT @StartTime = GETDATE();

SELECT @HOLDER...

Thanks for the question ... also didn't know it existed

Hi

Rather than a procedure you could try a table valued function along the lines of

CREATE FUNCTION fnFooter (@p1 varchar(30) )

RETURNS TABLE AS RETURN

SELECT FooterID, REPLACE(Footer, '@client', @p1) Footer FROM...

Be careful, now. Recursive CTE's that count or do other RBAR ops are nearly as bad and sometimes worse than While loops. Please see the following article for...

This is a recursive CTE, so it will step through the string and...

Hi Luis

As Eugene said, this could be replaced without using a cursor with something like the following.

This example may not be the best way to do it, but it has...

Hi Gabe

Not sure if this is the logic you want to apply, but you may want to add join clauses for the FundID. Should improve it considerably. I...

ben.brugman (10/8/2012)

---

A small change See in the code.

(My reason for this change change is: The essential part of the code is only written once, so it is smaller, clearer and...