Re: Query Help - Distinct Row with Date Portion of a DateTime

Hi Alex,

I agree with Theo that we can use the CONVERT function in TSQL to achieve
this in a SQL server query. However, your data is in a DataTable.

In this case, I think you have 2 options.

1. Update the data into database, and do the query on SQL server.
2. Write a method that goes through all the rows and selects out the
distinct dates.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

.

Relevant Pages

  • Re: sql server stored procedure
    ... the necessary directory. ... Because this sql server query is already in place & been thoroughly ... archived data no matter what you do in Access. ...
    (microsoft.public.access.externaldata)
  • Re: DTS object model
    ... Can I do validation & mapping, if I use BulkInsert Command in TSQL? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... I want to create a text file connection and set the ...
    (microsoft.public.sqlserver.dts)
  • Re: Access Project
    ... Although I have never worked in an Access ADP I believe you need to use TSQL ... You probably want to replace the IIF() constructs with TSQL CASE function. ... Sql Server BOL has a good explanation and lots of examples. ...
    (microsoft.public.access.forms)
  • Re: DEC TO HEX CONVERSION WHILE IMPORTING
    ... i have created user define function dec2hex in sql server ... 2000 and when i access it using sql server query analyser ... >>WHILE INSERTING INTO TEMP TABLE ...
    (microsoft.public.sqlserver.mseq)
  • Re: Any good, free tools for writing simple stored procedures?
    ... I use SQL Server Query Analyzer most of the time. ... but it does have a debugger, object browser, scripting, graphical query ... from the object browser into the editing window. ...
    (microsoft.public.sqlserver)