User Profile

Collapse

Profile Sidebar

Collapse
Joe Willis
Joe Willis
Last Activity: Oct 11 '10, 07:38 PM
Joined: Oct 11 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Joe Willis
    replied to MS Sql Server Express vs. Visual Studio? Embedded DISTINCT functionality?
    in SQL Server
    I'm sorry NeoPa, I couldn't find my original post before registering.

    Code:
    
    SELECT   Count(*)
    FROM     (
        SELECT DISTINCT [SNO]
        FROM   [Shipment]
        )
    I had tried this aswell. Didn't work in sql express 2008.


    On a side note, both of the above queries work in visual studio.
    See more | Go to post

      Leave a comment:

    • Joe Willis
      started a topic MS Sql Server Express vs. Visual Studio? Embedded DISTINCT functionality?
      in SQL Server

      MS Sql Server Express vs. Visual Studio? Embedded DISTINCT functionality?

      I've been having issues running certain commands in Sql Server Express 2008.

      One of the specific commands in question looks like this:

      Code:
      SELECT COUNT(DISTINCT Sno) as NumberShipping
FROM SHIPMENT;

      This commands works perfectly in visual studio 2008, but I get an error in sql server express.

      The error is:
      There was an error parsing the query. [ Token line number = 1,Token line offset...
      See more | Go to post
      Last edited by NeoPa; Oct 11 '10, 03:59 PM. Reason: Please use the [code] tags provided.
      No activity results to display
      Show More
      Working...