Viewing 15 posts - 1 through 15 (of 402 total)
Glad its helping people 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
September 30, 2016 at 7:35 am
Glad it helped 😀
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 18, 2015 at 1:31 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 29, 2015 at 1:58 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 28, 2015 at 3:38 pm
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
October 7, 2014 at 8:34 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
October 3, 2014 at 6:05 am
Koen Verbeeck (5/29/2014)
Andy Hyslop (5/29/2014)
Worth noting that the VS2013 version only supports SQL 2014 at the moment
According to a comment from MSFT on this blog post, they started a project...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 29, 2014 at 6:02 am
Worth noting that the VS2013 version only supports SQL 2014 at the moment
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 29, 2014 at 1:56 am
Any reason you cant use an IDENTITY?
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 29, 2014 at 1:45 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 27, 2014 at 8:59 am
No probs 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 27, 2014 at 7:05 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 27, 2014 at 6:49 am
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'
...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 27, 2014 at 6:36 am
srikantmeister (5/21/2014)
you can use powershell scripts commands to move all your jobs by a single job on server.
Do you have any links or example of these scripts?
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 22, 2014 at 6:36 am
but the explanation is a bit light on content [Wink]
Indeed I was 😉
This was intentional (just wanted to point in the right direction) as there is a wealth of...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 20, 2014 at 6:11 am
Viewing 15 posts - 1 through 15 (of 402 total)