Viewing 15 posts - 7,021 through 7,035 (of 9,715 total)
GilaMonster (11/2/2010)
WayneS (11/2/2010)
Date field stored as varchar(8000) - what kinds of problems do you see coming up from this OP?
8000 characters for a date? I could store an entire calendar...
November 2, 2010 at 11:31 am
Even a convert will fail if someone has put non-date data in your column. You should probably do an ISDate() check on the column to weed out non date values...
November 2, 2010 at 11:28 am
jcrawf02 (11/2/2010)
Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html
Well, if he didn't want to hear the answer, he shouldn't...
November 2, 2010 at 10:08 am
Wayne,
When I removed the double-quotes at the beginning and end of your create table statement, I was able to create the Excel spreadsheet with no problems. However, it gave me...
November 2, 2010 at 9:57 am
Thanks for the link, George. I'll check it out.
November 2, 2010 at 8:43 am
I should have sent Grant some of my eyeballs. Then he'd feel like he was being watched.
Or he would have been too busy eating them to talk. @=)
October 28, 2010 at 12:23 pm
Non-sequitur.
Someone put eyeballs in my candy dish.
October 28, 2010 at 11:35 am
GilaMonster (10/28/2010)
Brandie Tarvin (10/28/2010)
GilaMonster (10/28/2010)
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!AWESOME! Time to start watching some shows! @=)
I...
October 28, 2010 at 11:00 am
Hey, Jeff. If you can fit it in your suitcase, it's portable. May not work in a new system, but it's portable. @=)
October 28, 2010 at 10:18 am
FYI: Aside from Demo-titis, Grant had a pretty good presentation. Wish I could go to PASS and see the full 90 minute one.
Now I'm obsessing about my latest project, trying...
October 28, 2010 at 10:15 am
GilaMonster (10/28/2010)
Woot. Just got a mail fom my ISP. Bandwidth cap permanently increased by 1 GB, no additional charge. Excellent!
AWESOME! Time to start watching some shows! @=)
October 28, 2010 at 10:12 am
Waving to Grant across the interwebs while listening to him present on execution plans!
October 28, 2010 at 9:05 am
CirquedeSQLeil (10/28/2010)
Grant Fritchey (10/27/2010)
Worst problem I have it trying to think up stuff to write about.
I'll see you that problem and raise you a "ran out of time to...
October 28, 2010 at 8:01 am
Sean,
Thanks for pointing out that he's talking about syntax, but when I go back to read his post, he's saying ANSI is more readable than T-SQL.
I don't know why I...
October 28, 2010 at 7:58 am
Viewing 15 posts - 7,021 through 7,035 (of 9,715 total)