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...

chinye2020 (8/31/2012)

---

Sean Lange (8/31/2012)

---

chinye2020 (8/31/2012)

---

Tbl_Account

AccNo Comm 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

Transaction_AccNo Comm Amount

5 1% $0.10

3 2% $0.20

2...

RBarryYoung (8/31/2012)

---

Sean Lange (8/31/2012)

---

Potso (8/31/2012)

---

Thanks I knew it was something simple and dumb i was just not thinking about. And i am dropping the table everytime after the stored procedure...

chinye2020 (8/31/2012)

---

Tbl_Account

AccNo Comm 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

Transaction_AccNo Comm Amount

5 1% $0.10

3 2% $0.20

2 2% $0.20 //how...

This isn't a crystal reports forum but I can try....

You said it is corrupted? What good...

pawana.paul (8/31/2012)

---

Hi,

Need your help in achieving one requirement, below are the details:

From Instance1, DB1, I am retrieving data from 6-8 tables using joins.

Form Instance2, DB2, I am retrieving data from...

chinye2020 (8/31/2012)

---

Luis Cazares (8/31/2012)

---

Sean is right, DDL and sample data would have been a great help. As well as posting your whole problem.

You should pay more attention to your code...

deepeshdhake (8/31/2012)

---

Hello,

I have created the stored procedure. Now I am accessing the same in the crystal reports. But when I preview the report, there is no data.

What can be...

Potso (8/31/2012)

---

Thanks I knew it was something simple and dumb i was just not thinking about. And i am dropping the table everytime after the stored procedure is run so...

I am not at all sure what that means??? Keep in mind that tables are unordered set...

You really need to read the article I suggested. You need to provide ddl (create table scripts) and sample data as inserts. We are all volunteers around here and I...