Viewing 15 posts - 3,376 through 3,390 (of 3,475 total)
I probably shouldn't muddy the waters, but there are two basic options:
1. a "push" from Access where you create a linked table (to the SQL Server destination) and...
December 17, 2012 at 10:58 pm
Without an error message, I'm afraid I can't help you. :w00t: Can't diagnose what I can't see! Do it again and see if you can get an...
December 3, 2012 at 12:36 pm
MSKB is your friend... that and Books Online.
December 2, 2012 at 10:56 pm
Did you unzip the database file(s)? There should be two - one is an MDF file (database file) and the other is the LDF.
Open SSMS.
Right-click on Databases
choose Attach Database...
You...
December 2, 2012 at 6:45 pm
did you ever attach the database? does it show up under the Databases folder in SSMS?
December 2, 2012 at 2:27 pm
What did you try? Did you try to attach it, restore it?
December 2, 2012 at 1:00 pm
If your goal is to create a crosstab result, then by far the easiest way to do it is with a matrix report in Reporting Services. Did you need...
October 31, 2012 at 12:04 pm
Just wondering, but why do you need to do the crosstab inside SQL Server? If you create a Matrix report, you can do a crosstab there and it's stupid...
June 5, 2012 at 11:56 am
I have the BI book by Brian Knight - super easy to follow. It's essentially a series of exercises in increasing complexity. Comes with a CD with...
May 21, 2012 at 5:02 pm
You could try starting at Pragmatic Works (www.PragmaticWorks.com) and watching their videos. Brian Knight is an expert at Analysis Services, and his books etc are very easy to follow....
May 21, 2012 at 12:02 pm
want to select Records from table A and add it or update if exist in table b
Table A
StudentID,StudentName,Age,TotalGrades
Table B
StudentHistoryID,StudentID,StudentName,Age, TotalGrades
select all records from Table A under any condition and insert...
May 13, 2012 at 2:12 pm
Don't take this wrong, but that's not nearly enough information for anyone to come to any conclusion about what might be going on with your database. What does your...
April 8, 2012 at 6:01 pm
I said that to maintain the insert order of the records, he needed an Identity column. Looked like he didn't believe me.
March 30, 2012 at 8:38 pm
Hector,
very true.
Horse, water.
Water, horse.
March 30, 2012 at 6:25 pm
Jeff,
I thought I said that... maybe he didn't believe me. :hehe:
(Believe me now?)
March 30, 2012 at 5:31 pm
Viewing 15 posts - 3,376 through 3,390 (of 3,475 total)