I think you need to shift the CAST down to the denominator...this is because it is already doing an integer division and rounding the result - and this rounded result...

Version III - which slightly modifies 5409045121009's script to

- account for the varchar values

- add output for no average cases

- provide alternative methods of checking columns (I can't...

If possible could you post the table structure and some sample data....this should help....

and this might sound dumb but - are you executing only that single query and no other...

hmmmmm...I'm stuck with SQL 7.0 - and anyway I don't think this should be a problem specific to SQL 2K...

Would changing the UPDATE statement to

UPDATE myTable set myField =...

Hi kbe,

Is that the only UPDATE statement that is being run???

Usually the 'Subquery returned....' error occurs when you are trying to do something like :

UPDATE myTable set myField = 'beta'...

Hi,

You could use the REPLACE function to replace the carriage returns with a blank space...

SELECT REPLACE(REPLACE(FieldName,Char(13),''),Char(10),'') from TableName

The Char(10) and Char(13) should take care of the new line and carriage...

Hi,

sp_eventlog in turn calls xp_eventlog...the only info I know about xp_eventlog is that it can be used to read event log information from within T-SQL...parameters to xp_eventlog are "Security","Application" or...

hmmmm....always worked fine for me...just rechecked it and it worked - what I used was

sp_Compare2Tables 'WADemo.wa.TabCompare1','WALive.wa.TabCompare2',1,0

and the stored proc is created in WADemo database...

<Debug mode on>

the script uses PARSENAME to...

Hi Frank,

This script is what I use to compare the data in two different tables...worked out fine for me...

http://www.sqlservercentral.com/scripts/contributions/458.asp

Hi rob

we faced a similar problem when we had a lot of deadlocks in a couple of our input screens(front end was ASP and query timeout values were set to...

Hi kbrady,

I don't think you need to use a cursor here -that is if the requirement is only to find the number of sessions for each month...

I think something like...

Based on the assumption that the data is in the format of hh:mm:ss and you only want to add up the hh values :

Select Convert(Int,Substring(FieldName,1,2))

from Table

gives the hh values...

will the following changes make a difference :

if Trim(me.txtDate) = "" then

strDate = "NULL"

else

strDate = " ' "&me.txtDate&" ' "

end if

and then reference "&strDate&" in the ADO - i.e without...

much apologies...

I can't get the @@ERROR and GOTO to work in a trigger...the construct works fine in a stored procedure but just doesn't click in a trigger...

Hopefully...

Hi,

Sorry - I didn't really check out the situation before replying...I used QA to test if @@ERROR and GOTO would work...just ran a small trigger test and it doesn't seem...