Maybe you can use a pivot tables in SQL Server

You can start by testing this one

http://blog.ironcitybi.com/2011/02/28/implementing-stats-t-test-function-in-sql-server.aspx

you can read this http://msdn.microsoft.com/en-us/library/ms179316.aspx

A bit complicated code, what are you trying to do?

why do you try running a function from a stored procedure after passing a value form the Exist statement

Check the profile of the stored procedures in SQL server management studio one of them might be too big or taking so long.

Hi

Adding cascading parameters in SSRS is a bit tricky, i would advice to check the cascading parameters cause they might be the problem.

Good question

And also look at this

http://msdn.microsoft.com/en-us/library/ms191164.aspx

Usually the service packs are used to solved small bugs or introduce some features that would not make it a new product version.

Look at this

http://technet.microsoft.com/en-us/library/bb934199.aspx

or search on the internet using Peer to Peer replication conflicts sql server

try this

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/6755e606-acbb-4733-a6c6-7bb27083fa18

I suggests that run your queries with either the estimated or actual execution plan enabled then look at what wasting more space then maybe refactor or design a new query.

You can use DATEADD as below

declare @myDay datetime

set @myDay = dateadd(month, -1, getdate())

selectgetdate() 'today',

@myDay 'Lastmonth'

You can see an example on this website

http://www.mssqltips.com/tip.asp?tip=1213

or you can open the SQL Server 2005 instances from the SQL server 2008 management studio. In this you will be working as if in SQL server 2005.