ST Alpha - "SQL Oddity: I have a query I built in Access, then created into a View in SQL Server Manager. I run the query in SQL Server: data is good. Run the" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 161

SQL Oddity: I have a query I built in Access, then created into a View in SQL Server Manager. I run the query in SQL Server: data is good. Run the

Posted by JaxSean (aka JaxSean) Feb 17 '10, 13:54

original in Access: data is good.

Create a link table in Access to the View in SQL Server Manager: I get screwed up data. (Borrower's name shows up twice instead of Borrower and CoBorrower.)

It's a head scratcher for me. Why would they be different? I'm essentially running the *same* query by running the linked view/table....right?

Responses:

are you getting duplicate records because of your links? nm -- nm - groiny Feb 17, 14:04 1
- I don't think so. It should "run" the View query on the SQL Server before returning the data, I would think...here's the sql: - JaxSean Feb 17, 14:15
data *are* good -- nm - grammar beyatch Feb 17, 13:57 5
- *IS* - Danedukenuuk Feb 17, 14:15 4
  - singular data = datum -- nm - poochinski Feb 17, 14:16 3
    - it's a technical term - Danedukenuuk Feb 17, 14:18 2
      - pixie is technicaly a numbnut. -- nm - JaxSean Feb 17, 14:20 1
        
        this is actually true -- nm - Danedukenuuk Feb 17, 14:21

Post a message top

SQL Oddity: I have a query I built in Access, then created into a View in SQL Server Manager. I run the query in SQL Server: data is good. Run the

Replies are disabled on threads older than 7 days.