You have obfuscated the real problem so much that it is really hard to figure out what you are trying to do. Can you post some ddl, sample data and...

As Cadavre already said...you three part naming. [database].[schema].[object]

What part(s) do you not understand of what you need to...

Given the nature of what your tables look like I would drop the column from sales entirely. You know what the price was in the sales table from the price...

tomsharp85 (6/17/2015)

---

Hi, I have a flat table with 17 columns of contact information with columns to seperate those contacts into different business classes. Here is the table:

USE DataCompany

CREATE TABLE ContactInformation

(

ID...

shindle 17293 (6/15/2015)

---

I have a WHERE clause in a DELETE statement and the x.[Timestamp] field is the PK:

DELETE x

...

Miranda Johnson (6/17/2015)

---

the while loop creates the 12 digit random character string subtracting 1 from the

@len variable in each iteration until it has all 12 characters

I will have to...

I see at least two big red flags in your code. The first one is that while loop. What is it doing? If I read it correctly it is simply...

Haha Chris. I am not...

What have you tried so far?

Ed Wagner (6/17/2015)

---

Sean Lange (6/17/2015)

---

Ed Wagner (6/17/2015)

---

Sean Lange (6/17/2015)

---

BL0B_EATER (6/17/2015)

---

Number 8 had me, having 2 under 2.5 years...

Ed Wagner (6/17/2015)

---

Sean Lange (6/17/2015)

---

BL0B_EATER (6/17/2015)

---

Number 8 had me, having 2 under 2.5 years of age makes me...

Sure...

#7 is...

Ahh...

tsobiech (6/12/2015)

---

I appreciate the helpful replies.

Stored procedures aren't much help, because I can't directly access them through Excel (only tables and views).

So, I would still have to take the results...