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...

did you ever attach the database? does it show up under the Databases folder in SSMS?

What did you try? Did you try to attach it, restore it?

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...

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...

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...

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....

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...

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...

I said that to maintain the insert order of the records, he needed an Identity column. Looked like he didn't believe me.

Hector,

very true.

Horse, water.

Water, horse.

Jeff,

I thought I said that... maybe he didn't believe me. :hehe:

(Believe me now?)

Is this a homework assignment?

WHERE SomeColumn IS NULL

OR SomeColumn IN (1,2);

is how I would do it, but then I never tried putting NULL in a list as if it...

If you cannot add an IDENTITY (increment) to the destination table, then I do not think it can be done. Data in a table is inherently UNordered, unless you...

Create the table and add the identity column before inserting any records. If you have to create a linked server and create and run an insert to your new...