Andrew Poulter

User Defined Function for Padding Numbers

This scalar udf takes three parameters @Number INT, @Length INT, @Position CHAR(1) and returns a VARCHAR(50) string which pads @Number with zeros to the specified @Length either to the right or to the left, according to @Position ('L' or 'R').E.g. SELECT dbo.udf_PadNumber(5, 6, 'L') returns '000005' whereas SELECT dbo.udf_PadNumber(5, 6, 'R') returns '500000'. The function […]

2006-03-13 (first published: )

128 reads

Last Day of Month

A script was recently published (Last_Date_Of_Month) that returns the last day of a given month/year combination. I have simplified and improved on that script by eliminating the need to use a WHILE loop. This new script exploits the flexibility of the DATEADD function which allows you to assign negative numbers (thus effectively subtracting a given […]

2004-09-30

144 reads

Blogs

Custom deployment parameters in Azure Data Factory - Forget Me Not

By

(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...

VMworld 2020 – Top 10 Database Sessions (Part 2)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 25 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

multipoint to line geometry

By lpro

Hi, Attached, I exported a CSV file from a multipoint record from sql server ...

Using SSIS packages build in VS2010 when migrating SQL server from 2008 to 2016

By blom0344

With eof of Windows2008R2, lots of our customers are planning new server setups, usually...

SQLServer Agent not sending dbmail on job completion

By maxo85

Hi Everyone! I have a problem with a SQL Server 2017 with dbmail. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers