Viewing 15 posts - 19,216 through 19,230 (of 59,072 total)
Welsh Corgi (11/9/2015)
I have been asked to Partition the tables.
Would I be better off to hold off on the archiving and just...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2015 at 4:42 pm
Now we're talking. Thanks for posting some feedback, folks!
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2015 at 4:39 pm
Rich Mechaber (11/9/2015)
Jeff Moden (11/6/2015)
sknox (11/6/2015)
Luis Cazares (11/6/2015)
Rich Mechaber (11/6/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2015 at 7:30 am
I hate it when people give an article 1 star without saying why. It gives no one the chance to improve or avoid. Incredibly, I've never had to...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 9, 2015 at 5:30 am
Grant Fritchey (11/8/2015)
Agreed. Can't let the perfect become the enemy of the good. That said, when you're introducing technical debt, know that.
Heh... I was going to say "Good enough usually...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2015 at 7:56 pm
SoHelpMeCodd (11/7/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2015 at 7:48 pm
This is one of those places where a Calendar Table really shines. Here's a proc to build one (including standard USA holidays that my company observes). NOTICE that...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 8, 2015 at 7:30 pm
I'm thinking that there are two possibilities here.
1. If you have sysadmin privs, xp_CmdShell doesn't run as you. It runs as the service login for SQL Server and,...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2015 at 11:56 am
ArcticEd32 (11/3/2015)
I'm trying to generate a sequential list of months starting with...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 7, 2015 at 11:50 am
srinivassrivas (11/6/2015)
Its not working pdf file is not generatingplease help.
Where did you look for the file?
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2015 at 5:58 pm
xxxy2k (11/6/2015)
Need help to shred pipe delimmited data into a table, cant seem to find anything that will help me do this.
for example the data looks roughly like this
234|2015-6-11|234aa|
ID1|a|A||234|ASDFASDF|2015-06-11|A|s||NULL|||||TEST|TEST|TEST|TEST|1543211
ID2|B|A||234|ASDFASDF|2015-06-11|A|s||NULL|||||TEST|TEST|TEST|TEST|1234
I have...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2015 at 5:49 pm
Luis Cazares (11/6/2015)
priterande (11/5/2015)
select COALESCE(MIN(Act) / NULLIF(MAX(Act),0), 0) as minvsmaxAct from table_nameThis is what I usually do, except that I don't reply to 5 year old threads. :w00t:
I usually don't...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2015 at 5:37 pm
nigel. (2/26/2010)
Guys you're posting answers to a question asked in 2004. I hope they've fixed the problem by now. :w00t:
It's now more than a decade and if they're anything like...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2015 at 5:36 pm
Derrick Leggett (6/22/2004)
Don't divide by zero. <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'> You need to figure out where you are doing this and fix it.
BWAAA-HAAA!!!! Even if...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2015 at 5:33 pm
pietlinden (11/6/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 6, 2015 at 5:30 pm
Viewing 15 posts - 19,216 through 19,230 (of 59,072 total)