SQLServerCentral - Guest Columnist: Dwain Camps

A Hazard of Using the SQL Merge Statement

The SQL MERGE statement can make your DML querying more efficient but you need to take care or you may get burned Read more...

By Dwain Camps 2013/04/03 | Source: SQLServerCentral.com | Category: merge

Rating:

|

Discuss |

Briefcase | 11,146 reads

Departures from Origins and Arrivals at Destinations

A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem. Read more...

By Dwain Camps 2012/12/11 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,334 reads

Double Counting and Sign Reversals

Make the ad-hoc analysis of identifying potentially double-counted or sign-reversed Accounting transactions simple and painless. Read more...

By Dwain Camps 2013/01/07 | Source: SQLServerCentral.com | Category: sql bin packing

Rating:

|

Discuss |

Briefcase | 3,816 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems. Read more...

By Dwain Camps 2012/11/29 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 9,229 reads

An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

Normalizing or UNPIVOTing data may be improved by using this lesser known approach in SQL Server 2008 or later. Read more...

By Dwain Camps 2012/08/02 | Source: SQLServerCentral.com | Category: cross apply values unpivot

Rating:

|

Discuss |

Briefcase | 8,210 reads

Set Up Grouping Intervals for Excel (SQL Spackle)

So you want to group your data for charting in Excel? Here's how, the easy way! Read more...

By Dwain Camps 2012/07/31 | Source: SQLServerCentral.com | Category: excel

Rating:

|

Discuss |

Briefcase | 5,106 reads

Generating Non-uniform Random Numbers with SQL

Some FUNCTIONs to help generate non-uniform random numbers from uniform random numbers including Normal, Multinomial, etc. Read more...

By Dwain Camps 2012/07/03 | Source: SQLServerCentral.com | Category: sql uniform random numbers

Rating:

|

Discuss |

Briefcase | 5,869 reads

Exploring Recursive CTEs by Example

Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons. Read more...

By Dwain Camps 2012/07/17 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 10,636 reads

Generating n-Tuples with SQL

An n-Tuple is a combination of values from rows of a table in pairs (2-Tuple) or triplets (3-Tuple), etc. Read more...

By Dwain Camps 2012/05/17 | Source: SQLServerCentral.com | Category: sql n-tuples

Rating:

|

Discuss |

Briefcase | 8,062 reads

Financial Rounding of Allocations

When rounded detail quantities are created by an allocation, often the total must foot back exactly to the allocated amount. Read more...

By Dwain Camps 2012/03/19 | Source: SQLServerCentral.com | Category: financial rounding

Rating:

|

Discuss |

Briefcase | 4,492 reads