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)

---

Scenario

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)

---

Scenario

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