Before doing anything like that, know what you're getting into. Read this: [/url]

Gail explains in detail why this is a bad idea, and the one or two instances when...

I would check out Gail Shaw's articles. She writes extensively on transaction log management, and knows what she's talking about.

Maybe start here: [/url]

I disagree. Maybe check in the front end or the stored procedure used to write the data to the table, but changing a NULL to N/A adds absolutely no...

lonhanner (12/18/2012)

---

I have two tables (TRIP and TRIP_DETAIL both have the same primary key called TRIP. There is no FK relationship. I have data in both tables. I need...

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

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

MSKB is your friend... that and Books Online.

http://technet.microsoft.com/en-us/library/ms188730.aspx

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