Fenicon,

looks like you just need a subquery.

SELECT X.Fld1,X.Fld2, X.Fld3, X.Fld4, JEST.Fld5, JEST.Fld5 FROM JEST

JOIN (

SELECT QAVE.Fld1,...

What style are you looking for? Just the date without the time?

There is no way to store just the date inside a datetime column, unfortunately

in 2008 there are a couple...

Jacob,

1XX conversions require a four digit year, X conversions require a two digit year. I.E. 101 is the same format as 1, but 101 expects four...

Best of both worlds you could append a number to dupes, then put the code in place to not allow duplicates to be saved!

Gail, just a fair warning:

If I ever discover the technology and/or power to suck information from another's brain, yours way up there in my list of brains to empty.

Only page 133 for me.. 😀

jcrawf02 (6/18/2009)

---

Tom Brown (6/18/2009)

---

I had a short stint working for the marketing manager of a hospitality retailer. He often got free samples of the various offerings of breweries, wine...

As far as I know, he has no idea what your e-mail address is. When you e-mail someone all you see is their User Name, and it is then sent...

No love for the ISNULL it seems- can you guys explain the negatives of doing it that way? Thanks 😀

I know there is the small performance hit, is this something...

Always an ISNULL for me, interested to hear other's opinions

SELECT * FROM XXX WHERE

BeginDate @Date

Off the bat- First post 😀

Also- This might be a little bit sloppy (but everything else in this thread is a bit sloppy thus far :-))

declare @Inttime int

set @Inttime =...