I'd say that if your goal is to work in BI then do the BI cert. I also think, and this is just my opinion, that BI is the...

Steve Jones - Editor (10/5/2009)

---

I miss anything? Just cranky old guys and gals complaining?

The post is a little self promotion, but I'm more willing to tolerate authors promoting themselves than...

I don't have a problem with it. The OP isn't directly trying to sell the book,...

I'd do it like this:

Create Table #results(...)

Insert into #results

Select ... from local table

Insert into #results

Select ... from linked table

....

Select * from #results

No, you want SQL Server to be able to determine what types of locks to take. SQL Server does a pretty good job of determining the best way to...

I don't know if this is a problem or not. It sounds like it would be a problem to me.

Are the system DB's in the same location?...

Dropping an index will not affect foreign key constraints other than a table scan will be used to access the data if the index is not present.

To clarify what J-F said. You would use a JOIN when you want to return data from #t2 and you might use WHERE EXISTS when you only want to...

Modify the script to dump the results of each query to a temp table and then finish with a select from the temp table.

I have SP3 installed (XP) and do not have separate copies of the system databases for SSRS. Do you see multiple entries in sys.databases?

I'm not really sure what you are trying to accomplish, but yes it is possible to use SUM in a CASE statement, but of course all the normal aggregation rules...

You would want Derived Column Transformation. With this you can either add a new column to your Data Flow or Replace the data in the Date Column. In...

You have to have locking in order to insure consistency. Locking is part of what makes an RDBMS. Typically you would leave the defaults because ROW and PAGE...

Because you are putting the Text "Grand Total: " in the same textbox as the number the formatting will not apply because it is no longer numeric data the textbox....

I'm fairly confident that the format you have, if imported as string not integer, will directly convert to a SQL Server DateTime data type.

CREATE TABLE #date (theDate DATETIME)

INSERT INTO #date...