Also:

select ServerProperty('IsClustered')

From SQL? try:

select serverproperty('ComputerNamePhysicalNetBIOS'), @@ServerName

(See BOL for this). If they are the same, no cluster.

Roy Ernest (4/15/2010)

---

What is the best way to beat writer's block? Anybody have any ideas? I am half way through an article and now I cant seem to complete it....

Do...

Jeez. (Where's the shaking head emoticon?) There is a lot to be learned by that one. Yoda? Oh Yoda? where...

Based on the sample data you provided, what are the expected results?

Jayded (4/15/2010)

---

Thanks Wayne! In this instance when I'm making the lists do I have to have a consistency that SQL column 2 points to Excel column 3 such that if...

I just wanted to quote the one part... to...

lmu92 (4/15/2010)

---

Side note:

I really enjoy working on this "challenge" for several reasons:

#1 (and most important): You take the code provided as something to start with and modify/improve it to meet...

gregory.anderson (4/15/2010)

---

The update of the conversionstatus statement isn't working how I want because it updates ALL of the records even though only 557000 of the 680000 are getting inserted (because...

uh, sure, jeff :w00t:

I agree.

If your Oracle db is using stored procedures, then you're probably going to have a big issue with this - unless they...

Tom.Thomson (4/15/2010)

---

And the horse replied "because the old grey...

Try:

INSERT INTO MAPPINGTABLE (Col1, Col2, Col3)

SELECT Col1, Col2, Col3

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\Documents and...

The GROUP BY clause goes before the ORDER BY clause.

Edit: You'll also need to add dbo.[IH_RE-TENANCY].[tenancy-ref] to the GROUP BY clause... try it without it and you'll get a new...