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, 1 month 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

  9 years, 8 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

  9 years, 9 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, 1 month 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, 3 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

  10 years, 7 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

  10 years, 7 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 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, 3 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, 4 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

  11 years, 6 months 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

  11 years, 6 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

  11 years, 6 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

  11 years, 8 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, 1 month ago

  By: Alex Fekken