It complains about memory... I loop through File01.zip -File82.zip, after file15.zip the task falls over, I the rerun it, the first file is file16.zip ... file31.zip... I rerun the task...

Thnk! i managed to get it to work by extending the FTP connection properties! It now works like a charm!

Hi Grasshopper

I have once done that through a trace using profile that writes the loggins into a table(I guess u can use a file as well). Try that and let...

select top 1 * from (

select top 4 * from test

order by [No] asc) a

order by [No] desc

Hope this come with relief!

Sello

select top 1 * from (

SELECT TOP nth * FROM tablename

ORDER BY column DESC) a

Just make sure you don't have >two records with the same value.

Otherwise use (if so use)

select...

Change your table properties in you report. Make your rows your columns and your columns your rows!in sql, this logic will help in creating a dynamic sql, depending on whether...

Alter the dataset(s) in your drill through report to receive the parameters you will be passing from your master report i.e your dataset(d) shud be dynamic!

Hi try something similar to this:

CREATE PROC [dbo].[parListClubs] -- Parameter list

AS

SELECT

-1 AS ClubID,

' ' AS ClubName

UNION ALL

SELECT

Entity_ID AS ClubID,

Name AS ClubName

FROM dbo.Clubs

ORDER BY ClubName...

The mails need to be sent via a service account held by some other company.

If u recommend xp_sendmail, I get the @user not defined message.

I have created a stored proc...