Not got 2005 installed any more so not tested it on 2005, but works on 2008R2, but this should give you the basics, might need a few tweaks.

SELECT

IndexName = i.Name,

ObjectName...

i believe the two options are, download the media which has SP4 built in to the setup.exe or uninstall / reinstall then service pack

In the other tablix where you only want to see specfic subtype, can you not change the grouping on that tablix to group by type and subtype1, then do a...

You say you have gotten authorisation for 2 processor licenses, 2012 is core based so you need to purchase 8 core licenses to cover your upgrade if you remove the...

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