[font="Verdana"]If you are using SQL Server 2000, you will need to convert the CTEs (common table expressions -- the parts in the "with" statement) to derived tables.

select Student,

...

[font="Verdana"]My suggestion would be to use a permanent working table, rather than a temporary table you create on the fly. From a design perspective, the working table will form...

[font="Verdana"]As a suggestion, have you tried loading up the data into Excel, and using the Cross Tab in Excel? That may be an easier way of achieving what you...

[font="Verdana"]Ah, that makes it harder.

Maybe showing them the appropriate section in Code Complete, with the data to back up the studies, will help. Otherwise, my suggestion would be thus:

Build...

[font="Verdana"]Just a little word of warning here: when you add those values, if any one of them is null, adding them together will give you a null as a result.

You...

[font="Verdana"]I've done this sort of thing quite often.

Here's my suggestion on how to approach it.

Define a table that lists your "variables", and calculate the current value of the variables. ...

Grant Fritchey (2/20/2009)

---

I do feel for you. I've been there. Trying to convince a programmer who knows everything there is to know that, maybe, just maybe, he's not quite up...

[font="Verdana"]

I suggest you move your grade calculations into a table, rather than in code (that's what databases are for!)

Then you can have a calculation similar to the following:

if object_id('dbo.StudentGrade') is...

[font="Verdana"]Some good answers already. Check out the INFORMATION_SCHEMA views.[/font]

[font="Verdana"]Does the SQL Server error message tell you what the value is that it's failing to insert?

This looks like a fault with your data feed. You are trying to...

Steve Jones - Editor (2/20/2009)

---

I'm sure he knows how to cut and paste, but might not use that term. What if he's primarily a *nix guy? Might not be used...

[font="Verdana"]Have you tried talking to your database hosting service people to see if they can help out? They may be able to deliver you a backup file on a...

[font="Verdana"]Isn't he already trying to open the valve?[/font]

[font="Verdana"]Do we need to worry about security and intermittent failures?

Hmmm. Probably not. Yep, concur!

[/font]

David Webb (2/19/2009)

---

Dear SQL Experts,

I am having problem with machinery controlled by SQL database. Rest of staff ran from room and supervisor shouted "You're in charge" as he shut...