if data not exist on a particular date then how to select the date which is previous and very close to given date in sql server 2008 R2

Asked Jan 31 '14 at 05:06

Active Jan 31 '14 at 06:51

Viewed 68 times

I have a table which have the following fields

Sno  StockDate   PartNo      Quantity    Location
1    22.11.2013  011011011    100        Perungudi
2    24.12.2013  011201120    1000       Kottivakkam
3    1.1.2014    011011011     80        Perungudi

If i need to select datas on 1.1.2014 means i have to list the following datas

Sno  StockDate   PartNo      Quantity    Location

    2    24.12.2013  011201120    1000       Kottivakkam
    3    1.1.2014    011011011     80        Perungudi

that is the stock available on that day is as showed above. i want to know how to i write the select query

edited Jan 31 '14 at 05:35

John Saunders

160,644
26
247
397

asked Jan 31 '14 at 05:06

Guna

Possibly related: http://stackoverflow.com/questions/808356/how-to-determine-values-for-missing-months-based-on-data-of-previous-months-in-t – John Saunders Jan 31 '14 at 05:36
sorry for the late reply. i want to know what is n in firstof month – Guna Jan 31 '14 at 06:04

if data not exist on a particular date then how to select the date which is previous and very close to given date in sql server 2008 R2

0 Answers0