I was thrown off by the ";" with the first 'CASE' for the Commission Flag (I had not used CASE before). I have worked with Crystal Reports for years,...

I was having a similar issue, when I tried to 'Start without debugging' (going through the tutorial), it was giving an error that it could not find the http site....

I was installing SP3 for SQL Server 2005, when it got to a particular point in the install, then I got the blue screen of death. Running SQL Server...

I got the blue screen of death on a local machine running Win XP SP2, I had skipped SP2. I was able to install SP2 and it appears...

Supposedly you can use Crystal Reports to report on a cube, but I have yet to be able to get Crystal Reports to connect to my SQL Server 2005 DB.

I attempted to do a database copy and it failed. It said there was not enough disk space. That is odd considering I know that the table file...

Then that would involve a FTP transfer to the other server and I think our network has blocked ftp transfers, I have discovered a database copy in SQL 2005....

From what I can tell the best answer is the first one. I created the tables and populated them with the same data. Ran the queries and the...

Just because I a bit of a newbie with SQL in general. I created the table and poplulated. Verified I had the right value and in SQL Server...