convert(decimal(7,3),(([Col1] + [Col2] + [Col3] + IsNull([Col4],convert(decimal(7,3),([Col3] + [Col5])/2))) / 4))

Can anybody now spot why MeanValue returns no more than two decimal places when it should return three?  Col1 -...

We've had good luck with taking a full backup of the database, then restore it with a different name on the same server or, if desired, with the same name...

Soumna,

The previous posts offer good solutions, but I read your question a little differently.  You have the column named ALLOCATED and a process or condition called ASSIGNED. 

From your question...

I'm afraid I can't offer a solution but I do have another workaround.

When I get the message, I select Default Database Diagram view, a dialog tells me there is no...

Danny,

If an accounting app is using this table you need to be VERY sure that these fields are not used. 

I know some accounting apps are abysmally designed from a...

I downloaded this from 4GuysFromRolla a couple of years ago.  They deserve the credit and I would recommend their website to anyone.

----------------------------

--From 4GuysFrom Rolla

--Demonstrate how to export a file from...

Steve,

I checked out the article Does this mean that I have to enter after VALUES each name? There is 18k of them

The lines with VALUES in that post simply populated a...

OK, this aint pretty but it should work.  You will need to adjust the code for your table names and if you don't want to create a table from the...

Is the data consistent other than the period after the title? 

Is there a comma between lastname and firstname?  If so, in EVERY record?

Any records with more than three strings...

sp_dboption is still around for backward compatibility.  Microsoft now recommends using ALTER DATABASE.

You should read BOL about the options and the effect of this operation on your database, especially what...

Mark,

Thanks for the DDL.  This reply may ramble a bit but I hope it is helpful.

First a clarification question.  Is your intent to create a new class record every time...

Mark,

Would you post the DDL of the tables?  It would help to see the actual definitions.

The easist way to get the DDL is to right-click the table name in Enterprise Manger,...

I just reread your previous post and I think I see your problem.

Your solution works fine, however when I try insert in other columns from the class table, I get an...

EXEC [insert class]

@classNo = 2,

@capacity = 20,

@classID = 1

finally when I execute I get an error msg stating that a column branchID does not accept nulls, this is because i...

Do you need to divide EACH column's value by 2?  If so you need

SELECT col1/2, col2/2   rather than (col1+col2)/2

Once you are are sure you are getting the correct data, you...