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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 1:19 pm
You'll probably have better luck getting a solution on a support forum for DBPro.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 1:05 pm
You're welcome.
That one catches everyone sooner or later.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 11:35 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 11:21 am
You can right-click the database in SSMS, go to Tasks, Generate Scripts, and walk through that. Will that do what you need?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 11:06 am
You need to query the second table twice.
Like this:
SELECT a.eid,
a.fname,
a.lname,
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 30, 2011 at 7:34 am
Viewing 15 posts - 3,451 through 3,465 (of 14,953 total)