Is the information table indexed to support your queries?

Can you provide an actual execution plan?

lanky_doodle (3/3/2016)

---

Hey,

I have a query that is returning 3 rows (because there are 3 owners). I need to concat the 3 owners into a single value, which would return...

TomThomson (3/3/2016)

---

Has something gone wrong with sending notifications over the last day or two? A lot of new posts on the thread, but I haven't had a single...

Sean Lange (3/2/2016)

---

Ed Wagner (3/2/2016)

---

Sean Lange (3/2/2016)

---

Alan.B (3/2/2016)

---

Sean Lange (3/2/2016)

---

Steve Jones - SSC Editor (3/2/2016)

---

Alan.B (3/1/2016)

---

Ed Wagner (3/1/2016)

---

Alan.B (3/1/2016)

---

jasona.work (3/1/2016)

---

Ah, using SQL Server DATEDIFF to figure out how many days...

Run the result of the query into a #temp table and reference the temp table in your email body.

The two rows with date '2010-02-04' have FID of 1 and 3. Your desired output lists FID of 2 and 3 for this date.

Can you explain how FID of 2...

ravi@sql (3/1/2016)

---

Hi Champs,

I have a Merge statement which has both insert and update .

But source table is quite huge it is having around 70 million records or 2...

You have one too many SELECTs in there:

IF OBJECT_ID('tempdb..#StockManagement') IS NOT NULL DROP TABLE #StockManagement;

SELECT

STOCKCODE,

CAST(SUM((CASE WHEN TransactionTypeId IN (1, 4, 5, 7, 8, 10, 11, 13, 14) AND...

This exact same query including comments word for word was published by Ian Stirk in 2009.

http://www.sqlservercentral.com/articles/DMV/64425/

[/url]

Edit: 2008 even!

Luis Cazares (2/26/2016)

---

Ray K (2/26/2016)

---

Steve Jones - SSC Editor (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Sean Lange (2/26/2016)

---

Ed Wagner (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

Hugo Kornelis (2/26/2016)

---

Grumpy DBA (2/26/2016)

---

For some unknown reason a terrible song has been...

Then you should try columnstore [/url]indexes too - another weapon in your armoury. I think your sample query could benefit a great deal from a columnstore index.

There seem to be numerous syntax errors with this part:

IF ( (

@Client = 'Winco Foods'

AND EXISTS ( ;

WITH XMLNAMESPACES('http://www.w3.org/2001/XMLSchema-instance' AS ns)

SELECT

AuditNbr, VndNbr, VndName, CompanyCode, AuditorID,...

ScottPletcher (2/23/2016)

---

ChrisM@Work (2/23/2016)

---

spaghettidba (2/23/2016)

---

There is no built-in CONVERT style that will handle the format DDMMYYYY. This means that you will have to code it yourself. This should do:

CONVERT(date, RIGHT(Date1,2) +...

MMartin1 (2/23/2016)

---

ChrisM@Work (2/18/2016)

---

Nikku (2/18/2016)

---

Hi All

I have two tables t1 & t2 which contains the same records. t1 is for bank1 & t2 is for bank2

i.e t1

accno name balance

001000 ...

Alan.B (2/23/2016)

---

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...