Calendar Table

External Article

Time Slots - An Essential Extension to Calendar Tables

  • Article

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.


7,291 reads

Technical Article

RE: SQL server 2000 and Outlook security issues?

  • Reply

I don't think the mention of Notepad was "silly" at all.  It sounded to me as if Outlook was forbidden simply because it is a client application, but there are others.  You have clarified above as a client application with lots of dependencies, which changes things somewhat.  Since you're not using DTS package, it probably doesn't […]


Technical Article

bulk copy execution failed when using DTS Import/Export Wizard

  • Topic

Hi Guys,I am using DTS Import/Export Wizard to copy database from one machine to another. I created a new database on the destination. In 'Specify Table Copy or Query' window, I chose 'Copy obects and data between SQL Server databases'. Error message is 'bulk copy execution failed'. Copy Database Wizard doesn't work either. How to […]


8 reads

Technical Article

RE: Convert Columnar Data to Row Data

  • Reply

quote: That's why I included a where clause so that if you specif y one studentID you will get 75 rows you could specify several students paging by studentID also. Thanks, this has been a big help! The following is what I have set up: ************************** DECLARE @Grade AS Smallint DECLARE @TestID AS Varchar(10) SET […]


1 reads


Tell My Story of Public Speaking


This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...

The Last Trip of 2022


It’s the last trip for me today. I head to the UK for a...

How to cluster SAP ASCS/SCS with SIOS DataKeeper on VMware ESXi Servers


This article describes the steps you take to prepare the VMware infrastructure for installing...

Read the latest Blogs


Get Date Monday Show results for weekend and then else 24 hours


Hi,   I have a SQL query below in which i need to be...

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

ASP.NET website force different windows authenticated user

By Raja mssql

Hi All, We are deploying website by using windows authenticated user. It is default...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers