Comments by Aadyakumar

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

Comments by Aadyakumar (Top 19 by date)