Viewing 15 posts - 2,221 through 2,235 (of 2,339 total)
Microsoft's move in this area does not surprise me.
Simply put, they were not making money on this program. They probably are making lots of money on the...
September 5, 2013 at 3:31 pm
I can tackle this. I have a good one in place in all of my databases. The script has been passed around the block many times.
September 4, 2013 at 11:54 am
Gee, this sure sound like using BCP in character based mode would do the trick.
BCP DatabaseName.schema.table OUT FileName.csv /m 100 /b 100 /e TableName.err /c /t\, /r /S ServerName /T...
August 15, 2013 at 10:35 am
This appears to be a significant design flaw.
The first question is would address be considered an entity, or is address really an attribute of Other entities? :Salesman has address"...
August 15, 2013 at 9:45 am
Good job on the article, BUT.
If you think that this is a solution, and are planning on relying on this as some sort of protection from stupid, it's not. There...
August 9, 2013 at 3:57 am
Why is shorter better?????
This is the fight I have had with developers for years. They provide the argument that "ThisIsTheProductionDatabase" is too much typing, so they name it...
August 1, 2013 at 9:56 am
I have used SQL Recon with great success.
July 16, 2013 at 1:08 pm
This may be a bit of a DUHHHHH, but who owns these jobs???
I seem to remember, a long time ago, in a galaxy far away, the same issue when the...
June 20, 2013 at 1:45 pm
webbies (5/17/2013)
I have a database that contains 2 tables (sql server 2008):
LenderCommission
ID int
Commission decimal
CommissionTier
ID int
MinCommission decimal
MaxCommission decimal
I want to create a relationship between the 2 tables. The obvious way would...
May 17, 2013 at 7:07 am
Not sure what you mean here. All of the numbers are decimals.
Are you looking for the values that are a whole number?
1.0, but not 1.1???
This may work
SELECT *...
May 17, 2013 at 6:58 am
That's your answer. Account_id is the primary key. It is already unique. The use of distinct will produce the same number of rows as the query without...
April 26, 2013 at 3:21 am
tushaar.kudalkar (7/27/2009)
HiU need to stop the server services or else u will not be able to move ur .mdf and .ldf files
This is not true. The only time you...
April 22, 2013 at 11:37 am
Lynn Pettis (4/9/2013)
This help?
SELECT
DATEPART(WEEK, DATEADD(MONTH, +3, getdate())),
dateadd(week,datediff(week,0,getdate()),5),
DATEADD(MONTH, +3, dateadd(week,datediff(week,0,getdate()),5));
The calander table is about as elegant as it gets....
April 9, 2013 at 2:28 pm
You could do some ugly manipulation to create the date.
Or, you could create a calendar table and simply query it.
This is one article on nthis site; there are others....
April 9, 2013 at 1:38 pm
I have an idea.
This debate can go on for another 20000 pages of posts, and it will still be confusing, misleading, and certainly not productive.
Remember the pointof this...
March 26, 2013 at 11:41 am
Viewing 15 posts - 2,221 through 2,235 (of 2,339 total)