Script to Return Last Weeks Data

I was asked by a customer to create a scheduled weekly report detailing work that had been completed in the previous week (Monday to Friday) I figured they might lose the report or something might happen to stop the scheduler from running it, and I didn't want to have to modify my script to work […]

2003-07-07

127 reads

Blogs

Event Notifications Example

By

Event notifications are kinda like a trigger in the sense that they respond to...

Did you know we have another SQL Server book coming out?

By

SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Batch Scripting SQLCMD–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Using sftp in Visual Studio for SSIS packages

By Isabelle2378

Hi, I've inherited the maintenance of SSIS packages that were created by our former...

Merge vs other options

By astrid 69000

Hi, I need to load a table that has 5,000,000 records, I usually use...

Password changes

By Admingod

I would like my SQL users to be able to change their SQL password.Using...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers