Thanks Steve - good basics type of question.

GilaMonster (9/11/2011)

---

I think the hard drive failure's worse. Cost me most of last night and a good part of this morning and I'm working on my laptop until I can...

Is...

Best cat...

Jeff Moden (9/9/2011)

---

I took the minimalist approach which also avoids the loop which would allow it to be used in an iTVF (unlike looping solutions). You might be able...

Jeff Moden (9/9/2011)

---

SQLRNNR (9/8/2011)

---

jared-709193 (9/8/2011)

---

SQLRNNR (9/8/2011)

---

Here's a script that should work for you.

SET DATEFORMAT DMY

DECLARE @StartDateDATE = '05/06/2011'

,@EndDateDATE = '31/08/2012'

;

WITH getmonths AS (

SELECT cast(Convert(varchar,'01/' + cast(MonthNum as varchar) + '/'...

srikanthms (9/8/2011)

---

there is no prerequiste is defined for this question.

such as procedure must be already created, UnitMeasure table to be created with production user etc.

Because of this, this has to...

I think this will be of help.

;

with tablesize as (

select so.Name as TableName

,TableSizeMB = convert(decimal(15,2),si.dpages *8 / 1024)

,IndexSizeMB = convert(decimal(15,2),sum(isnull(si2.used,0))*8 / 1024)

,TotalSizeMB = convert(decimal(15,2),(si.dpages * 8 /1024) + (sum(isnull(si2.used,0))*8 /...

jared-709193 (9/8/2011)

---

SQLRNNR (9/8/2011)

---

Here's a script that should work for you.

SET DATEFORMAT DMY

DECLARE @StartDateDATE = '05/06/2011'

,@EndDateDATE = '31/08/2012'

;

WITH getmonths AS (

SELECT cast(Convert(varchar,'01/' + cast(MonthNum as varchar) + '/' + cast(yr.yr as...

Here's a script that should work for you.

SET DATEFORMAT DMY

DECLARE @StartDateDATE = '05/06/2011'

,@EndDateDATE = '31/08/2012'

;

WITH getmonths AS (

SELECT cast(Convert(varchar,'01/' + cast(MonthNum as varchar) + '/' + cast(yr.yr as varchar)) as...

Ninja's_RGR'us (9/8/2011)

---

Then they wonder why it doesn't work and why it takes longer than requested and costs more than negociated. Also why we don't want to...

Sad reality 😎

union

What happens when you try to run the package outside of the job?

Jack Corbett (9/8/2011)

---

I've missed 24HoP due to work not liking streaming (I really need a telecommute job) and other responsibilities last night.

I believe I'll be seeing Grant on...