Sean Lange (3/29/2012)

---

Lynn Pettis (3/29/2012)

---

Sean Lange (3/29/2012)

---

sqlvogel (3/29/2012)

---

Sean Lange (3/29/2012)

---

Well in truth if you include the customer's current data at the time of the order in the order table you...

Treat the view as a table, put the order by on the select from the view, not in the view.

Sean Lange (3/29/2012)

---

sqlvogel (3/29/2012)

---

Sean Lange (3/29/2012)

---

Well in truth if you include the customer's current data at the time of the order in the order table you can't possibly be in...

Sean Lange (3/29/2012)

---

JamesMorrison (3/29/2012)

---

Sean Lange (3/29/2012)

---

That was a company trying to relocate a DBA to Kansas, so I figured they needed to offer larger amounts to get someone to move,...

Found it: virtual WAN optimization controllers.

Anybody know whst the acronym vWOC means? I hate email letters that fail to define terms and then go to a questionnaire page before you can even get the article...

Unfortunately, without the source data or the query you are running there really isn't much more we can do to help.

I suggest that you take the time to read the...

Brandie Tarvin (3/29/2012)

---

ACinKC (3/29/2012)

---

Brandie Tarvin (3/29/2012)

---

Just spent time in a meeting being reminded that people using the same terms do not always mean the same thing. Interesting effect that has...

Maybe I wasn't clear.

Simplified, 3nf:

Customer

----------

CustomerNumber

CustomerName

CustomerAddress

CustomerCity

CustomerState

CustomerPostalCode

...

OrderHeader

-------------

CustomerNumber

OrderNumber

OrderDate

...

OrderLine

----------

OrderNumber

OrderLineNumber

ProductNumber

...

At this point, we have normalized the data and identified the attributes needed to link data together between the tables.

Moving forward to a physical design, we...

Or, just use DISTINCT:

SELECT DISTINCT

bo.BackOfficeId,

u.ID,

u.UserName,

u.Email

FROM

dbo.BackOffice bo INNER JOIN

...

wendy elizabeth (3/29/2012)

---

In a new table in sql server 2008 R2 that I will be setting up, I am wondering if there is a problem setting up a column size...

Yea, I was having a bit of a problem seeing the sequence in the original post. Doesn't really help when column headers and data don't line up. The...

TcW_1978 (3/29/2012)

---

Here's the sample code :

CREATE TABLE [dbo].[Users](

[ID] [int] IDENTITY(1,1) NOT NULL,

[UserName] [varchar](20) NULL,

[Email] [varchar](20) NULL,

CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...

I find in my area that you look at 80K - 100K.

I'd have to ask where you are located, how much experience, what industry you are...