The OP just PMed me with all the info that had been posted on the forum thread. Apparently he deleted because...

Here is my refactored code:

with BaseData as (

select

*,

Seq = Year_From - (row_number() over (partition by Sport, SportEvent, Gender, Country order by Year_From)...

I have to agree. It works as expected for me as well.

Wow, what some people expect us volunteers.

You do realize that in SQL Server 2005 and newer you should really be looking at sys.server_principals and not syslogins for this information.

Why did you delete your posts?

You also realize I am a volunteer and that I have my own job to work, right?

Luis Cazares (4/28/2015)

---

Lynn, I'm curious.

What where you expecting to do with the Years and Tally CTEs? I'm sure that you included them for your tests, but I'd love to...

15df2o+1caatrp9bznv8 (4/28/2015)

---

ive hit a wall would anyone be able to help me with this ?

TSQL Stored procedure

Create a stored procedure which will insert a purchase of shares into the...

forrest77 (4/28/2015)

---

Here is the create table statement

CREATE TABLE [dbo].[EditLog_back](

[Id] [INT] IDENTITY(1,1) NOT NULL,

[EditDate] [DATETIME] NOT NULL,

[PlanId] [INT] NOT NULL,

[TransId] [INT] NOT NULL,

[EntityId] [INT] NOT NULL,

[QtyPrior] [FLOAT] NULL,

[QtyAfter] [FLOAT] NOT NULL,

[Description]...

I have the following code:

with Years as (

select

min(Year_From) YearBegin,

max(Year_From) YearEnd,

(max(Year_From) - min(Year_From))/4 YearsSpan

from

#mySeries

), eFastTally(n)...

Based on the sample data what should the expected results look like?

From the original post:

- Identical hardware between principal and mirror

I...

Like this using Ed's code.

WITH FinalDBUser(dbname, username) AS (

Select

dbname,

username

from

dbo.FinalDBleverluser

Order by

dbname

)

SELECT @strSQL = @strSQL +...

I'd do it using the FOR XML PATH method. I would post the code, but for some reason I can't. Something in the code is causing a post...

Something like this:

DROP FUNCTION [dbo].[ADMC_DDL_GetUniqueEditLog];

go

CREATE FUNCTION [dbo].[ADMC_DDL_GetUniqueEditLog]()

RETURNS TABLE WITH SCHEMABINDING

RETURN

WITH BaseData as (

SELECT

EL.Id,

EL.EditDate EditData,

EL.PlanId PlanId,

...