This woke me up from a nap after lunch...

Check the table and its dependent objects. One of the objects in your replication set up would have missed.

Try re-registering TextMgrP.dll.

sqlzealot-81 (2/22/2012)[hr

Write a sub query filtering the values from tableb and then join.Try the below...I dint really try it in SSMS.

SELECT

FROM ...

Divine Flame (2/23/2012)

---

I don't understand your question. You already have the solution as version 2. True, you should put all the filter criteria in WHERE clause. There is no point...

EasyBoy (2/22/2012)

---

sqlzealot-81 (2/22/2012)

---

SELECT number into #TempInts FROM iter_intlist_to_table(@keyPlantOperatingStatusExt)

This is the easy way to create a temp table.Use this temp table(#TempInts) for the query.

Apart, I would recommand you to use Exists...

SELECT number into #TempInts FROM iter_intlist_to_table(@keyPlantOperatingStatusExt)

This is the easy way to create a temp table.Use this temp table(#TempInts) for the query.

Apart, I would recommand you to use Exists instead of...

and (x0_0.KeyPlantOperatingStatusExt in (SELECT number FROM iter_intlist_to_table(@keyPlantOperatingStatusExt))

The above snippet is not present in your query. Please use the same and look at the execution plan.

Or other way, change it...

Try using PIVOT... That would help you for sure.

SQL_Surfer (2/22/2012)

---

Version 1

---------

SELECT

FROM Table a

LEFT JOIN Table b ON a.ID= b.ID AND b.BMonth= 2 AND BY= 2022

...

Okei, if only...

sqlzealot-81 (2/9/2012)

---

I dont understand this point,...

I dont understand this point, say...

Divine Flame (2/9/2012)

---

sqlzealot-81 (2/9/2012)

---

GilaMonster (2/9/2012)

---

32 bit SQL on 32 bit OS is limited to 2GB of memory. Some (around 300 MB) is reserved (called mem_to_leave), the remainder is exactly that...

GilaMonster (2/9/2012)

---

32 bit SQL on 32 bit OS is limited to 2GB of memory. Some (around 300 MB) is reserved (called mem_to_leave), the remainder is exactly that 1.6GB that you...