Data Generation

SQLServerCentral Article

A Simple Formula to Calculate the ISO Week Number

  • Article

He admits it wasn't his idea but his head sure wishes it was. SQL Server MVP Jeff Moden explains a wonderful, super simple, very high performance formula that will calculate ISO Week Numbers. If you're "stuck" with SQL Server 2005 or less, you're going to like this a whole lot!

4.89 (36)

2015-10-23 (first published: )

31,367 reads

Technical Article

RE: Duplicate Records

  • Reply

Something like this..CREATE TABLE SSNTemp (  SSN char (10) NOT NULL ) CREATE UNIQUE   INDEX [IX_SSNTemp] ON SSNTemp ([SSN]) WITH     IGNORE_DUP_KEYinsert into SSNTemp select ssn from yourssntable delete from yourssntableinsert into yourssntable select ssn from SSNTemp  


Technical Article

Data till transaction is commited

  • Topic

Hi All,II have a question on Transaction commit/rollback. Question My understanding is that untill a transaction is comitted, the modifications(inserts/updates/deleted) are not made on th disk ( datafiles). For Example if i am doing a bulk copy of millions of records from a flat file on to sql server table, untill all the records are […]


Technical Article

RE: Drill Through filter option

  • Reply

In the Cube Drillthrough Options screen, on the Columns tab, you should see all of the columns contained in all of the tables used in your model. Assuming you have only 2 tables, a fact and a single dimension, the columns may be something like COLUMN TABLE fkCol1 tblFact fact1 tblFact fact2 tblFact pkCol1 tblDim1 […]


Technical Article

RE: Invalid column

  • Reply

quote: ...if you placed a GO between the Alter and the Select... True in this contrived example but not if the intention was to use it in a procedure.


2 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