Long time past I know ... still great question and even greater explanation.

One small thing though that I'm tring to get my head around ... in the explanation , is...

Thank Chris

In my case it worked -

I had already had a clause to ensure a certain format etc. before casting/converting but the query just kept throwing the error

even...

Hi there

I had this frustrationg error on a query as well, all though the dataset I was using for a join didnt even contain anything other than numbers.

I got it...

Hi Dwain

The Excel results are inline with the query I posted - same order, same amount of results - ( I did come across one mistake though - 4th...

Hi again

I had the chance to verify the results, and while the count up is correct - the avg isnt. I have taken the ships, that lay in berth more...

Hi Dwain

First of all - sorry for the late response - I was off work for a long weekend and my RDP was playing up, so I couldn't get on...

The Article is interesting, but to be honest I am against Generic Lookup Tables ... I don't think it is good database design at all.

Here is an article that describes...

Excellent just the kind of thing I need ....

Now if someone could give me a tip on using a parameterized stored Procedure instead of a view of a table ......

In BOL lookup "output parameters" in the Index. It is explained very clearly there, how to use Return Codes, input and output parameters.

One thing it also states there is:

"When...

funnily enough (or sadly enough should I say) I also found this:

http://spaces.msn.com/members/arunraj/

Take a look at the article/blog on the 28th April ... does it seem familar? It is the...

Our professors always told us, it is expected in our branch, that we make a shift every 3-4 years. If you stay in one place for too long, you start...

I also had a similar problem at work.

I found out, the Procs were being run with totally unnormal (extreme) parameters at first to test the proc. When finally the proc was...

Thanks for those links ... it sure has cleared up my question ...

nano

The actual query is the following:

SELECT     Proteins.ProteinID,

               Proteins.FastaID,

               PROTAB2.SumMaxScore AS MainScore,

               Proteins.Description

FROM        (

                 SELECT     PROTAB.ProteinID,

                               SUM(PROTAB.MaxScore) AS SumMaxScore,

                               PROTAB.NumOfPeptides

                 FROM      (

                                SELECT     PeptidesProteins.ProteinID,

                                              MAX(JobModuleScores.ScoreValue) AS...

I am just declaring the following local:

CREATE PROCEDURE mag_selectMaxProteinResultsTest

@jobID int,

@processingModuleNr int,

@scoreName varchar(50),

@scoreValue float,

@peptidenumber int

AS

DECLARE @jobID2  int

DECLARE @processingModuleNr2 int

DECLARE @scoreName2 varchar(50)

DECLARE @scoreValue2 float

SET @jobID2 = @jobID

SET @processingModuleNr2 = @processingModuleNr

SET @scoreName2 = @scoreName

SET...