Viewing 15 posts - 58,381 through 58,395 (of 59,067 total)
Right on, Serqiy...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 26, 2006 at 9:02 pm
I agree but...
I've found that when the "boss", who doesn't really know how to use a spreadsheet, says he wants to open the result set using Excel from a CSV...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 26, 2006 at 8:57 pm
...and, if you do write the TEXT out to a text file for execution, use OSQL instead of ISQL because ISQL is deprecated compared to OSQL.
Just an opinion but both...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 26, 2006 at 8:48 pm
I had a feeling you were one of the smart ones.
Thanks for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 26, 2006 at 8:36 pm
Actually, I believe the smart quotes are CHAR(147) and CHAR(148)... run the following in Query Analyzer and see if you agree...
PRINT CHAR(147)
PRINT CHAR(148)
PRINT CHAR(143)
PRINT CHAR(146)
PRINT ASCII('“')...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 26, 2006 at 12:40 pm
Howdy Jeff,
You may want to consider using a temp table instead of a table variable here... table variables don't use statistics so they're inherently slower... both temp tables and table variables...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2006 at 9:49 pm
Daaaannnngggg.... Guess I'll stick with plain ol' English, SQL, and some pig-latin....
--Jeff Moden
Change is inevitable... Change for the better is not.
February 23, 2006 at 9:24 pm
Vladan,
Thank you very much for taking the time to explain all this because it's very interesting. I do have to ask... are you a linguist or just really well...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 23, 2006 at 6:50 pm
That's ok... I guess I'm pretty happy that American English is my native language
except for the fact that words like "Dude" have about 32...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2006 at 11:02 pm
Cedar72,
Good find... I'm amazed at how comparitively fast this one is compared to the other methods I've seen (recursion is cool)... returns 10000 records in a little over 3 seconds...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 22, 2006 at 6:59 am
Even QUOTENAME comes up with the same problem...
When you want to make a single quote part of the text to be inserted, you have to use two of them side...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2006 at 7:33 pm
Scott...
What editor are you using? Thanks...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2006 at 7:29 pm
Neel,
What is the primary key for the table and... do you have something like a "DateEntered" column or an autonumbering column in the mix? If so, do you want to...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2006 at 7:25 pm
"Instead of" triggers require you to do the actual insert/update. That's not a problem but does require some extra effort.
The "after" trigger you tried to make will work with a...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 21, 2006 at 7:12 pm
Serqiy,
The only problem I see is that there are folks that are over 99 years... just change the VARCHAR(2) to VARCHAR(3) and you're golden because you accounted for everything else...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 20, 2006 at 7:43 pm
Viewing 15 posts - 58,381 through 58,395 (of 59,067 total)