Glad its helping people

Glad it helped

Thanks for the replies both - I'm surprised more people haven't had to code something like this

When I was asked to do this my first thought was I want 1...

Hi Steve

Thanks for the reply

There is a cavieat I forgot to mention..my apologies

Rows are only ever inserted sequentially and never updated and archiving takes place once a month and...

Perry Whittle (10/7/2014)

Talib123 (10/3/2014)

AG failover to DR Node.

Setup

Server A – Primary Datacentre

Sever B – Primary Datacentre

Server Z – DR Datacentre

Primary DC down. Manual Failover to DR Datacentre.

Question.

At the...

Talib123 (10/3/2014)

AG failover to DR Node.

Setup

Server A – Primary Datacentre

Sever B – Primary Datacentre

Server Z – DR Datacentre

Primary DC down. Manual Failover to DR Datacentre.

Question.

At the point of...

Koen Verbeeck (5/29/2014)

According to a comment from MSFT on this blog post, they started a project...

Worth noting that the VS2013 version only supports SQL 2014 at the moment

Any reason you cant use an IDENTITY?

I assume you mean SSRS 2012?

As far as I know there is no way to move the default location of the parameters (although someone may correct me)

It would be possible...

No probs

Guessing at what you are trying to achieve here - but I'll take a stab:

DECLARE @MAXVALUE INT

SET @MAXVALUE =

(

SELECT MAX(sectionnumber)

FROM dbo.BNYWorkingSecTable

)

INSERT INTO dbo.BNYWorkingSecTable

(

SECTION

,SOMECOLUMN

)

SELECT

SECTION

,@MAXVALUE

FROM

dbo.GLAccounts1

WHERE NOT EXISTS

(

SELECT...

Could Try I'm guessing at the Varchar Length:

,CAST(TEN.[tncy-sys-ref] AS VARCHAR(50))

+ CAST(CASE WHEN PER.[GENDER] = 'M' THEN '1'

...

Do you have any links or example of these scripts?

Indeed I was

This was intentional (just wanted to point in the right direction) as there is a wealth of...