Viewing 15 posts - 43,831 through 43,845 (of 59,063 total)
Gianluca Sartori (5/7/2009)
... ooops!I vote for Lynn's solution! There's also an interesting thread on this topic
http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx
Uh huh... just be careful with what you see in some of the posts...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 7, 2009 at 11:05 am
jamiejulius (5/7/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 7, 2009 at 11:00 am
GSquared (5/7/2009)
select substring(@String + ',', Number, charindex(',', @String + ',', Number) - Number)
from dbo.Numbers
where Number <=...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 7, 2009 at 10:58 am
JohnG (5/7/2009)
Jeffrey Williams (5/7/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 7, 2009 at 10:41 am
Jeff Moden (5/6/2009)
ifila (5/6/2009)
I still get nulls in the Account Table 🙁Thanks
Are all of the files you're trying to import in the exact same format and field order?
I can help,...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 7, 2009 at 10:34 am
tlehner (5/7/2009)
Steve Jones - Editor (5/7/2009)
However, I...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 7, 2009 at 10:16 am
Steve Jones - Editor (5/7/2009)
For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:
BWAA-HAA!!! I was...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 7, 2009 at 10:14 am
But in this particular SQL statement, there's no reason to alias your tables names - it would just save a few keystrokes, at the cost of making it much less...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 6, 2009 at 10:40 pm
aloj (5/6/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 6, 2009 at 10:01 pm
lcardwell (5/6/2009)
I spend a good deal of time 'splaining why certain processes/practices are important and getting folks to think 'out of the box'...
Heh... my most difficult task has been to...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 6, 2009 at 9:22 pm
Manie Verster (5/6/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
May 6, 2009 at 7:28 pm
ifila (5/6/2009)
I still get nulls in the Account Table 🙁Thanks
Are all of the files you're trying to import in the exact same format and field order?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 6, 2009 at 5:32 pm
JohnG (5/4/2009)
To satisfy Jeff's curiosity...
Thanks, John.
About a year ago, I figure out how to make a strip function that manufactured the Tally table on the fly much as...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 9:43 pm
peter (5/4/2009)
Here is an update to my tally function, it has now slightly less overhead by eliminating two cross joins.
As you keenly observed before, all of these are now in...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 9:32 pm
Sorry... my bad... looking for a ROWCOUNT > 1,000,000 won't count the internal rows generated as is so typical of a cross join. Perhaps just setting the duration to...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 5, 2009 at 7:04 pm
Viewing 15 posts - 43,831 through 43,845 (of 59,063 total)