L' Eomot Inversé (9/28/2012)

---

ChrisM@Work (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

laurie-789651 (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

Grant Fritchey (9/27/2012)

---

THREADIZENS!

Who is going to make it to any of the SQL in the City events coming up in the...

SQL_path (9/28/2012)

---

Sean Lange (9/28/2012)

---

Not enough details to provide much of an answer. What is in @orders? What does the split function look like?

I would recommend using the splitter found...

Can you post the actual query you are attempting to run? There are several errors in the query you posted.

What's the datatype of column [itt_jobcodeid], table [LibertyGasGroup_MSCRM].dbo.[FilteredITT_instruction]?

dwain.c (9/27/2012)

---

Phil,

I think this is a pretty snappy query too.

;WITH Tally (n) AS (

SELECT TOP (SELECT 1+MAX(DATEDIFF(day, StartDate, EndDate)) FROM #RoomDates)

...

emile.milne (9/28/2012)

---

When I run this that missing index is top with 3BN advantage, server last restarted in June.

I use the DMV as a guide, and see if consolidation is possible...

S_Kumar_S (9/28/2012)

---

Hi Friends

I do a check on a table if a particular record exists in table using IF EXISTS(SELECt 1 FROM tab1 WHERE id=1) inside a proc. Now if record...

gsd1 (9/28/2012)

---

Jeff Moden,

Thank you for the response.

I am receiving a list of 50000 records from a service.

I am planning to write a stored procedure with table-valued parameter and...

Barry Couch (9/28/2012)

---

opc.three (9/27/2012)

---

Is there a front-end? If so that is where I would put the sorting logic.

If not, or you must do this in the database, you could look...

emile.milne (9/28/2012)

---

Quick one I have the following index in place followed by a missing index. With a MASSIVE impact advantage missing index (second row).

How do I consolidate these 2 together,...

laurie-789651 (9/28/2012)

---

Grant Fritchey (9/28/2012)

---

anthony.green (9/28/2012)

---

I missed the London...

laurie-789651 (9/28/2012)

---

ChrisM@Work (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

If you do one...

Thanks. Here's another way of looking at what Laurie posted;

DECLARE @A Int, @b-2 Int, @C Int;

SELECT @A...

Koen Verbeeck (9/28/2012)

---

laurie-789651 (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

If you do...

laurie-789651 (9/28/2012)

---

It's truncation of intermediate results.

Using Decimal data type will fix it:

-------------------------------------------------------------------------

DECLARE @A Int, @b-2 Int, @C Int;

SELECT @A = 9,

@b-2 = 3,

@C = 2;

SELECT Cast(SUM(@A*@B) / SUM(@C) AS DECIMAL(30,5));

SELECT...