Viewing 15 posts - 3,451 through 3,465 (of 14,953 total)
The forums are at: http://social.msdn.microsoft.com/Forums/en-US/categories
The general support page is: http://support.microsoft.com/
That's where I'd start with any MS developer tool.
August 30, 2011 at 1:19 pm
You'll probably have better luck getting a solution on a support forum for DBPro.
August 30, 2011 at 1:05 pm
You're welcome.
That one catches everyone sooner or later.
August 30, 2011 at 1:04 pm
SQLRNNR (8/30/2011)
GSquared (8/30/2011)
WayneS (8/30/2011)
Gianluca Sartori (8/30/2011)
jcrawf02 (8/30/2011)
Gianluca Sartori (8/30/2011)
On the plagiarism, I don't see it. After all, musical notes are just seven. 😉You must not sing the blues...
I prefer hard-rock....
August 30, 2011 at 12:34 pm
It's doing integer division, which rounds. Convert one/both numbers to decimal or float datatypes, in the query, and you should get what you need.
Try this to see the difference:
SELECT...
August 30, 2011 at 12:27 pm
Michael Valentine Jones (8/30/2011)
Peter Maloof (8/28/2011)
SwayneBell (8/24/2011)
Some years back, I was a regular contributor in Oracle forums and I can assure you that the "snarky-ness level" is much higher there.
Absolutely....
August 30, 2011 at 11:35 am
You can right-click the database in SSMS, go to Tasks, Generate Scripts, and walk through that. Will that do what you need?
August 30, 2011 at 11:20 am
The reason there isn't a book or whatever on that is there isn't really a formula or rule on the subject.
The first thing to do is see if you can...
August 30, 2011 at 11:19 am
Krasavita (8/30/2011)
Sorry,LEFT(LTRIM(RTRIM(SUBSTRING(prefix,7,4) + phone)),20)
If I get prefix null,this formula won't work,how can I work around it?
Thank you
Put IsNull or Coalesce around the prefix.
LEFT(LTRIM(RTRIM(SUBSTRING(isnull(prefix, ''),7,4) + phone)),20)
That will replace...
August 30, 2011 at 11:10 am
GilaMonster (8/30/2011)
jasona.work (8/30/2011)
GilaMonster (8/23/2011)
Neither has just about any software product I've bought in the last few years (other than games)Games still come with manuals?? Since when? 😉
Just about every...
August 30, 2011 at 11:08 am
WayneS (8/30/2011)
Gianluca Sartori (8/30/2011)
jcrawf02 (8/30/2011)
Gianluca Sartori (8/30/2011)
On the plagiarism, I don't see it. After all, musical notes are just seven. 😉You must not sing the blues...
I prefer hard-rock. 😛
Oh, well...
August 30, 2011 at 11:06 am
You need to query the second table twice.
Like this:
SELECT a.eid,
a.fname,
a.lname,
...
August 30, 2011 at 11:04 am
You could have a function query the most recent value, compare the year part of it to DatePart(Year, Getdate()), and if it's the same year, add 1 to the number....
August 30, 2011 at 7:49 am
If you update a column and that makes it violate the unique constraint (or unique index), that's the same as inserting a duplicate row. You have to either change...
August 30, 2011 at 7:34 am
Viewing 15 posts - 3,451 through 3,465 (of 14,953 total)