a Slight modification to use an inline Tally table and my own String for demos

--===== Simulate a passed parameter

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = 'this is a very long string just...

I would say that the fact the script in the CTE runs quickly doesn't mean that it will do the same when inside a CTE, especially where you have scalar...

If you run this you can see the cause, all I've done is added an S column to show which query is causing the issue.

DECLARE

@MGR_NAME NVARCHAR(100)='Betts, Brian'

,@COUNTRY NVARCHAR(100)='US'

,@SEGMENT...

Create a job that uses variables stored in a database, to configure the package then, simply write a script that updates the necessary variables, to the required values, and execute...

Phil Parkin (12/4/2014)

---

Jason-299789 (12/4/2014)

---

IN SQL server if you do a divide an Integer by an integer you get an integer, and a count will only ever produce an integer.

to...

IN SQL server if you do a divide an Integer by an integer you get an integer, and a count will only ever produce an integer.

to get round this...

True, I was just demonstrating why people sometimes forget to declare the length of the VARCHAR in a declare statement, because they are used to using the CONVERT/CAST method without...

Its not as if its that difficult to create a system view in the model DB that gets replicated to all new databases that are created.

PS : Voted +1

Phil Parkin (12/2/2014)

---

Jason-299789 (12/2/2014)

---

MS don't make it easy for people from BOL

When n is not specified in a data definition or variable declaration statement, the default length is 1. When...

MS don't make it easy for people from BOL

When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not...

GilaMonster (12/1/2014)

---

Or maybe a temp table, since the Row_Number function doesn't exist...

Ok so if we assume that you are using SQL 2012 then you have the new Lead and LAG window functions

this calculates the difference from the previous row.

create table #temp_Octets...

I didn't read the op properly code posted below

aaron.reese (12/1/2014)

---

I believe that all the standard components in ssis are .NET classes so you could always write your own c# or vb.net to generate packages but it would be...

Koen Verbeeck (12/1/2014)

---

Jason-299789 (12/1/2014)

---

Wouldnt it be better to have an article or Stairway series...