mister.magoo (10/29/2012)

---

And more questions....

Have you checked the port the instance is listening on ?

- even though it is the default instance, it could be on a port other than 1433.

Have...

Joie Andrew (10/29/2012)

---

A few more questions:

- How many IP addresses is SQL configured to listen on?

- Are there multiple NICs on the server?

- Is NIC teaming used...

mister.magoo (10/28/2012)

---

is your client machine a member the same domain as the server?

can you connect using the name if you specifiy tcp/ip in the advanced connection settings?

are you logged in...

Joie Andrew (10/26/2012)

---

Interesting. I have never experienced anything like this. Is this same result experienced on other computers as well, or just yours? There is not a SQL alias setup...

Joie Andrew (10/26/2012)

---

Intersting development I tryed to connect from SSMS using the FQDN and it does connect! (I thougt I tried that previously, guess I didnt) Any idea what that...

Scott D. Jacobson (10/26/2012)

---

Was the server name changed after SQL Server was installed? If so you'll have to do sp_dropserver/sp_addserver to get the new machine name to take effect inside...

Joie Andrew (10/26/2012)

---

not sure if this helps yet, but i think the issue is a WINS issue when you cannot resolve by name;

For example if you enter SERVER04 instead of...

A side note for any newbies reading this:

I was manually performing:

SELECT * FROM ACTIVITY GROUP --Gave me total count of rows

SELECT DISTINCT * FROM ACTIVITY GROUP --Thought this was a...

sam.dahl (10/11/2012)

---

My understanding is that there's no way to use *, instead generate a list of columns and use that.

Modifying the CTE requires recognising how the ROW_NUMBER/PARTITION BY works.

Your code:

WITH...

Two more questions. I am new to using a CTE, so bear with me 🙂

There are tables with 20 or more columns. Can I use a wild card like *,...

Sean Lange (10/10/2012)

---

Here is an example of one way of deleting duplicates. There are plenty of other ways to do this.

create table #Dupes

(

IdentityValue int identity not null,

UserValue varchar(20),

AnotherValue varchar(10)

)

insert #Dupes

select...

Sean Lange (10/10/2012)

---

Not 100% sure what you are trying to do here. It sounds like you want to delete duplicates from a table? This seems like an awfully complicated way...

Got it working thanks!

ChrisM@Work (10/4/2012)

---

This should be close.

MERGE [DBname].[dbo].[Space] AS target

USING [DBname].[dbo].[RawData_Space] AS source

ON target.SPACE_ID = source.SPACE_ID

WHEN MATCHED THEN

...

Great Thanks!