Viewing 15 posts - 5,881 through 5,895 (of 14,953 total)
Wayne, just because a table has an ordered clustered index, doesn't mean an identity column will honor that order. Usually it will, but you can't guarantee it.
Jeff's solution works...
- 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
November 29, 2010 at 2:39 pm
There's a simpler way to dedupe since SQL 2005.
;with DupeCheck as
(select row_number() over (partition by company_name order by ID) as Row
from dbo.prospects)
delete from DupeCheck
where Row >...
- 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
November 29, 2010 at 2:16 pm
Ninja's_RGR'us (11/24/2010)
GSquared (11/24/2010)
Per-processor is how most multi-user installations are done. CALs are mostly useful to very small shops with a small number of people accessing the system.
Sorry to highjack...
- 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
November 24, 2010 at 7:03 am
You'll need to build the query as a string, then execute it.
Something like this:
declare @Cmd varchar(max);
set @Cmd = 'SELECT
colx.value('' + @Col1Parameter + '[1]'',''int'') AS ' + @Col1ParamName + '
FROM...
- 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
November 24, 2010 at 7:00 am
Per-processor is how most multi-user installations are done. CALs are mostly useful to very small shops with a small number of people accessing the system.
- 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
November 24, 2010 at 6:55 am
I'm not clear on what you're asking about.
- 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
November 24, 2010 at 6:43 am
Gianluca Sartori (11/24/2010)
WayneS (11/23/2010)
Alvin Ramard (11/23/2010)
Craig Farrell (11/23/2010)
Alvin Ramard (11/23/2010)
LutzM (11/23/2010)
Alvin, that's what you look like when you've had time to shave?!? 😀But isn't that counterproductive regarding hunting season?
Depends on...
- 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
November 24, 2010 at 6:42 am
I haven't worked with that version of Access, and haven't worked with any version since about 2007. Maybe someone else will answers on that.
- 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
November 23, 2010 at 4:41 pm
WayneS (11/23/2010)
Craig Farrell (11/23/2010)
GSquared (11/23/2010)
- 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
November 23, 2010 at 2:02 pm
I'd go with Roy's idea. Run each command individually. There are a number of ways to do that, with the command shell probably being the easiest.
Alternately, strangle the...
- 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
November 23, 2010 at 2:00 pm
Merge will do what you need. One command, and it'll update all four columns to match, or insert if the target row doesn't exist.
- 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
November 23, 2010 at 1:48 pm
What source are you using for the values for your variables?
- 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
November 23, 2010 at 1:47 pm
Roy Ernest (11/23/2010)
You all have a wicked sense of humor... 😀
No, I don't. We've already agreed on that. (Of course, the very statement that I avoid humor here...
- 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
November 23, 2010 at 1:36 pm
The better way to design the table would have been:
create table dbo.Permissions (
PerEmployee int not null,
PerType char(1) not null,
constraint PK_Permissions primary key (PerEmployee, PerType),
PerLevel tinyint not null,
constraint CK_PerLevel check (PerLevel...
- 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
November 23, 2010 at 1:34 pm
I generally use a local account for the services, and an SQL account for activity inside the databases. I've had a server lose its connection to the AD server...
- 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
November 23, 2010 at 1:14 pm
Viewing 15 posts - 5,881 through 5,895 (of 14,953 total)