Yes you can.

Can you call the procedure in SQL Server Management Studio without any error?

Write this code in a stored procedure and then call the procedure. Also, what version of SQL Server are you using. Also, is this error result appearing in the SSMS?

Run...

You have not yet replied. Paste the SQL and the sample data you are using.

What data set is the DENSE_RANK() giving you. Also, paste the SQL you are using.

Check this thread http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/4b7fe6f4-abf9-46ce-be5c-d655f1f87fbb

If you have AdventureWorks installed. Try this.

select

[New Rank] = DENSE_RANK () OVER(order by FactInternetSales.orderdatekey)

, *

from FactInternetSales

Replace Rank with Dense_Rank.

A class of functions in T-SQL called as Windowing Function can be used to get the desired result as in your case. You must also understand the scenario where to...

The correct syntax is:

Select {Measures} ON COLUMNS,

{Dimensions} ON ROWS

FROM <<cube_name>>

WHERE

(any_slicers)

The usual practice what I have observed is "crude". The FTP initiates at certain time during the day, which is believed that the FTP host server will have the files....

Thanks for the feedback.

The FTP Task does not supports SFTP. Infact, there is no native support to SFTP as yet. Hence, a third party task or a custom code...

Any project even a package to load text data to SQL Server tables can be very resourceful to explore the insights.

Check this link:

http://www.mssqltips.com/sqlservertutorial/207/creating-a-simple-ssis-package/

Yes I know, so the original poster should also know who mentions about test engines.

What do you mena by "data is available"? Do you get load in terms of a flat file which you process. Please share more info. so as to facilitate us...