xsevensinzx (11/6/2015)

---

Brandie Tarvin (11/6/2015)

---

xsevensinzx (11/6/2015)

---

Jeff Moden (11/5/2015)

---

Precisely. I couldn't have said it better myself. It's a bit like interviewing a mechanic. If they can't describe the difference...

Ed Wagner (11/5/2015)

---

Sean Lange (11/5/2015)

---

xsevensinzx (11/4/2015)

---

Jeff Moden (11/4/2015)

---

Brandie Tarvin (11/4/2015)

---

Jeff Moden (11/3/2015)

---

Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert"...

Haven't heard back, so I thought I'd provide my updated solution:

create table #Channels (

ChannelDate datetime,

SourceId int,

ChannelId int,

...

Brandie Tarvin (11/4/2015)

---

Jeff Moden (11/3/2015)

---

Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert" Database Developer. It amazing how they...

Actually,...

DBA Cabuloso (11/4/2015)

---

I can try to explain,

In the regular DBA job, we query our databases everyday.

If we use Natural Join, it is more concise, we write less.

We don't have...

Jeff Moden (11/3/2015)

---

Man o man... yet another self-proclaimed DBA bites the dust in the interview process as has another self-proclaimed "expert" Database Developer. It amazing how they don't know...

FYI, I have a solution already. Just curious what change(s) you think need to be made to the query.

EJGAJG (11/4/2015)

---

Hallo Lynn,

Was it so simple.

Maybe i told it wrong, but i have at the moment almost 47000 rows of data and i want to filter only the first data...

This should get you started. Ask questions if you aren't sure what the code is doing. Also, remember that Books Online is your friend.

create table #Channels (

...

Well, not much we can do about your query since we can't see it or the DDL for the tables it is running against.

Please take the time to read the...

Now for a solution:

create table #Orders (

order_no varchar(2000),

tracking_no varchar(64)

);

insert into #Orders(order_no, tracking_no)

values ('1256484','1Z0310590352855360'),

('1254541','1Z0310590353390173'),

...

celticpiping (11/3/2015)

---

ok, fair questions

I did have a THEN: totally left it off for no reason..

The end goal is to find those "order_no's that are over 7 characters in length,

and if...

Probably could if we knew what it is you are trying to accomplish. It's possible that it may not even require a cursor.

DBA Cabuloso (11/3/2015)

---

Why doesn't Microsoft SQL Server implement NATURAL JOIN?

It is in the SQL Standard.

I know it can be tricky (when fields have the same name such as DateUpdated),...