Simon,

Carl is sending you to the correct place to go, though it sounds like you do not understand a pivot-table.

You need to "pivot" your data on hours for each one...

IMO, a percentage is a calculation, no more. If you want to see the percentage of time you spent on, let's say a specific client over the course of a...

If this is a onetime (or two time, test and then production) data transfer, you could probably get a way with the Import Data wizard in SSMS. If you will...

Not to offer a vender a free plug (since there are many choices), but we have just implemented HiT software's DB Moto, to replicate data from DB2 to SQL Server....

Ah! Sorry, I misunderstood what you were asking. That is beyond my current knowledge, though.

I use the Provider String to set the default collection. Literally "Default Collection=DB2Collection" where DB2Collection is the name of the "library" or environment (I am not familiar enough with DB2...

You could add a filter to your data set in the chart, or to the data set being pulled for the entire report...

Guys, feel free to correct me, but I believe that the answer to this Exam Question is "NO!". You can do RBAR to solve several problems within SQL Server. But...

If you need to do this on a regular basis, and you have Standard or Enterprise edition (I don't remember if the workgroup edition of SQL Server has SQL Server...

Just a heads up, I have recently made this same move, using the IBMDASQL (though I have also tried IBMDA400) and I ran into a fun problem. When your SQL...

If I am hearing you right, all you did was "attach" to the wrong database files; you should look to see if your original mdf and ldf files are still...

Steps:

1) Learn Business Intelligence, what it is, what it can do. ( I recommend focusing on Data Warehouses and Data Mining)

2) Identify BI Goals. What, specifically, do you want to...

Here is a different take on a solution (using the table defined above).

Here I build the vertical table to represent the values, including a depth. Then I create a manual...

Sorry guys, I have to disagree... or maybe I am just the exception. I am what I refer to as "musically declined" the harder I try to learn an instrument,...

One possible option is to create a table on a central database that contains the name of all of the other databases, as well as an encrypted old sa and...