15,896,726 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 Javascript questions
View Visual Basic questions
View Python 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 Aadyakumar (Top 19 by date)
Aadyakumar
20-Aug-14 7:39am
View
This is something different,failed login attempt coming after login attempt . but how can i trigger an event when some one attempting for login
Aadyakumar
4-Jul-14 6:44am
View
Hi Subanesh ,This can't be answerable even in a 1000 page book .
So it is better to study a physical ERP system ,try to work on it .
Then you can develop modules as you need .
Aadyakumar
4-Jul-14 2:27am
View
Don't use * with select ,if you specify column name it give better performance .
select sno, name, phone, city from [chaitu]
Aadyakumar
4-Jul-14 0:17am
View
Yes,it is possible . If you think about a whole ERP system ,it is too big and need very good experience/knowledge in ERP/Accounting .
But don't worry just get some knowledge about ERP from wikipedia and it is better to get knowledge in SAP/TALLY/MICRO SOFT DYNAMICS NAVISION .
Aadyakumar
3-Jul-14 7:06am
View
Create a database with required information , then make a trigger/job for notification.Better option is a job .
Aadyakumar
1-Jul-14 7:15am
View
The parameters are ok,and the stored procedure is working (ie,i had checked by saving the out put in a table).
But it is not coming in the C# program .
If i replace another Stored procedure and its parameter(only procedure name and parameter,no more changes) then out put will come .
How it happens ???
Aadyakumar
1-Jul-14 0:40am
View
Ok,i have same doubt,but if i use another stored procedure in same location of C# code then it will work fine. why??
Aadyakumar
30-Jun-14 8:25am
View
revisit the link i had put the code there..
Aadyakumar
30-Jun-14 8:22am
View
I had put the stored procedure in solution,since it is larger to submit here...
Aadyakumar
30-Jun-14 8:22am
View
I had put the stored procedure in solution,since it is larger to submit here...
Aadyakumar
30-Jun-14 8:16am
View
Deleted
I had put the stored procedure in solution,since it is larger to submit here...
Aadyakumar
28-Jun-14 2:20am
View
Please check this post and help me if you can .
http://www.codeproject.com/Questions/790861/Csharp-Program-with-Sql-Stored-Procedure-with-pivo
Aadyakumar
28-Jun-14 0:51am
View
It is very much helpful solution , i also faced same situation where dynamic number of columns needed .I had solved it my self and it is some thing like this
Aadyakumar
25-Jun-14 7:31am
View
Already i had done some search , but i didn't get a start up.Just consider i have only a navision login .
Aadyakumar
14-Jun-14 7:18am
View
Thanks for your replay
Aadyakumar
9-Jun-14 7:31am
View
As per you,these are the possible join condition.
Then even after indexing ,if the slowness exist,It is not related to query performance .
Check maximum server memory property of sql server ,It may be set to a low value .
Else it is due to low System/Server performance .Also think lots of records in your tables
Aadyakumar
9-Jun-14 6:22am
View
Thanks for your suggestion , i am also planning to handle it in Excel . But i want to know, is it possible in Sql .
;)
Aadyakumar
9-Jun-14 4:53am
View
But my problem is i don't know the columns name.because it is dynamic. I know only the key (primary and foreign key) columns name. ie,i know the column name Column1 and Column2,then how can i write the select for remaining column . Another thing don't go for sys.tables and columns because columns are dyanamic
Aadyakumar
9-Jun-14 4:44am
View
OK, it is a way ,it will give solution for my job , but i need to know how can we do it in Sql Server
any how,thanks for replay
Show More