SQL Server Cursor,change qty of a column when the time is starting from midnight

• sriramadevi.nanduru

  SSC Enthusiast

  Points: 132

  More actions

  January 19, 2022 at 10:07 am

  #3974601

  We need to update the qty when the timestart is from midnight only,anything before should change to midnight time and accordingly the qty value should change.

   

• Michael L John

  One Orange Chip

  Points: 27055

  More actions

  January 19, 2022 at 1:42 pm

  #3974673

  This is little to go on. We cannot see your system.

  Can you provide something more?  A sample query?  A table structure? Sample data?

  See the link in my signature on how to get better answers faster.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/