Shoot... 80MB for TempDB??? I boot the servers at work with 9GB... I doubt that I would boot any server with less than a gig for TempDB. And,...

I actually think a loop of some sort would probably be faster for this (GAK! I can't believe I just said that! :hehe:)... except for a couple of minor...

Heh... if you really want to throw a ball of wax at them before you decide to find a place with reasonable requirements, tell them the column should be named...

Heh... remove the ANSI joins and add old fashioned FROM's separated by comma's with no WHERE clause to cause a join. Then, add a distinct or a group by...

Remove the parenthesis from the parameter list... it's not a function...

I've restructured the WHERE clause without changing any of the code... I think the problem sticks out like a sore thumb...

WHERE (ET.iSiteId = @locSITEID)

...

SELECT SYSDATE FROM DUAL;

eric (11/10/2008)

---

The presentation of the data needs to be like this

1, 'P1', 1, 2, 3, 4, 0

2, 'P1', 10,...

As Lynn stated, you've probably...

Something else you might want to consider... the best hardware in the world won't solve performance problems if the code isn't quite up to it. I'd probably start by...

Absolutely correct on all accounts, Steve... suggestions very similar to yours were made by myself and others but to no avail. I'm amazed at the number of managers have...

Mohit (11/9/2008)

---

Hi Jeff,

Thank-you for the comments, I didn't think RBAR would be big issue in my case because the table had limited number of rows and wasn't...

That sounds more like problems with a table variable. Why aren't you using a temp table, instead?

yep... paste the following into the "help" url box...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d4c26311-d9f4-432c-953a-1c1042b33c97.htm

Why? NullIf is nothing like IsNull or Coalesce and the idea of code portability is a myth.