How to load the last updated value from sql server 2012

Dec 10 2014 11:44 PM

HI,

this is my table in this i want the last insert sweetname and its total_qty to be displayed .i hve written a query but i can oly get the particular sweet. the qury which i hve used is given below.

Select sweetname , total_qty from SweetStockBalance where sweetname = "Halwa" and date = (SELECT MAX(date) FROM SweetStockBalance where sweetname = "Halwa"

Answers (2)

Storing value in localvariable from dynamic sql in sql

SSIS multiple table loads using single DFT