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: *

  1. Crowley16

    Strange behaviour: include execution plan to improve performance

    I don't know if anyone has ever encountered this strange behaviour, it certainly sounds like like nonsense so am I missing something? Here's the facts: I am writing a query in ssms, reasonably complicated, with temp tables, linked servers and lots of lookup/transformation steps. When testing, I...
  2. Crowley16

    garbage data on first line of SSRS report when exported to CSV

    It sounds like there's some extra stuff in there somewhere. Try creating a completely blank new report and then copying the relevant bits across. Only use a single table control on the report... -------------------- Procrastinate Now!
  3. Crowley16

    garbage data on first line of SSRS report when exported to CSV

    If you have to use ssrs, then check the report to see if there are any other data or components. The export functions try to mimic the actual report in layout, so if you have any extra data say like a header or something, then they may get exported. Have you tried exporting to other formats to...
  4. Crowley16

    garbage data on first line of SSRS report when exported to CSV

    if you're just sending a csv out then do you really need to use SSRS? From what you've described, it seems like a scheduled job running a t-sql script to do everything would be much more straight forward and give you more control over the csv output. -------------------- Procrastinate Now!
  5. Crowley16

    Use of Parameter or Variable in Where Clause

    just to answer your original question, there is a if / else syntax in t-sql, it would go something like: if (@Parameter = 1) begin select something... end else if (@Parameter = 2) begin select something else... end else begin select everything else... end in your situation, it'd be...
  6. Crowley16

    don't return all members

    I've got a mdx query that when run, is returning the all members of each hierarchy level. how can I filter the "All" members out? p.s. The code is adapted from auto generated code, so any pointers for making it better would be appreciated as well SELECT { [Measures].[Actual Sales] ...
  7. Crowley16

    MDX query, normalize output for Matrix Report

    Eureka! I had to right click on the data field to create a static row, and then assign the measure values individually to each new row. Was easier with no measures selected on the wizzard. Thanks RiverGuy, got there in the end :) -------------------- Procrastinate Now!
  8. Crowley16

    MDX query, normalize output for Matrix Report

    Hi RiverGuy I've tried to click on the row or column to add new groups and it only allows me to add dynamic groups, there's no option to "split cells" or to even set up static groups. I'm using SSRS 2005. -------------------- Procrastinate Now!
  9. Crowley16

    MDX query, normalize output for Matrix Report

    Hi RiverGuy, Sorry, I was a bit unclear in my original post. I actually have multiple measures in the full mdx and would like the measures to be displayed per product, i.e. Loc1 Loc2 Prod1 Sale 1.5 2.0 Qty 5 3 Prod2 Sale 2.7 1.4 Qty 1 2...
  10. Crowley16

    MDX query, normalize output for Matrix Report

    Hi RiverGuy, Sorry for the late reply, have been a bit busy. Anyway... Maybe this should be a SSRS question from now, but I've re-configured the measures to be on the columns and the dimensions on the rows, but in a matrix report, how do I actually get the measures to be displayed on the rows...
  11. Crowley16

    MDX query, normalize output for Matrix Report

    I have a standard mdx query, along the lines of: select crossjoin ( Product.[Hierarchy] , Measures.[Measure] ) on rows , Location.Hierarchy on columns from cube however, I'm trying to use this as the source of a SSRS report and SSRS is trying to hard code all the...
  12. Crowley16

    MS SQL DAG Graph

    get rid of the cascade commands -------------------- Procrastinate Now!
  13. Crowley16

    Blocking Process - Blank

    use sys.sysprocesses, there's a sql_handle column in there which can be fed to sys.dm_exec_sql_text to get the full sql being run. Note, the stmt_start and end columns will define the actual section of the sql that's being run, you need to divide these numbers by 2 though...
  14. Crowley16

    Improve performance of delete

    Firstly, you should use the new join syntax. i.e. [code] Delete t1 from dbo.tblTrackingTable t1 inner join dbo.tblTrackingTable t2 on t1.BoxNumber = t2.BoxNumber And t1.FileNumber = t2.FileNumber And t1.TrackingDate = t2.TrackingDate And Where t1.Tracking_ID > t2.Tracking_ID...
  15. Crowley16

    add constraint

    one you your columns needs to be unique, so, just add a unique constraint (index) on one of them, preferably the parent... Oh, just read your question more carefully, no pk AND no unique index... Yeah, that will pose a problem then... just wondering, why can't you add a unique index...
  16. Crowley16

    top 5 like statment

    yeah, your best bet for doing this would be to use the row_number function and then use where to limit the results into pages... -------------------- Procrastinate Now!
  17. Crowley16

    add constraint

    you can add a foreign key relationship between any column in any table, irrespective of whether it's a key or not, as long as the datatypes match. Although you'll get problems if both the columns contain duplicates. -------------------- Procrastinate Now!
  18. Crowley16

    Pop up Message on deployed report

    I've not come across anything like this in ssrs2008 but I've not been using it that long, so may have just missed it. however, you can probably replicate this behaviour by using report redirects, i.e. have your popup message as the report that's accessed by default, and have a link on that...
  19. Crowley16

    Sub query slowing down performance

    without reading through and understanding all your code, as a rule, don't use sub queries, they often kill performance. essentially, you are running a query for every single record returned in your main query, so even if the sub query takes like 1 sec, if your main query returns 10k records...
  20. Crowley16

    Create user stored procedure using username as schema

    dbo is short for database owner, giving users access to this schema allows then to do just about anything to your database... -------------------- Procrastinate Now!

Part and Inventory Search

Back
Top