Viewing 15 posts - 526 through 540 (of 702 total)
Alvin Ramard (5/6/2009)
Lynn Pettis (5/6/2009)
I saw the OP's reply before I saw your warning. Obviously the force was not with us at the time.Now Gail is in there too.
...
May 6, 2009 at 5:21 pm
Alvin Ramard (5/6/2009)
john.arnott (5/6/2009)
4K
Lynn, let me know if you understand the OP's last reply in the thread about the rolling 12 months. I don't think he knows what you...
May 6, 2009 at 5:14 pm
Bruce W Cassidy (5/6/2009)
[font="Verdana"]Check out this chunk of code, posted by Adam Machanic on Phil Factor's blog:SELECT
UPPER(RIGHT(LEFT(@@VERSION,2),1))+SUBSTRING(MiR,1,15%6)+RIGHT(LEFT
(CONVERT(VARCHAR,[c6[[447]),4),1)+CHAR(CAST(STUFF(ZuB,2,0,REPLICATE('0',
1))AS INT))+(SELECT(SUBSTRING(name,3,1))FROM[master]..[sysdatabases]
etc.
etc.[/font]
Am reminded of a story a senior programmer told...
May 6, 2009 at 3:02 pm
As Lowell suggests, if the column names are the same in your two tables, you can use the syscolumns information to find the offending column. Recognize that although it's DATA...
May 5, 2009 at 5:09 pm
What sort of values are in that column now? Can you please post some sample values as they show up in date format and the desired integer value for each?
May 5, 2009 at 2:28 pm
Hi. The addition of enclosing double-quotes is not the normal behavior. You say it's a simple csv file, but there's certainly something different about it. For one thing, your code...
May 4, 2009 at 6:38 pm
David Webb (5/4/2009)
I got $10 that says he deleted the table and believes he can recreate it from the views.
:hehe:ROFL:hehe:
But I ain't taking that bet either...
May 4, 2009 at 3:35 pm
Zevon was a marvelous songwriter. I expected you, Gail, to maybe be familiar with "Roland the Headless Thompson Gunner" as it tells a story set on your continent, one...
May 4, 2009 at 1:46 pm
Lesson learned by newbie "helper"....
So I guess I've learned a lesson tonight. Just got home and saw an email notice of Jeff posting a reply to a thread I'd...
May 2, 2009 at 12:29 am
Jeff,
Sorry for any confusion; I'm not the original poster. He posted in the SQL 2000 forum with just a snippet of code -- no table def's, nothing to go...
May 2, 2009 at 12:18 am
Lynn Pettis (5/1/2009)
Florian Reischl (5/1/2009)
Lynn Pettis (5/1/2009)
WayneS (5/1/2009)
Steve Jones - Editor (5/1/2009)
Hey, that's a cool feature! Hadn't seen that before.
I guess it's a good thing that I didn't ask you...
May 1, 2009 at 12:48 pm
Flo,
You're probably right. I guess I'm just new enough at trying to help that I give folks the benefit of the doubt. Two-hundred line post (twice), didn't make...
April 30, 2009 at 6:26 pm
Paul White (4/30/2009)
Florian Reischl (4/30/2009)
New non off topic for this thread...
:laugh:
Saw that yesterday and figured Steve had sorted it. He's a braver man than I.
Seems I underestimated the OP.
Ho...
April 30, 2009 at 4:32 pm
Viewing 15 posts - 526 through 540 (of 702 total)