select

convert(char(10),cast(@IntVal - 36161 as...

look up datepart in Books OnLine ... and use that in your where clause, something like the following :-

select convert(datetime, integer_column)

from table

where datepart(yyyy, (datetime, integer_column)) = 1995

hi, are the dates stored in the integer field, ie. which is month day and year ? i.e is christmas day 1995 19961225 or something else ?

Paul

Ed,

there is a way in DOS to count the number of lines in a file (something like find /c /c 'gfgshdf' < yourfile.txt )

you could perhaps set up a schedule...

DBCC errorlog starts a new log, and then saves the old one as errorlog.1. When it reaches the maximum (i.e. errorlog.99) it will remove the oldest. give it a try on...

hi, in 2005 you can configure between 6 and 99 errorlogs. You can also use DBCC ERRORLOG to force the start of a new log. we have a job that...

Hi,

from BOL :-

"When GROUP BY is specified, either each column in any nonaggregate expression in the select list should be included in the GROUP BY list,...

this sounds very strange. Have you tried creating another table with the same column types but without all the associated FK's and test an update on that ?

i wonder why the command is "conditional" in activity monitor, doesn't that usually indicate an if statement or a loop ? 

use

select

object_name(53575229)

in the database that the BOOKING table resides.

Any triggers on the BOOKING table ? is 53575229 the BOOKING table ?

Hi,

dbcc

shrinkdatabase ({your_db}, truncateonly) always works for me.

Paul

Hi,

   in 2005 you need to grant ALTER TRACE permissions:-

grant

alter trace to {your user here}

HTH

Paul

Jeff,

   I ran the code on SQL Server 2005 and it generated 1000000 numbers in 9 seconds. Quite impressive.

(the server in question is using 4 CPUS and 2GB memory.)

Paul

hi,

  That isn't the title table. Antares is correct, if the select returned rows they should be updated (unless a trigger disallows it for some reasons). Can you post the...