Ed.Carden@Westdale.com

  • Interests: SQL Server, VB (old & .Net both)

Technical Article

Build DATELOOKUP table

This script creates a table named DATELOOKUP which is used for looking up date related values. Each record represents date related info about the date in the column dtDate. For example the iMonth column stores the integer value of the month of dtDate and sShortMonth stores the abbreviated name of that same month. Use this […]

5 (1)

You rated this post out of 5. Change rating

2004-12-13 (first published: )

194 reads

Blogs

Friday Flyway Tips–Flyway Parameters

By

Flyway is a command line tool with lots of options and parameters. Working with...

A New Word:Wildred

By

wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in...

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Read the latest Blogs

Forums

Query goes crazy.

By Robert-378556

Hi. I have a query that returns few rows (out of 7 table join,...

Migration from Sybase SAP SQL Anywhere to SQL Server 2022

By Stewart "Arturius" Campbell

We are working on a project to migrate a client from a version of...

How to Setup Backups and Restore planning in SQL Server Availability Groups?

By BK

I need some help regarding How to Setup Backups and Restore planning in SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers