Viewing 15 posts - 46 through 60 (of 117 total)
Timothy (4/8/2009)
Given the frequency of mistakes of using = and == maybe Pascal's := and = would be better; but that's water under the bridge now.
Pascal was a doofus I...
April 8, 2009 at 7:03 pm
Charles Kincaid (4/7/2009)
April 7, 2009 at 5:43 pm
dphillips (4/3/2009)
Jeff Moden (4/3/2009)
dphillips (4/3/2009)
April 3, 2009 at 8:01 pm
First, NO TO UNIONS!
As far as the "wish list" goes... have you tried just asking for those items? I'm a developer at heart and was forced into management. ...
March 7, 2009 at 9:24 am
dwither_07 (1/13/2009)
Bradley Deem,...
Paul Hunter
Do you have any source on where I can read on or test on what you're suggesting?
BCP is a standard import/export utility that comes with SQL...
January 13, 2009 at 7:03 pm
majorbloodnock (1/9/2009)
January 9, 2009 at 5:34 pm
I think there are at least two perspectives on the question. The perspective Steve addressed is "does what you wear impact your performance". I believe Steve is correct...
January 8, 2009 at 7:11 am
Jeff Moden
Nope... haven't written one on dates, yet. Wrote one on how to do dynamic crosstabs using dates, but not one just on dates.
Robyn Page wrote a date/time...
December 31, 2008 at 5:48 pm
This is more of a business process that is data intensive rather than a data process. Are you sure you've go the right tool?
Having said that, it's not a...
December 31, 2008 at 5:29 pm
J
In Canada, the Social Insurance Number...
I love the acronym... it's a SIN our (Orwellian) governments peg us with a number that is useful for identification (to them) but forbidden to...
December 31, 2008 at 5:18 pm
More items to consider...
As a substitute for the CASE statement you might also want to look at the Oracle DECODE() function.
Date "math" is a little tricky. I haven't found...
December 31, 2008 at 3:24 pm
It seems strange to me that you're spending time trying to force sequential numbers on an identity column. As you have discovered, your identity column creates a unique sequential...
December 31, 2008 at 11:14 am
Hurray Tony!
If the database is to be nothing more than a data dump then the data dump crowd could (should?) use a simple structure such as the dBase...
November 27, 2008 at 4:49 pm
I hope you're right that it only takes 2-3 years to work out. If you can remember the Savings & Loan bailout was close to 10 years to close...
October 16, 2008 at 10:30 pm
Paula,
I try to avoid loading SSIS whenever it's practice. If all you want to do is extract data from one table/view into a SQL Server table then my suggestion...
September 2, 2008 at 7:40 am
Viewing 15 posts - 46 through 60 (of 117 total)