WITH Cases AS (

SELECT * FROM (VALUES

('SystemA', 'Case1', '2013-07-11 13:17:09.000', '2013-07-15 12:05:03.000'),

('SystemA', 'Case2', '2013-07-12 16:27:50.000', '2013-07-12 16:29:12.000'),

('SystemA', 'Case3', '2013-07-12 17:30:32.000', '2013-07-12 17:40:11.000'),

('SystemA', 'Case4', '2013-07-12 19:00:24.000', '2013-07-12 19:04:14.000'),

('SystemA', 'Case5', '2013-10-01...

T.Ashish (6/9/2014)

---

Thanks Chris.

Yes, I had already tried creating # table as you advised. This was showing lot of improvement in i/o stats as main part was executing only 1 time...

T.Ashish (6/9/2014)

---

Hi all,

I have attached a script and its execution plan for your review.

We are working for a long time on optimizing this script, and latest modification I did was...

SQL is delicious (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore...

julian.fletcher (6/6/2014)

---

.. I should have said that we're looking for developers to work on all parts of a particular product; both the C# and the SQL. We're not big enough...

julian.fletcher (6/5/2014)

---

I work for a company of about 50 people in Oxford and am involved in the recruitment process - we're looking for developers with at least a couple of...

It's hard to believe this I know, but...

pk2dpvp (6/6/2014)

---

If I change WHERE to AND it gives me this..:

(408014 row(s) affected)

which with where is:

(2054 row(s) affected)

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

Isn't this because it doesn't know what to do with AND so it...

The first query may not be doing what you expect. If you reference a column from a left-joined table in the WHERE clause, the left join is converted to an...

-- TESTING

-- Set up a CTE with agent numbers expanded out, randomly number the rows within each QueueID

;WITH RandomAgents AS (

SELECT QueueID, AgentID, rn = ROW_NUMBER() OVER(PARTITION BY...

vinodkumark_mca (6/5/2014)

---

Hello,

Thanks for your feedback.

I have attached the related tables and functions in "Queries.txt" file.

The testing data is shared in "TestingData.xls" file.

Please look into issue and let me know if...

Hrhb.mail (6/5/2014)

---

Thanks, I solved it.

This is my final stored procedure:

Create PROCEDURE [dbo].[NewsPageWise]

...

Jeff Moden (6/3/2014)

---

Eirikur Eiriksson (6/3/2014)

---

Second that but then again...

ramana3327 (5/31/2014)

---

DELETE TableB WHERE studentID = @studentID

IF NOT...

Yes you're right, with a fixed number of rows, FOR XML PATH is probably overkill.