Last month Name and Year in a SSRS expression

by hussainahmadmd

SQLServerCentral.com

DATEADD

Show the last month and year in a expression, based on a parameter called asofdate. Must format Date Month Year

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.33 (3)

Log in or register to rate

You rated this post out of 5. Change rating

2011-11-08 (first published: 2011-10-11)

8,849 reads

Discuss

Blogs

A New Word: Dolonia

dolonia – n. a state of unease prompted by people who seem to like...

Ways to land data into Fabric OneLake

Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...

A Very Cool Benefit in SSMS 21

I saw a post from Erin that Preview 2 is available. I’d gotten a...

Read the latest Blogs

Forums

Filter a SQL Server Audit with a predicate

By michal.lisinski

Hi Gents, Silly question, but it's been a long time since I've done this....

How to speed up this query?

Hi everyone I have a query that is taking a real long time. It...

The New Log File

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New Log File

Visit the forum

Question of the Day

The New Log File

I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:

USE [master]
GO
CREATE DATABASE [TDE_Primer] ON 
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' )
 FOR ATTACH_REBUILD_LOG
GO

How big is the new log file?

See possible answers