Since you don't have the religion to modify existing part of the query, you may not have many options to do. Here is one way of doing it...

SELECT ...

1. Create a dataset to populate the fourth parameter

2. This dataset must include the dependent parameters (i.e. Region) as filter or where clauses

3. Create a new report parameter and select...

What errors do you get when executing the queries?

Did you create a linked server to connect to the remote server?

Here is sample script to create a linked server:

DECLARE @strLinkedServer NVARCHAR(100)

SELECT...

Assuming that the no. of pivot columns is not static, you have to build a dynamic pivot SQL for each distinct value of the pivot column.

The below solution uses the...

Yes, it is possible in SQL 2005 using ROW_NUMBER() function.

CREATE VIEW dbo.vwSysTables

AS

SELECT ROW_NUMBER() OVER( ORDER BY [name] ) AS UniqueNo, [name] FROM sys.tables

GO

SELECT * FROM dbo.vwSysTables

DROP VIEW dbo.vwSysTables

Firstly, you should have posted this in the correct forum. Since you posted in SQL forum, you get responses related SQL.

Secondly, I am not crystal report designer but...

I would go with SSIS and the following link should get to started

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

Look for ISOLATION LEVELS in Books Online..

Setting the isolation level to "READ COMMITTED" should avoid the dirty reads (not sure on this).

Most of the time cursors/loops performs poorly than set based methods with only some rare cases when loops performs better than a set-based approach.

In your case, one go insert is...

See this following link that explains the warehouse refresh methods...

http://www.sqlis.com/post/Get-all-from-Table-A-that-isnt-in-Table-B.aspx

Look for Package Configurations in Books Online

Since you already have a working calendar table, all you need is a COUNT query to get the no. of working days between two dates. For e.g.

DECLARE @Date1 DATETIME,...

If you want the rows from a query to be returned in any specific order then you must specify the ORDER BY clause. For e.g.

SELECT * FROM SomeTempTable ORDER BY...

Bob was saying that you need a add a Boolean report parameter through "report parameters" option and this will let the users provide an to display full text or the...

I don't think I understood very well, can explain us what do you mean by "the results of one query gets clubbed with another query"? How about adding some...