Stack Overflow
Stack Overflow

Questions tagged [query-designer]

37 questions
0
votes
1 answer

How to display data from 4 different tables - Query Designer

I need to build my query using SQL Server Management Studio Query Designer I need to display a concatenated string of tbl_B.Name + tbl_C.Name + tbl_D.Name, if Id in tbl_E/tbl_User is equal to UserId in tbl_A This is the Table structure…
Chloe
  • 73
  • 9
0
votes
1 answer

Pass combobox value as a comparison operator in access query?

I have a form with a combobox "cmb1" and a textbox "txt1". the combobox can be empty or can hold a comparison operator ">" or "<" or "=" without the quotes while the value of the comparison can be entered in the textbox txt1 as shown in the picture…
Kurrapica Zoldik
  • 27
  • 1
  • 9
0
votes
1 answer

Query designer returns an unwanted entity field

I have a Reporting Services Project on SQL Server 2008 R2. The point is to provide users with a data model they can use as a data source for Report Builder 3. So I have created my data source views as usual and then the Report model with no…
Bonzay
  • 740
  • 2
  • 10
  • 29
0
votes
1 answer

SCCM User Collection Query: user=inADGroup & software=Installed

I would like to write a query for a user collection in SCCM. Our IT department would like to work with three different user collections per software package: [softwareName] - Installed [softwareName] - to Install [softwareName] - to…
bertvo
  • 75
  • 2
  • 9
0
votes
1 answer

parameters in builder report from dataSet list in sharepoint

I use SharePoint 2010 list as data source from SQL Server Report Builder 3.0. now I want to create Multivalue Parameters from fields in my dataset how can I do it?
Shachar
  • 1
  • 3
0
votes
1 answer

Set default Zoom Window font size in Access 2016 query designer?

Does anyone know if there's a way to set the default font size for the Access 2016 Query Zoom window? I often use the Zoom window when editing lengthy/complex expressions. I can set the zoom window font size but it only "sticks" for the current…
ashleedawg
  • 20,365
  • 9
  • 72
  • 105
0
votes
2 answers

Open SQL Query Designer in SQL Server Management Studio 2008

How can I open the SQL Query Designer in SQL Server Management Studio 2008? I cannot find it.
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
0 answers

SSMS: Bit column defaults to Expression when Group By is desired

(Tested in SSMS 2005 & 2014) When I have a table or view open in Query and View Designer and I turn the Group By feature on, any bit columns defaults to Expression. Is there any way to change this (by options/settings, registry tweak, or other) to…
InigoMontoya
  • 49
  • 5
0
votes
1 answer

Using SQL Query Designer Pros and Cons

I've seen many developers using SQL Query designer to build queries rather than writing it from scratch. What are the pros and cons of using SQL query designer instead of writing manual queries ? How it effects for optimizations and maintenance of…
tarzanbappa
  • 4,930
  • 22
  • 75
  • 117
0
votes
1 answer

Ms Access SQL: Concatenate seperated by commas one to many relationship

With the following kind of table: tblRequest -RequestID(double) -RequestDescription (String) tblError -ErrorID(long integer) -ErrorName(String) -RequestID(double) The above relationship is a ONE to MANY relationship. I want to VIEW the data in…
Haris Ghauri
  • 547
  • 2
  • 7
  • 27
0
votes
1 answer

Sql query or Microsoft-access query design to present data in the following manner

I am trying to design a query in Microsoft-access which should present the data in the following manner: Car Make Black White Red Total 2-door 4-door Total…
Haris Ghauri
  • 547
  • 2
  • 7
  • 27
0
votes
1 answer

SQL Query for SSRS Report Visual Studio Query Designer

Can someone please help with an SQL Query I am facing. Currently I am using Visual Studio 2013 Query Designer for my SSRS reports and I'm trying to select Students that are enrolled at their current School. However when testing my query for a…
teejay
  • 53
  • 1
  • 4
0
votes
3 answers

Summing multiple values into one table

I have three tables in Microsoft Access: Table1 includes the names of various companies and the corresponding unique ID of each (along with other unique information about the company); Table2 includes sales information for each company from 2013;…
EnsAndBees
  • 73
  • 9
0
votes
1 answer

parsing web service with the hierarchy parameters in xml schema

i need to get data from web service via reporting services. the xml schema i got showing structure as follow: ........
Y.D
  • 95
  • 8
0
votes
1 answer

customize the fields returning from web service using ssrs xml query designer

i have a web service that returns data but i cannot find a way how to choose the fields that returns from the web service. i have param-in that i send to the web service and i'm getting fields parameters as param-out. this is how i'm parsing…
Y.D
  • 95
  • 8
1
2
3