Viewing 15 posts - 10,876 through 10,890 (of 15,376 total)
chinye2020 (8/31/2012)
Sean Lange (8/31/2012)
chinye2020 (8/31/2012)
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...
August 31, 2012 at 11:13 am
RBarryYoung (8/31/2012)
Sean Lange (8/31/2012)
Potso (8/31/2012)
August 31, 2012 at 11:04 am
chinye2020 (8/31/2012)
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...
August 31, 2012 at 10:55 am
deepeshdhake (8/31/2012)
No there is no network down. Stored proc is working good. But I cannot see the result in crystal reports.
This isn't a crystal reports forum but I can try....
August 31, 2012 at 10:53 am
m.rajesh.uk (8/31/2012)
Thanks for u r reply.. i mean the data base not available corrupted... i need to take back up is there option available
You said it is corrupted? What good...
August 31, 2012 at 10:48 am
pawana.paul (8/31/2012)
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...
August 31, 2012 at 10:46 am
chinye2020 (8/31/2012)
Luis Cazares (8/31/2012)
You should pay more attention to your code...
August 31, 2012 at 10:13 am
deepeshdhake (8/31/2012)
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...
August 31, 2012 at 10:06 am
Potso (8/31/2012)
August 31, 2012 at 9:48 am
chinye2020 (8/31/2012)
how to in select query save the last row Commision Value?have any idea?
I am not at all sure what that means??? Keep in mind that tables are unordered set...
August 31, 2012 at 9:42 am
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...
August 31, 2012 at 9:41 am
chinye2020 (8/31/2012)
im using CTE read the most lowest member until top,but until top,need to read back the second top Commision,this is the problem
Your above explanation is totally unclear. Before anybody...
August 31, 2012 at 9:08 am
I agree with Chris. There is no need for dynamic sql for this at all. In fact, you should run away from the implementation you put together quickly. It is...
August 31, 2012 at 7:39 am
harri.reddy (8/30/2012)
its just in 1 sheet.yes prod1 is same, but i need uniques value from all 3 and put into 1 column in database
No offense harri but how do you...
August 30, 2012 at 2:43 pm
sql1411 (8/30/2012)
You have two rows here and one of them is the OriginalAircraftNumber and one becomes the FinalAircraftNumber. What can you...
August 30, 2012 at 2:33 pm
Viewing 15 posts - 10,876 through 10,890 (of 15,376 total)