CODEWITHSUNDEEP
sqlsql-serverexcelsql-server-2000
Hexxxer
Hexxxer

Reputation: 67

Excel query showing different result than SSMS query

I have had an odd error I cannot explain. Basically, I am running a query to my SQL database using excel and am having non-existent data pop up when it comes to a very particular order in my database.

Here is a simple query surrounding this order:

select * from OR200100 where OR200100.OR20001='0000793605'

Here is the output in EXCEL enter image description here

And here is the same output in SQL enter image description here

what is happening here? How could the same query generate 2 different results?

Upvotes: 1

Views: 854

Answers (3)

Ratsnake
Ratsnake

Reputation: 51

So I had a very similar problem, my query was grouping by week numbers. What I found was that one of the queries had set datefirst 5 set whilst the other didn't. I guess the key thing here is make sure, if you are using any SET operations in your ssms queries, these are identical to those in the Excel query string.

Upvotes: 0

RBarryYoung
RBarryYoung

Reputation: 56735

OK, so it's SQL Server then, that's important because different SQL products can have very different idiosyncrasies and controls.

The next things to check are these:

  1. Is OR200100 a Table or a View? If it's a view then post it's code.

  2. Are you using the same Login/account from both Excel and SSMS?

  3. Are you sure that you are connecting to the same Server and Database? SSMS tells you what you are connected to, but client apps like Excel do not and it is very common for this type of problem to be caused by the app connecting to a Dev or QA version of the database. See here for some of the different ways that this can happen:

Upvotes: 1

Dave
Dave

Reputation: 316

Run SQL Server Profiler against the database if you can, then compare the output to the sql query that you are running in ssms.

Upvotes: 1

Related Questions