We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT Period_End_Date AS MthEndDate , DATEADD(mm, DATEDIFF(mm, 0, Period_End_Date), 0) AS MthStartDate , DATEADD(yy, DATEDIFF(yy, 0, Period_End_Date), 0) AS YearStartDate , DATEADD(yy, DATEDIFF(yy, 0, Period_End_Date) + 1, -1) AS YearEndDate FROM [KLL AR Periods - Vertical] WHERE ( AR_Period = '201607' );
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|In SQL 2000 combine mulitple rows into a single row seperated by a semi colon||10||40|
|Update the value of table B with value of table A tables inner join||6||76|
|T-SQL to copy a database||37||66|
|How can I delete dublicated rows by using for loop in SQL?||2||17|