Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Reply
How to load the last updated value from sql server 2012
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
santhosh kumar
9y
657
1
Reply
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"
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Storing value in localvariable from dynamic sql in sql
SSIS multiple table loads using single DFT