My goal is to have a temporary table that almost looks like an Excel pivot table with User Access Groups as the Columns across ( with the first column being the Screen Names)
i.e.
Form AP_Entry AP_Supervisor AP_Reporting
Vendor Maintenance X...
We have a new client-server program installed on Microsoft SQL Server 2008 on a Microsoft Server 2008 box. When I log into the Client program on the SQL Server box directly, using my Windows NT authentication, I am able to access the program with no issues. However, I have installed the Client...
I want to show the Top 20 Airfare flight costs for a given date range.
Unfortunately, there is no "summary" needed as I just want the Top N (20) flight detail lines.
Here is a sample of how it should look:
Smith, John $5,600 1/5/2010
Smith, John $4,300 2/1/2010...
Although fairly familiar with DTS, I am struggling with the move to SQL Server 2005 SSIS. If anyone could provide a good book that might help get me going more strongly, I would appreciate it. I am not a programmer, but rather a CPA, SQL 7 Certified, Systems Analyst (guess I am a dinosaur so...
I am using Crystal XI with a SQL Database. I am working on an existing report created by someone else - if need be I can create a view...but it seems like this is a simple request that should be possible.
It is a fairly simple report that shows employees grouped by their "Generic Position...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.