Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: groleau
  • Order by date
  1. groleau

    Performance

    Wow, I sure did some sloppy typing there. I created a view in the database that returned exactly what the report needed. I am still nevertheless required to type all of the query other than the WHERE clause into the report. And rendering is just as slow as ever. Can't blame it on the query...
  2. groleau

    Formatting of fields in report

    #,###.## -- too intuitive. No wonder I didn't think of it. :-) thanks -- Wes Groleau http://www.Parkview.com/
  3. groleau

    Formatting of fields in report

    I'm sorry, I misunderstood your question about my question. In Excel, we would have used "Accounting" format without a dollar sign. 1,234.56 ( 78.90) 987.65 ( 1.23)as opposed to the SSRS "money" format of$1,234.56 ($78.90) $987.65 ($1.23)in which the '$' and '(' in-line with...
  4. groleau

    Formatting of fields in report

    Thanks! for the MM vs. mm pointer. I wonder why they swapped places in what they've offered Excel and Access users for years. (Congratulations, Microsoft on doing a typical Windows-style screwup in a product that is for the most part unlike the crap you've been known for in the past.) As for...
  5. groleau

    SSIS/SSRS integration/automation

    OK, that subject line stinks, but a better one is too long. I am brand new to SSRS and fairly new to SSIS. I go to class next month, but I'm already having to produce. It was easy to create an SSIS package that works perfectly to load in the data, and an SSRS report to display the data nicely...
  6. groleau

    Scaling to fit to page when rendering to Excel

    ...baffled as to why anyone would want to create a report in Reporting Services, output it to Excel for modification and then use the Excel version" Because the "customers" have used Excel for over ten years and change is scary? -- Wes Groleau http://www.Parkview.com/
  7. groleau

    Formatting of fields in report

    If I paste in a format string that works in Excel or Access, will it work here?" I should have just tried it--the answer is NO. -- Wes Groleau http://www.Parkview.com/
  8. groleau

    Formatting of fields in report

    Had date fields that showed as long date and time (midnight) to the second. Set format in properties to mm-dd-yyyy (hey, it works in Access and Excel!) But what I get (using today for example) is00-13-2007 Then on a money field, I had four decimal places. I managed to get rid of the last two...
  9. groleau

    Performance

    I was not aware that SELECT * was inefficient. Thanks for mentioning it. Downside of listing ALL fields explicitly is that when you have to change the table (Oh, Mr. Programmer, we forgot to include the interest rate on our input file")really want ALL fields, you have to chase down and edit...
  10. groleau

    Next page in report designer ?

    How embarrassing--I posted, went back to the designer and there it was, so blinking obvious I should slap myself. But my aim is worse than my eyes, and I'd probably miss. -- Wes Groleau http://www.Parkview.com/
  11. groleau

    Next page in report designer ?

    For my very first SSRS report, I used the wizard. Put some fields in "page," some in "group," and some in "detail" Judging by the (sub)total lines, the designer is showing me a single page (in fact, I am sure of it). Details show four records and I know there are hundreds, posibly thousands...
  12. groleau

    Performance

    On a large data set, is there any performance advantage to having a view on the server apply some filtering isntead of have the report do it? For example, table S contains two years of services. I put in the reportSELECT * FROM S WHERE GETDATE() - Date_Of_Service < 30Tweak a column width, and...
  13. groleau

    Timing of SSIS packages in Visual Studio

    Had a partially implemented SSIS package in Vis. Studio. After execution (successful), the output window ended saying it took 15.xx seconds. After adding more functionality and getting another successful run, output window does NOT say how long it took. Is that something selectable? I...
  14. groleau

    Two SSIS/BIDS/SQL oddities

    Created an SSIS package in Visual Studio. 1. Last task is SQL. Output window always says "Sucess", Fortunately the red box in the designer told me it wasn't true. Scroll far enough to the right and there's the error message. Unfortunately, it unhelpfully listed several things...
  15. groleau

    Optimizer question

    Thanks. Not worried about concurrency--(input S and update K) is a periodic automation and K is read-only for everyone else. -- Wes Groleau http://www.Parkview.com/
  16. groleau

    Optimizer question

    please show the query" Using the short names from another post:UPDATE S SET A = CASE -- abbreviate name WHEN A LIKE '%subgroup%' THEN 'subgroup' WHEN (list of others) ELSE 'main' -- or use main if no subname present END INSERT INTO K (C, D) SELECT A, B...
  17. groleau

    MERGE missing records - better way?

    Wow, that was quick. I was about to post that maybe I should make a view to show the missing records, and then insert from that. It's not a big enough data set to worry about efficiency. thanks, your syntax is easier to read. -- Wes Groleau http://www.Parkview.com/
  18. groleau

    MERGE missing records - better way?

    table S (input) has columns A, B table K (keep) renames them C, D and adds E Need to add new records if not already there, leaving E null in that case. Seems like there should be a simpler way thanINSERT INTO K (C, D) SELECT A, B FROM S WHERE NOT EXISTS (A, B) IN (SELECT C, D FROM...
  19. groleau

    Optimizer question

    I need to standardize some fields in a staging table before selecting some of them to put in a permanent table. Can I depend on the UPDATE happening before the SELECT or must I say GO between the two to ensure that non-standardized input fields are evaluated correctly in the SELECT ? thanks...
  20. groleau

    tasks fail when loop is added DOWNSTREAM

    SSIS worked fine - loaded five months data in 15 seconds. The problem was that (IMHO) the BIDS designer is buggy and putting the data flow into the loop container involves more steps than it should, not all of them intuitive. But I suspect using xp_dirtree and bulk insert would have taken at...

Part and Inventory Search

Back
Top