And, if the field you have to adjust is part of a primary key or unique index you actually have to accomplish the update first, then insert the new record.

😎

Are you trying to do this in VBA in Access or SQL in Access?

Using SQL, there is a function called CEILING.

😎

CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED

(

[DateSince2000] ASC,

[shape] ASC,

...

Unfortunately, our "wise and omnipotent" federal government has treated Social Security as it own little piggy bank to pay for many things that the money was NOT intended to pay...

Gosta Munktell (10/17/2008)

---

Let's start with the orginal question:

"Hello Experts,

Actually I have a Dynamically generated table with the columns names like Q1, Q2.... up to any number don't know. I just...

Sirish (10/17/2008)

---

[font="Arial"][font="Arial Black"]Is it possible to Insert the values of a Dynamic query into a temp table.

Declare @StrQuery varchar(40000)

Set @StrQuery=''Select * from Employee'';

Exec(@StrQuery);

My Actual Query is ofcourse much complex.IS...

FreeHansje (10/17/2008)

---

Consider this statement:

update hl7_patienten

set woonplaats = woonplaatsnaam

--SELECT t1.patientnummer, woonplaats, woonplaatsnaam

from hl7_patienten t1

inner join ptr_init_patienten_z_woonp t2

on t1.patientnummer = t2.patientnummer

Table hl7_patienten has 1500000 records, no index on WOONPLAATS, table ptr_init_patienten_z_woonpl has...

I think I understand what you are trying to do, but being a bit more of a visual based person it would help if you also provided the expected results...

Figured it out. It was probably mentioned somewhere, but I had to use the Service Name, not the display name.

😎

Started playing with xp_servicecontrol a bit and it looks like it works fine for default installations, but how can you use it to control/monitor a named instance?

I haven't had much...

Help us help you. There really isn't enough info in your post to work with. Please take the time to read the following article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Follow the guidelines in the...

As stated above, no you can't attach a database from SQL Server 2005 to SQL Server 2000 (even if it was in compatability mode 80). The disk structures are...

That's why I keep pushing for multiple offsite file servers. All I want is 4 distributed around the district (we are a K12 public school district) where I can...

Here's an answer you might hear where I work:

:hehe::cool:

Giving a user/role access to a stored procedure is a means to allow users/applications to access database tables without giving them direct access to the tables. If you don't...