this script:

SET NOCOUNT ON

DECLARE @crdate DATETIME,

@days varchar(3),

@hr VARCHAR(50),

...

SET NOCOUNT ON

DECLARE @crdate DATETIME,

@days INT ,

@hr INT ,

...

got some cast errors with David's script.

try--

SET NOCOUNT ON

DECLARE @crdate DATETIME,

@days INT ,

@hr INT...

it would be great if you wrote a little article like this one on the topics of EXCEPT and INTERSECT. i was aware of those, but have yet to...

so, would this be the proper expression if it were really an exponential question?

DECLARE @a BIGINT

, @b-2 BIGINT

SET@a = 16

SELECTSQRT(POWER(@a,@a - 17))

bc

i've taken up riding the bus, which costs me a $1/day versus driving 20+ extra miles costing $4/gas/day. its only when its economically convenient, will the consumer really change...

re: Derek's question about America's ordering of the date

http://en.wikipedia.org/wiki/Calendar_date

"In British English, full dates are usually written and spoken as 7th December 2007 (or 7 December 2007) and pronounced...

it doesn't wait until noon to start rounding up...

DECLARE @TheDate DATETIME

SET@TheDate = '2008-02-05 11:59:59.993'

SELECT@TheDate

SELECTCAST(@TheDate AS INT)

SELECTCAST(CAST(@TheDate AS INT) AS DATETIME)

SET@TheDate = '2008-02-05 11:59:59.997'

SELECT@TheDate

SELECTCAST(@TheDate AS INT)

SELECTCAST(CAST(@TheDate AS...

this discussion was remarkable to read. i thought this article was interesting that i found by following some of the links cimode referenced...a lot of similarities to the "exchange"...

in response to "Mr. or Mrs. 500"--

it wasn't just you, i couldn't see the bad code example either. seems to happen quite frequently in these articles with code snippets...

burke

BBA in Finance. after 12 years in the investment/brokerage business was laid off and backed into the IT world.

i like getting the daily email with 3-6 articles of interest and the editorial. i almost always read at least one and learning something new about querying, reporting, integrating,...