-
Archives
- December 2025
- August 2025
- May 2025
- April 2025
- March 2025
- March 2024
- October 2023
- August 2023
- July 2023
- April 2023
- January 2023
- December 2022
- May 2022
- April 2022
- March 2022
- October 2021
- August 2021
- July 2021
- June 2021
- April 2021
- March 2021
- February 2021
- January 2021
- December 2020
- February 2020
- December 2019
- October 2019
- August 2019
- July 2019
- June 2019
- May 2019
- April 2019
- March 2019
- February 2019
- January 2019
- October 2018
- September 2018
- August 2018
- May 2018
- April 2018
- February 2018
- January 2018
- November 2017
- October 2017
- September 2017
- August 2017
- June 2017
- May 2017
- April 2017
- March 2017
- January 2017
- November 2016
- September 2016
- August 2016
- July 2016
- June 2016
- April 2016
- March 2016
- January 2016
- December 2015
- November 2015
- October 2015
- September 2015
- August 2015
- July 2015
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- December 2014
- September 2014
- August 2014
- July 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- October 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
-
Meta
Monthly Archives: October 2023
Smart way to expand dates for a month in SQL serve query
with D as (select distinct CreationTime MDATE from [jwtest].[System.Activities.DurableInstancing].[InstancesTable]where CreationTime>=’2023-02-01′ and CreationTime<‘2024-02-01’UNION ALLSELECT dateadd(d, 1, MDATE) MDATEFROM D where datediff(m, MDATE, dateadd(d, 1,MDATE))=0)select MDATE from D
Posted in Uncategorized
Leave a comment
j5423 