GilaMonster (6/2/2014)

---

In general, lower numbers are better, however those stats values are so low there's no point in tweaking.

As for subqueries vs joins, depends on where the subqueries are,...

That's kind of what I meant, I'm not sure what I'm looking for! However, I don't actually have permission to run those. I'm part of the BI team...

Passenger

Geese

Ok, what did you get?

create table #OppHarSales1

(

BillNoint

,BillDatedate

,PatTypevarchar(8)

)

create table #OppHarSales2

(

ItemCodevarchar(6)

,Qtyint

,Priceint

,BillNoint

)

create table #MasterItem

(

ItemCodevarchar(6)

,Itemnamevarchar(25)

)

insert into #OppHarSales1

select 1,'2013-05-01', 'OP'union all

select 2,'2013-09-19', 'OP'union all

select 3,'2013-11-02', 'PHARMACY'union all

select 4,'2014-02-06', 'OP'union all

select 5,'2014-05-27', 'PHARMACY'

insert into #OppHarSales2

select 'GN0510',1,9,1 union all

select 'GN0510',1,9,2...

GilaMonster (5/27/2014)

---

I need a new laptop myself, but not even considering a surface.

I have an iPad which serves the tablet role just fine. My requirements for a laptop include being...

My wife's the same. I've got a smaller, lighter mid-range compact that...

Thanks for the replies but I think I've now got more questions than I had before. What's the best way of checking that clustering, mirroring and replication are set...

Fever

Steve Jones - SSC Editor (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? ...

Ed Wagner (5/23/2014)

---

Koen Verbeeck (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I...

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is a...

Ring

Try this

create table #Parent

(

PKint primary key not null,

Descrvarchar(10) not null,

Reference_PKint null

)

insert into #Parent

select 1, 'Gautham',nullunion all

select 2, 'Harsha',nullunion all

select 3, 'Kamal',1union...