You really should keep this in the same thread: http://www.sqlservercentral.com/Forums/Topic588510-1291-1.aspx

Have you looked at the recent suggestions given there?

😎

Not sure, as you didn't provide the DDL for the tables or any sample data to test with, but does this work?

;with ProductList (

RowNum,

...

For S & G, put an index on woonplaats. If there are 1.5 million rows, but only 13,000 rows with a null value in woonplaats, you might see a...

Jeffrey Williams (10/19/2008)

---

nilmov (10/19/2008)

---

i slightly differ on that...if it is full logged and your disk is getting full, shrink is the option left. Not regularly but when have a...

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