Viewing 15 posts - 58,351 through 58,365 (of 59,066 total)
Here's a self standing sample that you may run with impunity...
This turned out to be a bit long winded because an ORDER BY in an UPDATE in the presence of...
March 13, 2006 at 2:13 am
FROM #YourTable y,
dbo.Tally t
Ok... now I'm confused
That is a Tally table in your code, isn't it?
Althought the Jury is still out...
March 10, 2006 at 9:06 pm
Thanks for the great feedback, Kenneth. Yep... I know the double barreled last names need some help but James insists that they will all be hyphenated... I sure hope he's...
March 9, 2006 at 8:05 pm
Now there's an idea... thanks for pitching in...
hadn't thought about that approach.
March 7, 2006 at 4:38 pm
If the first column is unquoted data, then the first column BCP would actually import a column (instead of "0" as the target column #) and you would, of course,...
March 7, 2006 at 4:09 pm
Haven't tried it in Enterprise Manager... works fine in Query Analyzer...
March 7, 2006 at 5:09 am
Yep, I agree with Kory...
Also, I believe that moving the reference to constants out of the ON clauses and into a WHERE clause will help a bit...
The other thing may...
March 6, 2006 at 6:38 pm
Hilight the character, copy it, and paste it into the 'X' below in QUERY ANALYZER... it'll tell you what the character number is...
SELECT ASCII('X')
March 6, 2006 at 6:28 pm
He did say that is was for fun
and it does work for what James posted as a very limited original format
March 6, 2006 at 5:25 pm
Yep, I agree...
if you need to fumble with fill factors for all tables, then you are correct... hopefully, though, you let the default fill...
March 6, 2006 at 4:45 pm
No. It wouldn't work for upgrades because the whole database is changed... and that brings up another point... if your "harmless, transparent upgrade" fails for some reason, where does that...
March 6, 2006 at 4:27 pm
I knew it! I've always hated composite name columns... I'm trying to get them to change it but we have a 3rd party app at work where they allow up...
March 6, 2006 at 6:17 am
What do I lookup to figure out how to change how the formatting is done? All I could find was the following and it wasn't very helpful...
You...
March 5, 2006 at 9:19 pm
Viewing 15 posts - 58,351 through 58,365 (of 59,066 total)