Discuss content posted by Dwain Camps

• Topics

  Started by

  Posts

  Last post

• Creating a Date Range from Multiple Rows Based on a Single Date

  Comments posted to this topic are about the item Creating a Date Range from Multiple Rows Based on …

  Dwain Camps

  13 replies

  9 years, 8 months ago

  By: Dwain Camps

• A Hazard of Using the SQL Merge Statement

  Comments posted to this topic are about the item A Hazard of Using the SQL Merge Statement My mantr…

  Dwain Camps

  58 replies

  10 years, 3 months ago

  By: quackhandle1975

• Exploring Recursive CTEs by Example

  Comments posted to this topic are about the item Exploring Recursive CTEs by Example My mantra: No …

  Dwain Camps

  42 replies

  10 years, 4 months ago

  By: xsevensinzx

• The SQL TABLE Type: Beyond Table-Valued Parameters

  Comments posted to this topic are about the item The SQL TABLE Type: Beyond Table-Valued Parameters…

  Dwain Camps

  12 replies

  10 years, 9 months ago

  By: Dwain Camps

• Unravel Some Complex IF Logic

  Comments posted to this topic are about the item Unravel Some Complex IF Logic My mantra: No loops!…

  Dwain Camps

  17 replies

  10 years, 10 months ago

  By: PChiragS

• Tally Tables

  Comments posted to this topic are about the item Tally Tables My mantra: No loops! No CURSORs! No R…

  Dwain Camps

  47 replies

  11 years, 2 months ago

  By: Dwain Camps

• Variable Default Values to a Stored Procedure (SQL Spackle)

  Comments posted to this topic are about the item Variable Default Values to a Stored Procedure (SQL…

  Dwain Camps

  15 replies

  11 years, 3 months ago

  By: Jeff Moden

• Passing Tables as Parameters

  Comments posted to this topic are about the item Passing Tables as Parameters My mantra: No loops! …

  Dwain Camps

  25 replies

  11 years, 7 months ago

  By: sqlnaive

• Double Counting and Sign Reversals

  Comments posted to this topic are about the item Double Counting and Sign Reversals My mantra: No l…

  Dwain Camps

  9 replies

  11 years, 10 months ago

  By: Dwain Camps

• Departures from Origins and Arrivals at Destinations

  Comments posted to this topic are about the item Departures from Origins and Arrivals at Destinatio…

  Dwain Camps

  10 replies

  11 years, 11 months ago

  By: Dwain Camps

• Primary Keys

  Comments posted to this topic are about the item Primary Keys My mantra: No loops! No CURSORs! No R…

  Dwain Camps

  26 replies

  12 years, 1 month ago

  By: kalyani.k478

• Days Difference Between 2 Dates

  Comments posted to this topic are about the item Days Difference Between 2 Dates My mantra: No loop…

  Dwain Camps

  29 replies

  12 years, 2 months ago

  By: David Conn

• Generating n-Tuples with SQL

  Comments posted to this topic are about the item Generating n-Tuples with SQL My mantra: No loops! …

  Dwain Camps

  51 replies

  12 years, 2 months ago

  By: Dwain Camps

• Set Up Grouping Intervals for Excel (SQL Spackle)

  Comments posted to this topic are about the item Set Up Grouping Intervals for Excel (SQL Spackle) …

  Dwain Camps

  5 replies

  12 years, 4 months ago

  By: Misha_SQL

• Financial Rounding of Allocations

  Comments posted to this topic are about the item Financial Rounding of Allocations My mantra: No lo…

  Dwain Camps

  35 replies

  12 years, 8 months ago

  By: Alex Fekken