I wish to apologize to those who answered the QOD and had their answer judged to be incorrect, and to all members of the SQL Server Central community for my...

To get started quickly use this:

http://www.sqlservercentral.com/tags/Security

On SSC pay particular attention to articles by Brian Kelly - an expert on SQL Server Security starting with:

http://www.sqlservercentral.com/search/?cx=000517265726492607871%3Agqdiynsp-y0&cof=FORID%3A9&q=%22brian+Kelly%22&sa=Go#1051

I know this started as a forum for venting about OPs who do not post enough information or demand answers or other wise become a pain in the you know...

Mail2Payan

I am not sure I understand your question properly. All the information you want to display is accessible by using your T-SQL code and there is no need for...

mail2payan

CONGRATULATIONS.

You worked it out. Good luck on the remainder of your project.

Mail2payan

I ran your modification of Steve Jones' T-SQL and reieved the following results:

Student course credit Grades Grade Points...

Please help us to help you...

READ the article in my signature block and post the create table statements, and sample data for each table

after you have done that please explain...

As far as I can determine there is NOT a column in your table with the name of Points.

If there is such a column please post the Create Table...

Strictly as additional information and NOT as a substitute for Steve Jones' or Chris Morris' code,

but just as a matter of reference for yourself,

there is a known bug...

From this SSC article:

http://www.sqlservercentral.com/articles/SSIS/64585/

1. Drag and drop OLE DB Source data flow source to the data flow task.

2. Double click the OLE DB Source and click New button for OLE...

Here is a winner -

http://www.sqlservercentral.com/Forums/Topic659618-149-1.aspx?Update=1

Question:

Did you attempt to import the text file into say Table3 using the same T-SQL used to import the text into Table1?

If so what where the results of that?

You must use a new ODBC driver for either import or export

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=d:\dasdgigs.xls', 'SELECT * FROM [dasdgigs$]')

Download site for the new driver is:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Jetro.

May I suggest you review this known bug in SSAS (2005) - as the possible source of the problem.

http://support.microsoft.com/kb/938495

I believe that this article which discusses and contains the necessary code to link to previous rows will supply you with the answer. If not ask again

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