16,020,877 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Visual Basic questions
View Javascript questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by mohd vaquas (Top 13 by date)
mohd vaquas
30-Oct-11 7:17am
View
hi Amir
my actual Table Record is given below..
DepotCode RouteCode RouteName ArbRouteName TotalSale DayNames DayNumber
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 55.9944 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 139.986 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 120 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 150 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 150 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 30 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 200 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 900 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 600 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 450 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 405 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 498 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 855 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 225 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 810 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 210 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 150 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 900 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 630 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 100 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 315 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 900 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 135 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 180 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 13.9986 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 135 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 180 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 45 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 30 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 1095 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 2190 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 1980 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 300 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 210 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 360 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 975 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 420 Sunday 2
and i need my table look like ...
DepotCode RouteCode RouteName ArbRouteName TotalSale DayNames DayNumber record
113 113007 JEDS 01 SNACKS JEDS 01 جده بط
mohd vaquas
30-Oct-11 7:11am
View
Deleted
hi Amir,
Thanks For Your Reply
my actual Table Record is given Below...
DepotCode RouteCode RouteName ArbRouteName TotalSale DayNames DayNumber
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 55.9944 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 139.986 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 120 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 150 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 150 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 30 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 200 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 900 Saturday 1
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 600 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 450 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 405 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 498 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 855 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 225 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 810 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 990 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 210 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 150 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 60 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 900 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 630 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 100 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 315 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 900 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 135 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 180 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 45 Sunday 2
113 113007 JEDS 01 SNACKS JEDS 01 جده بطاطس 90 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 13.9986 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 60 Saturday 1
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 135 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 180 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 45 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 30 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 1095 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 2190 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 1980 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 300 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 210 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 360 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 975 Sunday 2
113 113008 JEDS 02 SNACKS JEDS 02 جده بطاطس 420 Sunday 2
mohd vaquas
30-Oct-11 3:22am
View
when i process the above its give me error
'The statement terminated. The maximum recursion 100 has been exhausted before statement completion'.
mohd vaquas
30-Oct-11 3:21am
View
when i process the above its give me error
'The statement terminated. The maximum recursion 100 has been exhausted before statement completion'.
mohd vaquas
30-Oct-11 3:03am
View
can you explain with a(r,d,cnt) what is the a,r,d,cnt please .....
mohd vaquas
25-Oct-11 9:31am
View
how can i create running total .....
when i create running total this formula not show.....
please help me
mohd vaquas
25-Oct-11 7:26am
View
select ceiling(ROW_NUMBER() OVER (Order by TotalSale desc)) AS rownumber, * from #tempTable2
when i run this query its give me the sequential Rownumber like 1,2,3,4,5,6,7,8,9........
i need one more column which store the 1 for 1 to 5 record and 2 for 6 to 10 records and so on......
please help me how can i achieve this result
thanks
mohd vaquas
25-Oct-11 7:16am
View
thanks for ur reply
update table set record=((id-1)/5+1
the above query what is the id?
can u please explain Little more
thanks
mohd vaquas
25-Oct-11 7:09am
View
yes i need same as ...
how i can do like that can you please give me some more detail..
mohd vaquas
24-Oct-11 9:43am
View
Hi Navy,
i do all the things and everything is good in my report ,i need only whilereadingrecord in crystal report subtotal insert into the report after each 10 records.reset to zero for further 10 records....so please suggest how i reset and break the subTotal on base of Record .
mohd vaquas
20-Jun-11 6:58am
View
Thanks sir Its Working .........................
mohd vaquas
9-May-11 8:54am
View
thanks brother its work now
mohd vaquas
3-May-11 7:10am
View
Its only return else messgae but record available in database
Show More