Re: help

Hi Suessmeyer

thanks for u r reply.
U r solution is good
can i get my result as column to the existing table(#Tempone ) that is
an update statement instead of select
ofcourse we can add column thru alter syntax

Hope U understand

Thanks & Regards
kalyan

.

Relevant Pages

  • Re: help
    ... Also how should we handle division by zero errors in u r case ... Thanks & Regards ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • RE: Using Date as one of the field in Access
    ... I guess the update statement did not work as I checked my date field which is ... Regards. ... I changed my update code as: ... Now when I am tring ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ELSE UPDATE
    ... Regards ... > Being that DATEADD returns a datetime, then the only way for the IsDate to ... >> going through the update statement. ... @StartDate) ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger For DateTime
    ... Awesome Erland, thanks that's what I was looking for! ... I've never seen a FROM / JOIN on an update statement before. ... you could alias the table to save typing? ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Cool Query Analyzer Trick
    ... update statement, press Ctrl-Shift-M... ... Jacko ... Prev by Date: ...
    (microsoft.public.sqlserver.tools)