Forum Replies Created

Viewing 15 posts - 16 through 30 (of 46 total)

  • RE: report performance with stored procdure

    In the sp we are doing a bunch of statistics related aggregations on user and date, so it was repeatedly querying the same tables, and many times the same records...

  • RE: SSRS: Display mre than first row

    I would like the table to display all four fields or however many the query returns dependent on the parameters however it only display the first field.

    Do you mean "display...

  • RE: Toggle Between Single and Multivalued Parameter

    Requirements. Gotcha.

    I don't have an elegant solution, but you could add both a single and a multi parameter to the report and make them both nullable. Then in...

  • RE: Dataset parameters disappearing any time changes are made to SQL

    I too have had that problem, and all I've been able to determine is that RS gets stupid from time to time.

    If you are certain your parameters are...

  • RE: Toggle Between Single and Multivalued Parameter

    Out of curiosity, why would you need to switch btw single and mult? Can't your users just select a single value from the multi-value dropdown?

  • RE: OUTER APPLY performance

    Thanks for the help people. I'll have to compare the two methods once we get the database fully loaded, but right now the left outer joins are a bit...

  • RE: OUTER APPLY performance

    My employer doesn't permit me do that (the object names in the sample are fake). Looking at the execution plan the two biggest cost % are an index scan...

  • RE: Being More Productive

    I feel that since getting a second monitor at my workstation, I have become more productive. It is just so convenient to have multiple things open at once. ...

  • RE: Union Benefits

    I think unions are great! Sometimes there are record sets you just can't join..:D JK

    As a couple of peole have stated, the American auto industry is exhibit A as...

  • RE: Import .dbf files in sql server 2005

    I've never done this, but you might be able to use OPENROWSET() to select from your DBF file and stick that in a view.

  • RE: Importing from an Excel Spreadsheet

    latingntlman,

    An FYI that made me nuts the first time I had to import Excel to SQL. Excel uses Unicode data types for text fields, so in the SQL table...

  • RE: Execute process task

    If you are executing the dtsx package as a sql job, make sure that the credentials under which the job is running have modify permissions on the folder in which...

  • RE: Import .dbf files in sql server 2005

    I just wanted to throw out an FYI that tripped me up with something similar to this. We are running 64 bit servers and there is no 64 bit...

  • RE: T-SQL Book

    I have a copy of SQL Server 2005 T-SQL Recipes (Wrox) that has tons of code samples for just about everything. The samples are really basic though, but give...

  • RE: The Best Computer

    ...does anyone remember that show Small Wonder? It just popped in there, and I couldn't keep it to myself.

Viewing 15 posts - 16 through 30 (of 46 total)