.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Query Designer Toolbar

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :Sql Server

I have added the Query Designer toolbar to my Management Studio environment.  After open a new query window this toolbar stays greyed out.  How can I use this toolbar with my queries?


View Complete Post

More Related Resource Links

BIDS Query Designer very slow in VS 2008

I am in the process of upgrading my Report Server projects from 2005 to 2008.  These reports use an Analysis Services 2005 data source and have queries that are anywhere from 20 to 100 lines of MDX.  After upgrading a report, when I open or save a dataset in the Query Designer, it takes up to 20 seconds.  In 2005, this would happen almost instantly. Running SQL Server Profiler, I see that there is an extensive number (600+) of Discover events going on with the Analysis Services server while the Query Designer loads. My version of Visual Studio is 9.0.30729.1 SP and I am running Windows XP SP2. Thanks, Mitch

BIDS Query Designer very slow

BIDS Query Designer seems to be very slow while saving the query or opening the query designer when you've got quite a lot of Query Parameters. When I remove all the query parameters, the query designer seems to be running smoothly. Editing a query with about 10 to 15 query parameters takes ages this way! Is there something I can do about this?!

MDX works fine in SSMS but not in query designer

Hi all,   I am trying to include this query in my query designer in SSRS. The query below is as follows:WITH MEMBER [Time].[Fiscal Month].[All].[ Subtotal] AS ' AGGREGATE( EXISTING { [Time].[Fiscal Month].[All].CHILDREN }) ', SOLVE_ORDER = 1000  SELECT NON EMPTY { { { { [Time].[Fiscal Month].[All].CHILDREN }, { [Time].[Fiscal Month].[All].[ Subtotal] } } * { { [Measures].[SKU Distinct Count] } } } } ON COLUMNS , NON EMPTY { [Sales Force].[Retailer Code].[All].CHILDREN } ON ROWS  FROM [Sales]CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL The error i am getting isThe query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension..Please let me know where am i going wrong.Thanks and regards,ram

Query Designer question

I am not sure where to post this question, so I guess it is here: I have a VERY large query that joins quite a few tables. I am using the graphical designer to get the tables all linked together. However the graphical designer seems to place the order of the tables in a random order resulting in a hodge podge of left and right joins.   In the graphical designer, is there a way to order the from clause?

Query Designer - Pane - Results grayed-out?

In Query Designer, right click, select pane -- the option for Results is unavailable (grayed-out)?

SSRS Query Designer (in BIDS) does not generate ANSI SQL

Hello, I have a problem when using SQL Server 2005 BIDS (Business Intelligence Development Studio) when connected to an Oracle data source.  The Query Designer generates the old Oracle SQL syntax instead of ANSI SQL.  This is with the Oracle 10g client installed. So, I would really appreciate it if anybody knows how to get the Query Designer to generate the ANSI SQL.   Thanks, Stuart

Generic Query Designer displaying non standard syntax

I've just discovered a problem with the Generic Query Designer on my machine. When I do a simple join of two tabels it does not display in the SQL pane as standard syntax, so instead of SELECT a.1 from ainner join b on a.1=b.1It does SELECT a.1from a, bwhere a.1 = b.1I am doing this against an oracle 10g database, it will run the query, but I want the query designer to out put at standard SQLI am presuming that it is a setting in SSBIDS, but I don't know why it is doing this. Any suggestions?

Adding a table or view multiple times when building a query with BI Report Designer and Report Build

How can I add a table/view multiple times to a single query by using BI Report Designer or Report Builder 3.0? In Report Designer I managed (workaround) to add one table multiple times by creating multiple Named Queries and having the same SELECT. Still I don't know how to add one table multiple times in Report Builder 3.0.

Report Builder 3.0 for Oracle with Graphical Query Designer

Is there a possibility to have Graphical Query Designer in Report Builder 3.0 in case the connection is made to an Oracle database (through .NET Provider for Oracle for example)? I need to offer to the end users the means to build their own reports. Every user has associated a group of database objects and as soon as users are added new database objects are added. Therefore I cannot create a model because it needs to be changed frequently and the model in this case would contain objects to which the user does not have access. The only option is that the user should create his report query in a friendly manner. So the query text editor is of no good in this case.   I've found in documentation that for Oracle and other databases there is no Graphical Query Designer: In Report Builder 2.0, to specify a query for data source types Oracle, OLE DB, ODBC, and Teradata, you must use the text-based query designer (http://msdn.microsoft.com/en-us/library/dd220607(SQL.100).aspx). Is there a way to have Graphical Query Designer in Report Builder 3.0 or should I look for other products? In case Report Builder cannot solve this problem can you make some product recommendations - ad-hoc web reporting for .NET?

Sharepoint designer 2007 - Java date query - and how to disable value required for hidden fields


Hi guys,

created a list, i've managed to get field to hide and dates to populate into the applicable fields, I just have 2 queries taht I need some help with

>I need to work out how to get var tmoz to ignore saturdays and sundays - i.e. if request is raised on fri - it would default to the following mondays

>I need to work out how to mark a field as no input required if it is hidden, and input required if visible (urgent change justifacation)

 Below is the current java i'm using

<script type="text/javascript">
  function hideFieldsOnStart()
   //hide the control at start
   var control = getTagFromIdentifierAndTitle("input","TextField","Urgent Change Justifacation");
   var control2 = getTagFromIdentifierAndTitle("input","DateTimeFieldDate","Proposed Implementation Date");
   //add an onchange event to the dropdown
   getTagFromIdentifierAndTitle("select","DropDownChoice","Change Type").onchange = function() {ChangeEvent()};

Master Data Services, SSRS, and the Query Designer.


Hey everyone,


For the most part, I have this thing figured out; however, I now need to assign to a property of a method's parameter a collection of member types.


Here is my query (I have emboldened the segment of the query which my question is directed towards):


          <Method Namespace="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09" Name="MetadataGetRequest">


          <Parameter Name="ResultOptions" Type="XML">





 <Parameter Name="SearchCriteria" Type="XML">


<MemberTypes attr0="MemberTypeArra

MDX Query In Dashboard Designer


Hi all

I have decided to use Performance Point to Develop My KPI's and i am trying to create a KPI where the actual amount shows the total Number of quotes generated for the current month, My Time dimension is as follows

Time.Year - Month - Date

Member = Sat January 01 2005
Hierarchy Level = Month
Reference Date = 1/1/2005

I have created the KPI but i am unsure of the MDX Statement to return the current month could anybody please help.

i have tried

 [Measures].[Total Quotes],[Time].[Month].CurrentMember but this just returns the total for all quotes



Creating a KPI Using MDX Query In Dashboard Designer


Hi all i have decided to use Performance Point to create my KPI's and i am trying to create a KPI where the actual amount shows the total Number of quotes generated for the current month, My Time dimension is as follows

Time.Year - Month - Date

Member = Sat January 01 2005
Hierarchy Level = Month
Reference Date = 1/1/2005

I have created the KPI but i am unsure of the MDX Statement to return the current month could anybody please help.

I have tried

[Measures].[Total Quotes],[Time].[Month].CurrentMember

but this just returns all the quotes ever generated i have also tried

([Measures].[Total Quotes], StrToMember("[Time].[Year - Month - Date].&["+CStr(Format(Now(),"yyyy-MM-dd"))+"T00:00:00]"))

but this returns nothing



difference running from query designer to report preview


So I have a simple query and parameter in query designer and I run it and it does what I expect.  This is a simple test query/report and I'm just trying to learn how to get parameters working like I'd like.  The single parameter is there to filter by year-month ...and it does in designer.   When I go into report preview, I get the parameter list of values I expect but wne I go "view report" I get:

Query execution has failed for dataset "GetInfo".

Query (1,72) the restrictions imposed by the CONSTRAINED flag in the STRTOSET were violated.

Here is the dataset for GetInfo (which runs in designer):


And here is the dataset for the parameter:

 {} ON 0, NONEMPTY([Pay Date].[Year-Month].Members, [Measures].[Pay Amount])
ON 1 FROM [Pays Data] 

I did change the generated dataset on the parameter since by default it would list all the year-month combinations

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

How to Encrypt Query String Parameters in ASP.NET

Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt

SharePoint Designer

This video series shows you how to quickly and easily build complex business solutions on the SharePoint platform. Microsoft Office SharePoint Designer 2007 Business Administrator Training is a one-and-a-half hour, 300-400 level training series, produced in collaboration with the SharePoint Product Team and Total Training
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend