Re: on stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

CLAIM_ID is a giving number (CLAIM #) and the dates are stored in a strange
format: yyyymmdd.

"Adam Machanic" <amachanic@xxxxxxxxxxxxxxxxxxxxxxxxxxx> escribió en el
mensaje news:uajuINczFHA.720@xxxxxxxxxxxxxxxxxxxxxxx
> "Ana" <nospam@xxxxxxxxx> wrote in message
> news:%2373L2HczFHA.460@xxxxxxxxxxxxxxxxxxxxxxx
>>
>> ORDER BY dbo.CLAIMS.CLAIM_ID
>
> You're ordering by the CLAIM_ID; why would you expect this to influence
> the ordering of DATE_OF_CLAIM?
>
> Try:
>
> ORDRY BY dbo.CLAIMS.DATE_OF_CLAIM
>
> By the way, why are you casting the date? Doing so will ruin index
> utilization.
>
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
>
>
>


.

Relevant Pages

  • change date format
    ... Apache by default uses the following format for date: ... is there a module that turn this directly into yyyymmdd? ... Xah ... Prev by Date: ...
    (comp.lang.python)
  • Re: : An iPod question
    ... something built into the format to handle it already. ... Apple may well be that strange though. ... Prev by Date: ...
    (rec.music.hip-hop)
  • Convert Text to DATE
    ... 4,500 observations which are supposed to be in Date Format. ... however when I enter the cell and then click "Enter". ... very strange ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: Convert Text to DATE
    ... Try a custom format instead. ... Type in the format you require. ... very strange ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: format date in java
    ... > Simple java question. ... If my program takes in a date in the format, ... > yyyyMMdd, is there anyway I could output this date in java, in the ... Prev by Date: ...
    (comp.lang.java.programmer)