Viewing 15 posts - 2,626 through 2,640 (of 3,221 total)
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...
February 23, 2009 at 9:29 am
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:
February 22, 2009 at 7:39 am
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...
February 21, 2009 at 12:44 pm
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...
February 21, 2009 at 9:06 am
mail2payan
CONGRATULATIONS.
You worked it out. Good luck on the remainder of your project.
February 21, 2009 at 7:30 am
Mail2payan
I ran your modification of Steve Jones' T-SQL and reieved the following results:
Student course credit Grades Grade Points...
February 20, 2009 at 8:40 pm
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...
February 20, 2009 at 2:50 pm
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...
February 20, 2009 at 11:36 am
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...
February 20, 2009 at 10:00 am
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...
February 19, 2009 at 7:17 am
Here is a winner -
http://www.sqlservercentral.com/Forums/Topic659618-149-1.aspx?Update=1
February 18, 2009 at 10:35 am
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?
February 18, 2009 at 10:33 am
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:
February 17, 2009 at 11:25 am
Jetro.
May I suggest you review this known bug in SSAS (2005) - as the possible source of the problem.
February 16, 2009 at 2:14 pm
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
February 15, 2009 at 1:06 pm
Viewing 15 posts - 2,626 through 2,640 (of 3,221 total)