where do empemail and reportinfo come from? do you have a dataset with them in or are they parameters?

mailto:Parameters!EmpEmail.Value?subject=Parameters!ReportInfo.Value

mailto:Fields!EmpEmail.Value?subject=Fields!ReportInfo.Value

+1 to that, we worked with our reseller to become compliant back...

GSquared (6/7/2012)

---

anthony.green (6/7/2012)

---

GSquared (6/7/2012)

---

Again, this is just my take on the whole mess:

You might be better off on a per-processor license. 2012, if I understand the licensing correctly, has...

GSquared (6/7/2012)

---

Again, this is just my take on the whole mess:

You might be better off on a per-processor license. 2012, if I understand the licensing correctly, has a per-core...

Based on the data and the expected output the following should do the trick

declare @sampledata table (Type int, SubType1 int, SubType2 int, Qty int)

insert into @sampledata values

(1,1,1,5),

(1,1,2,5),

(1,2,1,7),

(1,2,2,6),

(1,3,1,4),

(1,3,2,5),

(2,1,1,3),

(2,1,2,5),

(2,2,1,6),

(2,2,2,5),

(2,3,1,9),

(2,3,2,5),

(3,1,1,7),

(3,1,2,5),

(3,2,1,9),

(3,2,2,4),

(3,3,1,5),

(3,3,2,6),

(4,1,1,6),

(4,1,2,5),

(4,2,1,3),

(4,2,2,5),

(4,3,1,6),

(4,3,2,7),

(5,1,1,9),

(5,1,2,5),

(5,2,1,7),

(5,2,2,5),

(5,3,1,2),

(5,3,2,3)

select type, SUM(qty)...

Using the sample datab Gianluca provided, the below gets the expected result output

DECLARE @sampleData TABLE (

id int,

StartDate datetime,

DEP char(1),

EndDate datetime

)

SET DATEFORMAT DMY

INSERT INTO @sampleData VALUES(1,'14/02/2011','A','14/02/2011')

INSERT INTO @sampleData VALUES(1,'14/02/2011','A','15/02/2011')

INSERT INTO...

First off I will say that you first should look at getting more disk space allocated to your servers.

Shrinking a database is a costly operation and causes a range of...

Yes and best practice and good for recovery

I will have to take a look when I get home then and see if there is somewhere local where I can get hold of some

First off I would run this, to see if the DB's have any free space in them

DECLARE @sql NVARCHAR(MAX)

SELECT @sql = REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) +...

First of all I will say that shrinking data files is not best practise and should only ever be done in the event of low disk space and an increase...

You have just quoted what you are...

Refactored it, but a bit messy on the email, need to format it how you want it to by building strings into variables, then passing that into sp_send_dbmail, but works,...

clayman (6/6/2012)

---

Good point but with a FK in place the op would have probably gotten an error msg while trying to delete? Anyway I'm a bit confused what he...

I use this to insert into a table every day the current used, free and total space. You could refactor it to use sp_send_dbmail and build up a message...