Stack Overflow
Stack Overflow

Questions tagged [query-designer]

37 questions
0
votes
0 answers

MS Access Query Designer Best Way To View SQL Server Tables

I have to write many complex queries involving MS Access tables joining SQL Server tables. To write the queries quickly it would be helpful to be able to add SQL server tables from the show table dialog box in the query designer. Apparently I have…
Art
  • 19
  • 3
0
votes
1 answer

Simple SELECT Query is resulting in Cartesian Join?

I have a somewhat simple query where I am returning 4 fields: [Year], [ServiceCredited], [Salary], and [CoveredEmployer]. Using Table1, I can retrieve first 3 fields, but I cannot get the [CoveredEmployer]. To get the [CoveredEmployer], I have to…
Analytic Lunatic
  • 3,853
  • 22
  • 78
  • 120
0
votes
0 answers

Query Designer in VS 2010 causes Attempted to read or write protected memory. This is often an indication that other memory is corrupt

I have a problem calling the query designer in visual studio 2010. My shared datasource points to an local SQL Server 2012 with an simple Test-Database containing one table. When i want to open the query designer i get the following problem: After…
Daniel W.
  • 449
  • 10
  • 29
0
votes
0 answers

Visual Studio 2013 Query results multi-line

I'm connecting to a MySql database inside Visual Studio 2013. I run a query and I have a grid with the query results. In the table, I have some fields with multiline values. The grid result can't show this multiline fields. EDIT: I have a record…
J19
  • 667
  • 2
  • 10
  • 27
0
votes
1 answer

MS SQL: Execute truncate if record count over N

I have a table that is a feed from another database that is pulled. Frequently enough the source database tables are not populated since the feeds are down. What I would like to do is simply perform a count of the number of records in the source…
Dave
  • 1,823
  • 2
  • 16
  • 26
-1
votes
1 answer

How do I properly add this query into my existing query within Query Designer?

I currently have the below query written within Query Designer. I asked a question yesterday and it worked on its own but I would like to incorporate it into my existing report. SELECT Distinct i.ProductNumber ,i.ProductType …
user17482884
  • 3
  • 1
-2
votes
1 answer

what should be order of YEAR() MONTH() DAY() in a tsql where clause?

What should be the order of YEAR DAY MONTH in a where clause of tsql? Select * from TABLE_NAME WHERE YEAR(COLUMN_NAME)=YEAR(GETDATE()) --1 and DAY(COLUMN_NAME)=DAY(GETDATE()) --2 and MONTH(COLUMN_NAME)=MONTH(GETDATE()) --3 Does the order improve…
Som
  • 460
  • 1
  • 5
  • 11
1 2
3