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...

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 >...

Ninja's_RGR'us (11/24/2010)

---

Sorry to highjack...

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...

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.

I'm not clear on what you're asking about.

Gianluca Sartori (11/24/2010)

---

WayneS (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

Craig Farrell (11/23/2010)

---

Alvin Ramard (11/23/2010)

---

Depends on...

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.

WayneS (11/23/2010)

---

Craig Farrell (11/23/2010)

---

GSquared (11/23/2010)

---

If you want, I'll put the whole thing into article form and give it to Steve. Probably should have done that a year ago, when...

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...

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.

What source are you using for the values for your variables?

No, I don't. We've already agreed on that. (Of course, the very statement that I avoid humor here...

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...

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...