Search results for query: *

Thank you : ) That worked when I removed the # (or changed it to ##). I don't do the temp table building often enough...

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...

Okay, just a head's up. I did add a grouping as the request was modified to be the Top 20 Flights for each "Department". Unfortunately, the recordnumber solution suppressed after 20 detail lines period. So, I used Chelseatech's formula, with an additional "ResetCounter" formula added (to...

Perfect and simple. Thank you!

Yes, you are correct in "what is should look like" and I had added that in an addendum reply to my own posting. This is from a T&E accounting extract and I don't think it pushes the flight number out as the General Ledger doesn't need that much detail, but I will look for another identifier...

Sorry, please ignore the second and last line Evans, Chris $2,300 on the "how it should look" : )

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...

Thank you LBASS - I went back and retried with this methodology and it worked perfect! T.

LBASS - Thanks for your time in responding! Unfortunately, I did have to add the SQL view, so the report is working okay. Just for follow-up and out of curiousity...I had already created a the Maximum on the job position code at the Generic Position Group Level a) as a Running Total Field and...

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...

Raja - I don't want to promote a product, but I see that Ido responded and I have to give total Kudos to his product Visual Cut (www.milletsoftware.com) as it is an inexpensive solution which allows for me to automatically run the single report but it breaks out the reports by Departments and...