Cambodia

Embarrass

Ed Wagner (6/2/2014)

---

Master (I guess if I...

And that's inexperience again. I think it's...

GilaMonster (6/2/2014)

---

What does set-based have to do with...

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