User Profile

Collapse

Profile Sidebar

Collapse
Eddywardo
Eddywardo
Last Activity: Sep 1 '06, 01:14 PM
Joined: Aug 29 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Eddywardo
    replied to Distinct
    in SQL Server
    hmm still not working
    See more | Go to post

      Leave a comment:

    • Eddywardo
      replied to Distinct
      in SQL Server
      ok thanks, i'll look into that.

      Like above because of syntax differences, this no longer works and the page does not display:

      "Select * from Events where Format(EventDat e,'yyyymmdd') >= " & FormatDate(Now( ),"YYYYMMDD") & " order by EventDate asc"

      I'm pretty sure it has something to do with Format(), but I'm a little unsure. Any ideas?

      Thanks!
      See more | Go to post

        Leave a comment:

      • Eddywardo
        started a topic Distinct
        in SQL Server

        Distinct

        Hi, I've recently moved a site to MSSQL server from Access and I've hit a few problems as it implements SQL differently. I've had a lot of duplicate data on the site which I have partly remedied by using SELECT DISTINCT - though I don't know how to use this in conjunction with SELECT * to cure other parts of my site that return duplicate data. Does anyone know how to do this? Thanks!
        See more | Go to post
        No activity results to display
        Show More
        Working...