Brian Nordberg

  • Interests: Hiking, Biking, Canoeing, database stuff

Finding Similar Data Using SQL Server Integration Services

SQL Server 2005 has greatly increased the capabilities of the platform and brought the capabilities for complex ETL packages to many businesses at an affordable cost. One of the very interesting transformations you can use in SSIS is the fuzzy grouping task and new author Brian Nordberg brings us a look at how you can use this.

4.44 (9)

2007-07-16

8,281 reads

Frequency of each field in table

This SP will generate the frequency of each occurrence in a field or for every field in a table. The syntax isexex sp_freqall , , , , for example:exec sp_freqall utems2000_2001, null,lastname, 100would return a table (with a field name and a count) for each field in the utems2000_2001 table, except the lastname field and […]

2002-10-03

220 reads

Blogs

Behavior of numeric data types with ”

By

As we all know, there are various numeric data types, such as TINYINT, INT,...

Daily Coping 5 Mar 2021

By

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

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Read the latest Blogs

Forums

Golden Goose Outlet too

By allonsalevips

Black women are constantly being policed in this way: from what we wear and...

shared datasets and cache refresh option

By ricky969

hi guys! Problem:  1) Every time I overwrite an existing shared dataset (with a...

Question on report server database

By itmasterw 60042

Hi,   We just installed SQL Server 2019 on a new server and moved...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers