It's surely what you are used to? Pork & apple in the UK. Never tried sausages & maple...

BWFC (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

BWFC (10/1/2015)

---

I got a bacon making kit for my birthday on Sunday. I can't wait to give it a go. Hopefully next month there'll be a...

BWFC (10/1/2015)

---

I got a bacon making kit for my birthday on Sunday. I can't wait to give it a go. Hopefully next month there'll be a butty with...

Grace09 (9/30/2015)

---

I have a simple query, Select Max(Substring(nd_num, 12,3) from NDE where datepart(dd, nd_adate)=2. The query plan is attached. How should I tune this query? It comes to the top...

dwain.c (10/1/2015)

---

BL0B_EATER (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Lynn Pettis (9/30/2015)

---

Jack Corbett (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Ed Wagner (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Eirikur Eiriksson (9/30/2015)

---

WayneS (9/30/2015)

---

Luis Cazares (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped...

BL0B_EATER (10/1/2015)

---

ChrisM@Work (10/1/2015)

---

Lynn Pettis (9/30/2015)

---

Jack Corbett (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Ed Wagner (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Eirikur Eiriksson (9/30/2015)

---

WayneS (9/30/2015)

---

Luis Cazares (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into...

Lynn Pettis (9/30/2015)

---

Jack Corbett (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Ed Wagner (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

SQLRNNR (9/30/2015)

---

Eirikur Eiriksson (9/30/2015)

---

WayneS (9/30/2015)

---

Luis Cazares (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into my Hotmail...

Alvin Ramard (9/30/2015)

---

Oh wait! Not all four letter words are bad!

Cold Beer: Two four letter words together...

mw112009 (9/30/2015)

---

Table Name: Denominator

Already has the following constraint:

PK_Denominatorclustered, unique, primary key located on PRIMARY DenominatorID

How can I add a unique key that will cover the 3 fields --> MemberID,MeasureID,TimePeriodID

I also...

Brandie Tarvin (9/30/2015)

---

ChrisM@Work (9/30/2015)

---

An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in Soho (London) paying £50k to £90k....

An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in Soho (London) paying...

elmnas (9/30/2015)

---

Hello people I have made following query,

How do I trim my result without replace anything in the current DB?

here is my query

SELECT

tt.bestdatum as 'Year',

FROM

[myDB].dbo.myTable as tt INNER JOIN

WHERE...

Phil Parkin (9/30/2015)

---

Brandie Tarvin (9/30/2015)

---

Grrr. The way he phrased his thank you. Yes, I piled on. But believe me, what I posted was far...

girl_bj (9/30/2015)

---

IDCode Amount

999 07032.00

999 21187.00

888 226200.00

999 125829.00

If code is 1 means discount.

I would like to pull all column but the amount I get is different.

26200.00-(7032+1187+25829.00)

i did this:

select id,discount-amount total

from(

select id,sum(case...

elham_azizi_62 (9/30/2015)

---

hello.

thanks for your reply.

I already need this out put:

1188 Ali Ahmadi BaseSalary 1213232323 ExtraSalary 54585 SpecialSalary 245832

1245 ahmad Alipour Null Null ExtraSalary 2526961 Null Null

1478 sara Emami BaseSalary...