A quick note: starting a CTE with a semicolon is like starting a sentence with a '.'

toraghubiz (1/28/2015)

---

Table Dept has two columns (did(int) , dname(varchar)).

Table emp has five columns (eid(int), mid(int), nme(varchar), did(int), city(varchar)).

Now I need to get the names of all departments having more than...

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