Setup a subscription to shared folder (not email).

Then use SSIS to first compress (zip) the file (say Excel) and then copy to FTP site folder.

Have done this and it works.

Thanks Joe, it worked fine.

I modified your code slightly to cater for instances where the student_name is null by using

OVER (PARTITION BY school_name) instead of OVER (PARTITION BY student_name).

Code...

Hi Jack, in some of the rows the value for [Student] column is NULL.

This causes your query to give incorrect results. How do I fix ?

Objective: where there is multiple SourceType for a Student, only return rows where SourceType is

minimum value. Thanks Jack, your query worked like a charm.

Had to modify your query a slight...

If the subreport back button ( <--) works in Visual Studio (BIDS) then the subreport back button (web browser) should work in Report Manager. Many times the back button in...

select . . .,

SUM(CASE WHEN DATEPART(wk, mydate) = 1 THEN myfield ELSE 0 END) as Week1Total,

SUM(CASE WHEN DATEPART(wk, mydate) = 2 THEN myfield ELSE 0 END) as Week2Total,

.

.

.

SUM(CASE WHEN DATEPART(wk,...

Looking at all the weekday examples, here is my 2 cents.

SELECT -- convert StartDate to weekdays

CASE

WHEN DATEPART(day,[StartDate]) - datepart(day,DATEADD(ww,0,getdate())) = 0 THEN 'MON'

WHEN DATEPART(day,[StartDate]) - datepart(day,DATEADD(ww,0,getdate())) =...

Hi veeren4urs, can you give examples of join on report side ?

Hi Jack Corbett, your example illustrated the basic use of Cursor and While Loop, can you use the same example and provide a set based example. I have a number...

Thanks ravi4work. Your method worked excellent in the one type of stored procedure. In the other type of stored procedure my method worked excellent. Thanks again.

Hi Jeff, it worked like a charm. Not to mention that the code is not complicated or cumbersome,

yet extremely effective. Thanks again.

Hi Jeff, thanks, you're a genius. I also had a look at some of your other articles:

http://www.sqlservercentral.com/articles/T-SQL/62867/

The "Numbers" or "Tally" Table: What it is and how it replaces...

Hi Bhuvnesh, I think you misunderstood my post.

The Stored Procedure has one date parameter (UpdateDate).

Want to execute the stored procedure in a loop while the UpdateDate is between

'2010-01-05' and '2010-01-25'.

/*

The Stored Procedure has a date parameter.

myProc should run in a loop while the date is between '2010-01-05' and '2010-01-25',

so date '2010-01-28' will be skipped.

I dont want to add anything...

Hi dehqon, my problem is almost identical to your's. Hope someone can assist us.