ScottPletcher (4/4/2013)

---

Lynn Pettis (4/4/2013)

---

ScottPletcher (4/1/2013)

---

sharky (3/31/2013)

---

Lynn Pettis (3/29/2013)

---

SQLRNNR (3/29/2013)

---

Lynn Pettis (3/29/2013)

---

ScottPletcher (3/29/2013)

---

The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has...

Or this:

WITH Priorities as (

SELECT

Priority,

PriorityOrder

FROM

(VALUES ('Top Priority',1),

('High',2),

...

Really? If all you need from the StudentData in a separate table is a sumary of fees by department this will provide what you want with no temporary table...

Try this:

insert into PendingIO(

[database],

Physical_name,

io_pending,

io_pending_ms_ticks,

io_type,

num_of_reads,

...

T.Ashish (4/4/2013)

---

Hi All,

I have attached two queries with table definition and sample data.

Query 2 is working better then query 1.

Now the actual question is:

Should I...

Words, all I see are words. We need...

ScottPletcher (4/1/2013)

---

sharky (3/31/2013)

---

Lynn Pettis (3/29/2013)

---

SQLRNNR (3/29/2013)

---

Lynn Pettis (3/29/2013)

---

Really?...

This doesn't help me. Using the limited sample...

Chris Quinn-821458 (4/4/2013)

---

I think I have discovered something that is possibly significant!

As stated previously, the data is a set of key/value pairs, with a datatype (D = Date, N= Number,...

Vertigo44 (4/3/2013)

---

Lynn,

Wouldn't that give me Visits with or that have doc name B? I'm looking for the ones that do not have a specific document...that are missing a document. You...

Are you the interviewer or interviewee?

Something like this:

select *

from

TableH h

where

exists(select 1 from TableC c where c.[visit#] = h.[visit#] and c.[document name] = 'Doc B');

erikd (4/3/2013)

---

Heh. Curiously, I can use Python to split the file up (opening the whole file with any...

And what happens if you make the phone number field varchar(8)?

Can you upload a 10 line snippet of the file as a .txt file, please?