DonlSimpson (1/27/2015)

---

I know this is fairly radical, but I enforce an alphabetic order to the column list in the schema. My only concession is pk first.

I got...

I told you the way. I'm not going to...

atul.jadhav (1/27/2015)

---

Is there a unique key in the source Excel data?

It seems that your ideal flow would be something like:

1) Process Excel file. For each row:

2) Does row exist in...

Is there a unique key in the source Excel data?

It seems that your ideal flow would be something like:

1) Process Excel file. For each row:

2) Does row exist in target...

I have no idea what you mean. Did you check the link?

A brief search suggested this[/url].

There was...

Try the following:

with data

as (

select PhoneNo = '727-555-1234'

...

mister.magoo (1/24/2015)

---

...or you can use the Object Explorer Details view to sort the columns.

Just click on the "Columns" node in Object Explorer, then press F7 to open the details view...

ScottPletcher (1/23/2015)

---

Phil Parkin (1/23/2015)

---

Steve Jones - SSC Editor (1/23/2015)

---

I tend to use ID, but that's I think my OCD coming in. ID is an acronym. Product is a word.

ProductId would...

Steve Jones - SSC Editor (1/23/2015)

---

I tend to use ID, but that's I think my OCD coming in. ID is an acronym. Product is a word.

ProductId would look funny to...

Exactly. I think it must...

ZZartin (1/23/2015)

---

The only proper naming convention is all caps with underscore seperators.

On another note on the most jarring experience I had with naming conventions was using an open source ecommerce...

I cannot see how you could use PIVOT to generate the same results as your SELECT ... UNION example.

Would you be so good as to post the solution please?

This is not about cutting code – SQL Prompt...