Search Results: query

• 
  Can a SSRS report serve as a datasource for another SSRS report?

  I think Brian said it all. Let me just aware you when you say this: Christian said: Is it possible to combine reports (or at least data from the reports) from both sources (SQL and Oracle) onto a single "dashboard-type" report? Or is an rdl limited to one

  Author:  marcoadf     Date: 1/4/2012     Section: Forum

  tags : multipe, query, reports
• 
  Dump MDX OLAP Query output to a relational table from SSMS

  I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.

  Author:  artuladhar     Date: 5/16/2012     Section: Blog

  tags : dump, file, MDX data, OLAP, output, query, Table
• 
  Scheduled Reports and the Select All parameter

  Hi lduvall. That can be done in the report itself. Your parameter should be configured to: - Tab General: Allow multipe Values - Tab Available Values: Get values from a query and dataset should be mapped - Tab Default Value: Get values from a query and da

  Author:  marcoadf     Date: 1/10/2012     Section: Forum

  tags : automatic, automatically, available, data drive, Default, dynamically, parameters, report, subscription, Subscriptions, values
• 
  INTERSECT and EXCEPT operators

  *Edited: Videos already available: http://www.sqlshare.com/IntersectOperator_786.aspx http://www.sqlshare.com/Exceptoperator_787.aspx Intersect and Except operators, operates on table expressions producing the intersection and difference, respectively. Th

  Author:  marcoadf     Date: 6/9/2010     Section: Blog

  tags : diference, diference between resultset, EXCEPT, marcoadf, INTERSECT
• 
  Troubleshooting MDX Queries

  In this post I am going to deviate from Hadoop and HDInsight to focus on SQL Server Analysis Services Mutli-dimensional and more specifically MDX queries. As a consultant one of the common issues I encounter more so than design is that of performance. Typ

  Author:  cprice1979     Date: 12 days ago     Section: Blog

  tags : Analysis Services, Performance Tuning
• 
  Displaying Dynamic Columns in SSRS Report

  Hi Vijay. You are almost there. In the project parameter I would just add the filter type to user tables as below: SELECT name FROM sys.tables where type='U' column parameter is OK for me. Can you add to the post, the query that you've build to display re

  Author:  marcoadf     Date: 3/6/2012     Section: Forum

  tags : dynamic query, for, path, XML
• 
  Clear SSAS Server Query Cache for MDX Query Performance Testing

  When performance testing your MDX query, you should clear the SSAS server cache so that your queries are not answered from the cache. This could skew your query performance results. To clear the SSAS server cache, you need to use the <ClearCache> co

  Author:  DustinRyan     Date: 10/12/2010     Section: Blog

  tags : clear SSAS server cache, performance test MDX, MDX
• 
  Beginning T-SQL

  Today I have attended the free webinar on T-SQL for SLQ Server from Pragmatic Works. This was a fantastic session by Patrick LeBlanc. Even though I had some experience in T-SQL I have learnt a few new things mostly the new features of SQL SERVER 2008. The

  Author:  indupriya     Date: 2/22/2010     Section: Blog

  tags : Grouping sets, Identity_Insert, Inner join, Left outer join, Right outer join, SQL
• 
  Indexes and their Effect on Query Performance

  Indexes play a huge role in the performance of a query. Without indexes, your very simple query to get the last 100 records from a table could take forever to return. Well, maybe not forever, but you get the point. For example, I have a query and its resu

  Author:  briankmcdonald     Date: 7/29/2010     Section: Blog

  tags : Brian K McDonald, Indexes, Query Performance, SQL Server
• 
  Subq query using report model and report builder

  Hi All, I am using SSRS 2008, SQL 2k8 R2 and Report builder 3.0 From my relational database tables, i have created a report model and using that model to build the reports. in the report model, it looks like if we need to create a very simple report with

  Author:  user396564     Date: 1/9/2013     Section: Forum

  tags : Report Builder, report model, SSRS 2008 R2, subquery
• 
  Comparing Previous Rows in SQL

  Comparing Previous Rows in SQL I had a client recently that needed me to get the direction a student’s GPA was headed on a regular basis. To do this I needed to get the last GPA record on the table and the previous GPA. The dates on these rows were differ

  Author:  MikeDavis     Date: 4/1/2011     Section: Blog

  tags : common table expressions, cte, PREVIOUS ROW, SQL
• 
  Dynamic SQL and Cached Query Plans

  Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using dynamic SQL statements can’t be reused by the query optimizer. So, this morning, I thought about testing it out and finding out if dynamic SQL state

  Author:  briankmcdonald     Date: 8/29/2010     Section: Blog

  tags : Cached Resultsets, Dynamic SQL, SQL Server, TSQL
• 
  Database Schema changes in every environment

  So if I understand the setup correctly, you currently have DFT's using the following source query (example) SELECT a,b,c FROM [DEV].[table] and then if the package is in QA the query should be SELECT a,b,c FROM [QA].[table] and finally prod SELECT a,b,c F

  Author:  sqlchicken     Date: 7/26/2011     Section: Forum

  tags : Configuration, SSIS expressions, ssis variables, ssis
• 
  Top 3 Simplest Ways To Improve Your MDX Query

  Learning to write MDX is difficult enough, but learning to write efficient MDX and performance tune an MDX query can be even more of a challenge. With that thought, I wanted to put together a few tips that can help you improve the performance of your MDX

  Author:  DustinRyan     Date: 3/29/2012     Section: Blog

  tags : MDX IIF function, MDX Performance, Named Sets
• 
  Replace Your Aggregate Transform With T-SQL

  This article covers some of the basic T-SQL aggregate functions. It is a great way to replace the Aggregate Transform in SSIS and improve SSIS package performance.

  Author:  BradSchacht     Date: 8/24/2010     Section: Article

  tags : Aggregate, COUNT, MAX, MIN, T-SQL
• 
  Automatically open a New Query window in SSMS

  If we are used to the Query Analyser of SQL Server 2000, we might find it frustrating that the query window does not automatically come up when you start SSMS. You have to either press Ctrl+N or Click on New Query to start it up. Here is a way to start up

  Author:  indupriya     Date: 7/29/2010     Section: Blog

  tags : Query window, SSMS
• 
  Need help with MDX - SSRS

  Hello people, Goal : Remove all levels above the specified user access level. Example : I have a user in the where clause who has access to district 3717. Under that district, there are few departments (blacked out in the picture). I am trying to make a q

  Author:  Anon     Date: 10/4/2012     Section: Forum

  tags : cube, MDX, sql server, SSAS 2008 R2, SSRS 2008 R2
• 
  Parameterize Query Against Linked Server With OPENQUERY()

  OPENQUERY() allows you to execute a query against a linked server. But what happens if you need to pass a parameter variable into your query against your linked server? MSDN would tell you that OPENQUERY does not accept variables for its arguments, but th

  Author:  DustinRyan     Date: 11/9/2010     Section: Blog

  tags : parameterize openquery()
• 
  Reporting on an SSAS Cube with SSRS 2008

  In this article, Dustin gives you an introduction on building a report on a cube using the MDX Query Designer.

  Author:  DustinRyan     Date: 5/7/2010     Section: Article

  tags : MDX query, MDX query designer, SSRS cube report, SSRS 2008
• 
  Parameters

  I have a huge dataset so I have parameters for 6 of the fields. The user may want to fill all or 1 of the parameters with a selection criteria. How do I write the query to return all of the data from a field even when the parameter is not filled in. Is it

  Author:  syale     Date: 9/15/2011     Section: Forum

  tags : filters, query
• 
  Notes on Parameters in SSRS Session

  Last weekend, I presented a session on basic parameters in SSRS at SQL Saturday #38 in Jacksonville. First off, I would like to thank everyone who attended. I just wanted to go over a few notes from the presentation. Always use parameters in your reports.

  Author:  ShawnHarrison     Date: 5/11/2010     Section: Blog

  tags : parameters, SSRS, SQL Saturday
• 
  Writing Parametrized MDX for Reporting Services

  In this article, you will learn how to write your own MDX inside of Reporting Services and actually add parameters to the your query. No longer will you be forced to use the Query Designer!

  Author:  DevinKnight     Date: 9/30/2010     Section: Article

  tags : MDX, SSRS
• 
  Making SSIS Lookups Dynamic and Parameterized

  In this article by Brian Knight, you'll learn how to make the Lookup Transform dynamic in SQL Server 2008. He shows you also in SQL Server 2008 how to use the Cache Transform.

  Author:  BrianKnight     Date: 12/21/2009     Section: Article

  tags : expressions, lookup transform, ssis
• 
  MDX Parameter Suppress Auto Update

  I discovered this issue the other day while creating a report from a cube. I used the query designer to build a report with a few parameters. The query designer did a great job of building the MDX for me but the client wanted something a little bit more c

  Author:  ChrisAlbrektson     Date: 10/26/2010     Section: Blog

  tags : MDX, Parameters, SSRS, SuppressAutoUpdate
• 
  Why Query When You Can LINQ

  Why Query When You Can LINQ INTRODUCTION TO LINQ LINQ is a abbreviation for Language Integrated Query, Which is just a fancy way of saying in that while in .net code you can write out your queries as if it were as simple as any other statement in you nati

  Author:  Bevans     Date: 4/27/2010     Section: Blog

  tags : LINQ, SQL Scripting, C#