I just thought I'd further add that I came across an application where my nightly index rebuild would fail ever so often. Turns out the application would produce temporary...

I have had issues where a reindex/update stats would cause a t-log backup from occurring. So what I do is disable the t-log backup before the reindex begins then...

I put notifications on the backup jobs so when they fail I'll get notified. Why wouldn't you consider that as a solution vs. running a query to determine the...

Reading this post wants me to go back to BOL and read up on ISNULL.... whow.. Note to self.... be very careful posting a question with ISNULL as a part...

Sean Lange (12/20/2013)

---

sqlnaive (12/20/2013)

---

Thanks Sean/Kurt for the wonderful query.

One update to the requirement and one query.

Modification is that there might be some students who have only one or two or...

All of my production databases are not that large. Because of that fact I rebuild all of the indexes and update all statistics in all of my databases as...

Here is my solution:

with details_English_cte (StudentID, Subject, Marks) as (

select StudentId

,Subject

,Marks

from dbo.T_Detail

where Subject...

It would also help by posting the DDL & the code in the Sprocs... Sometimes adding indexes & statistics to a series of tables is like putting lipstick on a...

Sean;

Interesting solution... I had something much like yours getting the same results the only difference is I split out the 3 different subjects into separate CTEs then joining...

Format

Ed Wagner (12/19/2013)

---

crookj (12/19/2013)

---

Ed Wagner (12/19/2013)

---

Stuart Davies (12/19/2013)

---

JAZZ Master (12/18/2013)

---

Ed Wagner (12/18/2013)

---

SQLRNNR (12/18/2013)

---

Stuart Davies (12/18/2013)

---

Cliff Jones (12/18/2013)

---

sing4you (12/18/2013)

---

JAZZ Master (12/18/2013)

---

crookj (12/18/2013)

---

Ed Wagner (12/18/2013)

---

sing4you (12/18/2013)

---

Ed Wagner (12/18/2013)

---

BWFC (12/18/2013)

---

EL Jerry (12/17/2013)

---

Revenant (12/17/2013)

---

Ed...

I have always made it a practice that when I'm inserting into or selecting out of a table I always specify the columns. In your case when you are...

ETL tools of choice for SQL Server is SSIS or SQL Server Integration Service. You can get rather complex with your extract & transforms. There are other third...

On your CTE declaration you have @Pattern, @Room, & @Tag. I'd change them to Pattern, Room, & Tag.

;with C_ORDERS_CTE (

co_num,

co_line,

item,

cust_num,

cust_seq,

qty_ordered,

qty_ready,

qty_shipped,

promise_date,

ship_date,

order_date,

stat,

Uf_PJ_AllocatedDate, ---as AvailableDate,

@Pattern, ---as...

Ed Wagner (12/13/2013)

---

Closed (less talking...