Yes, a Matrix is essentially a crosstab (well, except you don't have to do the PIVOT in T-SQL... SSRS does the pivot part for you).

So, yes, you could choose a...

Young Jedi,

Read these:

http://www.sqlservercentral.com/articles/Security/sqlinjection/1269/

http://www.sqlservercentral.com/articles/Editorial/77168/

http://www.sqlservercentral.com/articles/sql+injection/65129/

I would consider dynamic SQL as an absolute last resort. Not a tool to be used by ex-Access programmers (I am...

Just say NO to dynamic SQL!!! That opens doors to all kinds of REALLY bad things! I should probably go find Kevin Kline's "SQL Server Low-Hanging Fruit" presentation...

The line in there that would worry me is this one:

Scalar UDFs are generally accepted as one of the worst things you can do performance-wise in T-SQL. However, they may...

you could add a calculated value to your dataset that did the calculation "row-wise" and then use that calculated value in your SUM / aggregate expression

you could add a calculated value to your dataset that did the calculation "row-wise" and then use that calculated value in your SUM / aggregate expression

FWIW, I started with Brian Larson's book on SSRS 2008. It was okay. He walks you through setup, which helps. Also, his instructions are usually really easy to...

I think you can use it. The best way to find out is to use a "sandbox" database (or something you can mess up and it won't matter), and...

Since the SQL to return the records you want is really simple, I would just join this...

SELECT r.jobnumber

re.code

FROM repheader r

INNER JOIN repairtype re ON re.code = r.code

to your other query....

use a cartesian product. (two tables in the query, no join). One has People, one has Events. No join means the tables get multiplied. Filter as...

You're missing the "Add 14 hours" part...

=DateAdd("h",14,DateAdd("d",-1,Today))

I'll give you that I'm not an SSIS guy, but if the format is always the same, you should be able to create a variable for the filename, then strip...

absolutely reeks of a homework assignment.

If you can group by half hours, then you're golden. Try something like getting the number of half hours since midnight, and then grouping...

No. I was leaving out a bunch of stuff. It was the bare bones of a stored procedure. One of the differences between a view and a...

Are the pick lists for 3 possible values really necessary? Simplify, then you're done.

You could do this...

SELECT bioID

, FirstName

, LastName

, Sex

, Status

FROM Bio INNER JOIN Sex ON Bio.SexID=Sex.SexID

INNER JOIN [Status]

ON...