Duplicate post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1353709-8-1.aspx

SQLRNNR (8/31/2012)

---

Is...

But it probably does explain the Kansas City Sporting logo as my avatar. 🙂

Kansas City

Evil Kraig F (8/31/2012)

---

Unfortunately I'm not as cool as you guys and don't have a smoker, but you did get me to break out the LLoyd's Ribs for lunch. :-)...

SQLRNNR (8/31/2012)

---

Sean Lange (8/31/2012)

---

SQLRNNR (8/31/2012)

---

Sean Lange (8/31/2012)

---

SQLRNNR (8/31/2012)

---

Sean Lange (8/31/2012)

---

dwain.c (8/30/2012)

---

Jeff Moden (8/30/2012)

---

Brandie Tarvin (8/29/2012)

---

dwain.c (8/29/2012)

---

Jo Pattyn (8/29/2012)

---

How to inform developers that there are still slow/congested networks out there? About...

harri.reddy (8/31/2012)

---

hi

i need to give mail ,that if number of file deleted is 5.

the message should be 5 file deleted.

i am using send email task to email.but...

SQLRNNR (8/31/2012)

---

Sean Lange (8/31/2012)

---

SQLRNNR (8/31/2012)

---

Sean Lange (8/31/2012)

---

dwain.c (8/30/2012)

---

Jeff Moden (8/30/2012)

---

Brandie Tarvin (8/29/2012)

---

dwain.c (8/29/2012)

---

Jo Pattyn (8/29/2012)

---

How to inform developers that there are still slow/congested networks out there? About select * from...

SQLRNNR (8/31/2012)

---

Sean Lange (8/31/2012)

---

dwain.c (8/30/2012)

---

Jeff Moden (8/30/2012)

---

Brandie Tarvin (8/29/2012)

---

dwain.c (8/29/2012)

---

Jo Pattyn (8/29/2012)

---

How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one...

dwain.c (8/30/2012)

---

Jeff Moden (8/30/2012)

---

Brandie Tarvin (8/29/2012)

---

dwain.c (8/29/2012)

---

Jo Pattyn (8/29/2012)

---

How to inform developers that there are still slow/congested networks out there? About select * from remotesnailnetwork.matter.listed.particle finding one specific particle without...

So you managed to figure out what you needed? Not sure what I did other than try to understand the question but you are welcome. 😀

chinye2020 (8/31/2012)

---

Tbl_Account

AccNo Commision Add_By_AccNo Level

2 6.000 0 MANAGER

3 4.000 2 SUPERVISOR

5 3.000 3 SALEPERSON

Tbl_Transaction //this is the example insert query success

AccNo Commision Amount

5 1% $0.10

3 2% $0.20

2 2% $0.20

This is...

pawana.paul (8/31/2012)

---

Thanks for your response. Below are the statements I am running

On Instance1, it is something similar to the below statement:

SELECT A.COL1, B.COL2,C.COL3, A.COL4, B.COL5, C.COL6 FROM

ABC A JOIN DEF...

chinye2020 (8/31/2012)

---

Msg 319, Level 15, State 1, Line 13

Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context...

RBarryYoung (8/31/2012)

---

Sean Lange (8/31/2012)

---

...

Sure for DBMail it works well. I just never saw anything in here that indicated that. Global temp tables can just a pain to deal with so...