looks like you want to look at row level groupings in SSRS

http://msdn.microsoft.com/en-us/library/ms170246%28v=sql.90%29.aspx

Windows might be 64bit but is SQL 64bit?

add another file to the filegroup that way SQL will stripe the data across both files in an equal proportion

There are links in my signature on Cross Tabs, if you are stuck please follow the second link in my signature on posting code and data so that we can...

Hi

This is a Microsoft SQL Server forum, not a MySQL forum so you might be best asking MySQL questions on a dedicated MySQL forum.

But I am sure that there are...

enable auto growth

manually add space to the file

delete data

http://www.sqlservercentral.com/Forums/Topic1320505-391-1.aspx

looks like you have already posted the same question a number of times

http://www.sqlservercentral.com/Forums/Topic1320505-391-1.aspx

DECLARE @tblProductInfo TABLE (ProductID INT, ProjectID INT, SaleMemberID INT, SaleClosedPrice INT, SaleDate DATE)

INSERT INTO @tblProductInfo VALUES

(1,1,1,1000,'2012-04-01'),

(2,1,2,500,'2012-06-04'),

(3,1,4,500,'2012-05-06'),

(4,1,5,5000,'2012-08-06'),

(5,1,3,1000,'2012-09-01'),

(6,1,2,500,'2012-09-06'),

(7,1,4,500,'2012-07-06'),

(8,1,5,5000,'2012-09-06')

SELECT * FROM @tblProductInfo

DECLARE @FromDate DATE = '2012-06-07', @EndDate DATE = '2012-06-08'

SELECT

*

FROM

@tblProductInfo

WHERE

SaleDate BETWEEN @FromDate AND...

Add the column to the group by statement or remove the column from the select.

what is your dateformat MDY or DMY, also your @fromdate and @enddate look like they are the wrong way around

depends what the connections are doing, thats why you need to diagnose your CPU pressure, it could be that there is a bad query somewhere which is executed when a...

Can you post a screen shot of the selection page of the service pack with the engine clicked so we can see the details in the right hand column of...

Each dataset isrunning at exactly the same time which means that your global temp table isnt ready for the second proc to use it.

Try adding a wait for delay to...

Sounds like its already SP4, what do you get when you run SELECT @@Version?