Stack Overflow
Stack Overflow

Questions tagged [query-designer]

37 questions
5
votes
1 answer

Query designer in SSMS and order of join sequence?

SSMS has a query designer, which I usually avoid, because honestly, I can't really work with it. Unfortunately, my colleagues do. As I have 30 minutes to spare, I finally want to know whether I am the problem or SSMS. For example: Let's assume we…
Stefan Steiger
  • 78,642
  • 66
  • 377
  • 442
3
votes
2 answers

Filter member properties in Query Designer using MDX

How can I filter two member properties using MDX? Currently I have the following solution. It works but I'm sure an MDX query would be much more efficient. The Dataset in Query Designer has the following MDX to include the member properties as…
krynil
  • 233
  • 2
  • 5
  • 18
2
votes
2 answers

Can I disable Query Designer in Visual Studio in favor of plain SQL editor with highlighting?

I hate the standard Query Designer window that comes up when you select New Query on a data connection in Server Explorer. I'd much rather have a T-SQL Editor come up. Is this possible? Maybe not replace that functionality but a shortcut key or…
Dan Abramov
  • 264,556
  • 84
  • 409
  • 511
2
votes
3 answers

How to run non-persistent queries in Visual Studio

When using the Query Design feature in Visual Studio, any queries that I run on a SQL Database or Microsoft Access Database while testing are persistent. Meaning they actually change the data in the table(s). Is there a way to make the queries…
Bmoe
  • 888
  • 1
  • 15
  • 37
1
vote
1 answer

How do I select a specific column based on a variable in a MS Access query?

I have a large table with the following fields: Date Product_ID AmountEUR_Field1 AmountEUR_Field2 AmountEUR_Field3 AmountEUR_Field4 AmountEUR_Field5 where each AmountEUR field represents the sales amount for a product. The reason for having 5…
MOLAP
  • 784
  • 4
  • 13
  • 28
1
vote
1 answer

What is the correct syntax for an MDX Filter Expression when using MTD and QTD functions in SSRS/SSAS Query Designer?

Having used the Query Designer in BIDS to type in straight MDX queries I am now attempting to create similar queries but using the graphical drag-and-drop GUI interface instead. However I am having trouble specifying a syntactically correct MDX…
StrongBad
  • 37
  • 1
  • 7
1
vote
0 answers

Prevent visual studio Query Designer to modify the query before execution

MSDN says that: You can use the SQL pane to create your own SQL statement, or you can use the Criteria pane and Diagram pane to create the statement, in which case the SQL statements will be created in the SQL pane. As you build your query,…
Алексей Владышевский
  • 119
  • 1
  • 7
1
vote
0 answers

SSRS query data partially missing from report

I know a variation of this questions has been asked 100 times but I've tried all options that I an find and wonder if there's something I'm missing. I've tried many of the proposed solutions but can't get it to work. I have a matrix report in SSRS…
Ryan Ward
  • 1,523
  • 4
  • 15
  • 23
1
vote
1 answer

SQL Server 2008 / 2012 - views & sql formatting

Hopefully this is a newbie question. So if I have kind of a long set of selects in my SQL and a couple of sub-selects within my where clause, I'm less than satisfied with the formatting in the view designer, which appears to be the only way to…
Joe G
  • 13
  • 2
1
vote
1 answer

Multiple criteria update query in Access

I created a database to keep track of customer service follow-ups in a call centre environment. My single table has, among others, a Due date field and a Status field (values: 'Open', 'Due' and 'Overdue'). I want to run an update query to…
chose_patente
  • 41
  • 3
1
vote
2 answers

Query works in Query Designer but not in MS SQL Server Report Builder

While using the Microsoft SQL Server Report Builder, I am able to execute a query in the Query Designer and retreive the result. The query has a where clause on dates. select * from table where DB_timestamp > to_date(:StartDate, 'mm/dd/yyyy') and…
Ahmed Faisal
  • 4,397
  • 12
  • 45
  • 74
1
vote
0 answers

How can i make this mdx query in query designer from ssrs?

I have this query which I can execute in SSMS without problem and it shows in descending order. with member [Measures].[YTD Sales] as [Measures].[Invoiced_Am] select [Measures].[YTD Sales] on columns, order([01…
daniel_aren
  • 1,714
  • 3
  • 24
  • 41
0
votes
0 answers

Microsoft Report Builder query designer named pipe errors on different client workstations

I use RB at home to edit reports on a remote report server. I have three different machines at home. On all 3, I log into the report server the exact same way, and on all 3 I can run or edit any report. However, if I try to access the query…
Phil Brooker
  • 1
0
votes
1 answer

How can I define IIf parameters across different records in a table?

I've defined a query that filters out records that are null in a specific field. I'd like to also calculate a query field that returns the type of record that follows the record that was filtered out, if it matches the parameters. The way I thought…
Kyle Barnes
  • 29
  • 10
0
votes
1 answer

Is there a way to only select the first comment imputed for each record?

I have a dataset that consists of CommentDateTime, CommentCode, Comment and CommentKey. There are multiple comments per a CommentCode but I only want the first comment created for each CommentCode to show up in my report. Is there a way to do…
user17482884
  • 3
  • 1
1
2 3