Viewing 15 posts - 6,916 through 6,930 (of 10,144 total)
Ray K (12/9/2010)
WOTD: nothing (as in I don't have a WOTD!)
Null!
December 9, 2010 at 7:46 am
Time to consider the other two options. The quirky update is exactly that - an update with a twist, it uses variables to hold data between rows. There's a comprehensive...
December 9, 2010 at 6:59 am
Craig Farrell (12/8/2010)
...My prolific ability to handle a thousand easy questions does not make me an expert.
Tagline-quality wisdom Craig.
Oh, and I think you're underrating yourself.
December 9, 2010 at 2:32 am
Brett - you're welcome. Thanks for posting up the sample data.
If you can describe some of the other work you need to do with this data set, I'm sure folks...
December 8, 2010 at 7:14 am
Thanks for the data, Brett. Try this:
DROP TABLE #mytable
CREATE TABLE #mytable
(
ACCOUNT_NBR CHAR(19),
...
December 8, 2010 at 6:57 am
Gareth, you need to spend more time working on your homework yourself before posting in the forums, otherwise you will get nowhere. This problem may look confusing but it's really...
December 8, 2010 at 6:42 am
Brett
From the description you have provided, the answer would be
WHERE DATE >= '20100712'
however if it were this easy, then you wouldn't have posted. Can you give a little more...
December 8, 2010 at 6:25 am
Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
foxjazzG (12/7/2010)
get a masters degree in Information systems
Pah. That would waste the best part of four years which could be spent gaining...
December 8, 2010 at 6:00 am
Lynn Pettis (12/8/2010)
Chris Morris-439714 (12/8/2010)
foxjazzG (12/7/2010)
get a masters degree in Information systemsPah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.
Four years?...
December 8, 2010 at 5:34 am
foxjazzG (12/7/2010)
get a masters degree in Information systems
Pah. That would waste the best part of four years which could be spent gaining full-time hands-on experience.
December 8, 2010 at 2:33 am
Grant Fritchey (12/7/2010)
GSquared (12/7/2010)
Steve Jones - SSC Editor (12/7/2010)
Brandie Tarvin (12/7/2010)
December 8, 2010 at 2:29 am
Tom.Thomson (12/7/2010)
GilaMonster (12/7/2010)
Mine.Isn't it rude to ask age? 😉
Not at all, unless within sight (if I can see you and I ask your age that's rude, because I am required...
December 8, 2010 at 2:17 am
CirquedeSQLeil (12/7/2010)
John Rowan (12/3/2010)
CirquedeSQLeil (12/2/2010)
NewbornIs there a congrats in order?
Yes - Baby girl is healthy
Congratulations Jason.
December 7, 2010 at 10:22 am
Ray K (12/7/2010)
GilaMonster (12/7/2010)
Mine.Isn't it rude to ask age? 😉
Oh, I'm aware! But I seem to be in a rude mood this morning! :-D:hehe:
Heh careful Ray you'll end up...
December 7, 2010 at 10:21 am
GilaMonster (12/7/2010)
Mine.Isn't it rude to ask age? 😉
Happy Birthday Gail.
December 7, 2010 at 10:21 am
Viewing 15 posts - 6,916 through 6,930 (of 10,144 total)