Click here to Skip to main content
15,846,091 members
Home / Discussions / Database
   

Database

 
AnswerRe: Regarding SSIS (SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel" failed with error code 0xC0202009.) Pin
Mycroft Holmes15-May-13 0:24
professionalMycroft Holmes15-May-13 0:24 
QuestionRegarding DB2 Rows to Column String Concatenation Pin
SenthilKumar-8313-May-13 6:05
SenthilKumar-8313-May-13 6:05 
QuestionHow to Update this request Balance Column Pin
Robymon13-May-13 2:49
Robymon13-May-13 2:49 
AnswerRe: How to Update this request Balance Column Pin
Blue_Boy13-May-13 5:14
Blue_Boy13-May-13 5:14 
AnswerRe: How to Update this request Balance Column Pin
gvprabu13-May-13 6:36
gvprabu13-May-13 6:36 
AnswerRe: How to Update this request Balance Column Pin
Jörgen Andersson14-May-13 0:53
professionalJörgen Andersson14-May-13 0:53 
QuestionMigration process. Pin
nagesh2113-May-13 1:00
nagesh2113-May-13 1:00 
QuestionNeed your opinion on querying data for presentation on winforms / web page and for reports Pin
Nayan Ambaliya12-May-13 13:53
Nayan Ambaliya12-May-13 13:53 
Dear all,

I require your opinion on what approach is good and/or practical for the following scenario.

There is a web application which queries data from SQL server.
For example:


Users report to a manager
1. The process by clicking a button is finding who reports to me (manager)
2. So there is a stored procedure written to find the users reporting to the manager

Now, there is a report (rdlc on the web server displayed via reportviewer control) which takes the manager as an input to generate report data for the staff members reporting to that manager.
The stored procedure for this report uses existing stored procedure (as in step 2 above) to find the staff members reporting to the manager and then generate required data.


My question is:
1. Is this the right way of doing this
2. Is there a need to develop a separate SQL view just for this report
3. What would be the best approach on doing this.

Please help.

Thanks

Regards,
Nayan
AnswerRe: Need your opinion on querying data for presentation on winforms / web page and for reports Pin
Mycroft Holmes12-May-13 16:05
professionalMycroft Holmes12-May-13 16:05 
GeneralRe: Need your opinion on querying data for presentation on winforms / web page and for reports Pin
Nayan Ambaliya12-May-13 16:10
Nayan Ambaliya12-May-13 16:10 
QuestionCannot insert the value NULL into column Pin
Member 991209112-May-13 13:33
Member 991209112-May-13 13:33 
AnswerRe: Cannot insert the value NULL into column Pin
Mycroft Holmes12-May-13 16:02
professionalMycroft Holmes12-May-13 16:02 
AnswerRe: Cannot insert the value NULL into column Pin
Bikash Prakash Dash13-May-13 20:27
Bikash Prakash Dash13-May-13 20:27 
GeneralRe: Cannot insert the value NULL into column Pin
Mycroft Holmes13-May-13 21:55
professionalMycroft Holmes13-May-13 21:55 
QuestionComparing 2 values in same column SQL (C#) Pin
Member 991209111-May-13 6:56
Member 991209111-May-13 6:56 
AnswerRe: Comparing 2 values in same column SQL (C#) Pin
Eddy Vluggen11-May-13 7:08
professionalEddy Vluggen11-May-13 7:08 
GeneralRe: Comparing 2 values in same column SQL (C#) Pin
Member 991209112-May-13 7:22
Member 991209112-May-13 7:22 
AnswerRe: Comparing 2 values in same column SQL (C#) Pin
PIEBALDconsult11-May-13 8:22
mvePIEBALDconsult11-May-13 8:22 
AnswerRe: Comparing 2 values in same column SQL (C#) Pin
Mycroft Holmes11-May-13 13:50
professionalMycroft Holmes11-May-13 13:50 
QuestionQuestion Related Database transfer Pin
shubham Dev10-May-13 22:09
shubham Dev10-May-13 22:09 
AnswerRe: Question Related Database transfer Pin
Sandeep Mewara11-May-13 0:31
mveSandeep Mewara11-May-13 0:31 
QuestionNo new tables in database after executed query Pin
Member 991209110-May-13 13:50
Member 991209110-May-13 13:50 
AnswerRe: No new tables in database after executed query Pin
JammoD8710-May-13 22:36
JammoD8710-May-13 22:36 
GeneralRe: No new tables in database after executed query Pin
Member 991209111-May-13 4:51
Member 991209111-May-13 4:51 
QuestionER Diagramming Tools - which one to use Pin
ole.Grossklaus@gmx.de10-May-13 3:37
ole.Grossklaus@gmx.de10-May-13 3:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.