Search results for query: *

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

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

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

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

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

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

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/

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

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

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/

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

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

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

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

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/

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

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/

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

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

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