8reat1s (9/27/2011)

---

Hi kingston,

Thats spot on

and very clever

should have though about that

the other thing which i noticed is

when i am trying to find the firstday of the week for 04/09/2011...

What is happening when you include that where clause that is not to your expectation?

Does trg have permissions into the master database?

I would get rid of the execute as 'trg' in that trigger.

Definitely worth knowing

isuckatsql (9/27/2011)

---

The problem only occurs with large volumes of...

You could also issue a print statement with each param you want to see.

Best answer would come direct from Microsoft. Based on my dealings, the answer is you still have to buy the Enterprise license at full price.

hmmm...Could you possibly provide DDL and some sample data?

It would be handy in trying to recreate and provide a better solution.

Dang - Gail...

Rather than a global temp table (e.g. ##temptable), use a single # for your temp tables.

Also, you might want to figure out a method to rank your results. You...

Evil Kraig F (9/27/2011)

---

Took a bit to read through the discussion and decide if I wanted to go near it with a ten foot pole.

I don't.

On a side note, looks...

GSquared (9/27/2011)

---

Looks like The Thread may have killed the rest of the forums.

The Active Threads link is only showing 5 other discussions.

(Probably my fault for going political in here. ...

Evil Kraig F (9/27/2011)

---

SQLRNNR (9/27/2011)

---

Evil Kraig F (9/27/2011)

---

Trey Staker (9/27/2011)

---

@craig-2

Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's...

Please post the actual execution plan.

Evil Kraig F (9/27/2011)

---

Trey Staker (9/27/2011)

---

@craig-2

Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's really pricey but I...