Discuss Content Posted by Jeff Moden

• Topics

  Started by

  Posts

  Last post

• Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

  Comments posted to this topic are about the item Find Customers Who Bought "A" and "…

  Jeff Moden

  166 replies

  9 years, 10 months ago

  By: ColdCoffee

• Order by does not work with intersect (thread started by suggestion from Sean Lange)

  I have two tables with patient ID - one contains several records for one ID (tblLetterFlag), in the…

  valeryk2000

  9 replies

  9 years, 10 months ago

  By: Lynn Pettis

• Finding “Active” Rows for the Previous Month (SQL Spackle)

  Comments posted to this topic are about the item Finding “Active” Rows for the Previous Month (…

  Jeff Moden

  41 replies

  10 years, 2 months ago

  By: Marcia J

• Displaying Sorted Hierarchies (SQL Spackle)

  Comments posted to this topic are about the item [font="Arial Black"]Displaying Sorted Hierarchies …

  Jeff Moden

  57 replies

  10 years, 2 months ago

  By: sholliday

• Query Tuning

  Comments posted to this topic are about the item Query Tuning --Jeff Moden RBAR is pronounced "ree-…

  Jeff Moden

  49 replies

  10 years, 3 months ago

  By: pmadhavapeddi22

• Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

  Comments posted to this topic are about the item Why doesn’t ISNUMERIC work correctly? (SQL Spack…

  Jeff Moden

  168 replies

  10 years, 5 months ago

  By: Jeff Moden

• Display More Than 8000 Characters (SQL Spackle)

  Comments posted to this topic are about the item Display More Than 8000 Characters (SQL Spackle) --…

  Jeff Moden

  67 replies

  10 years, 5 months ago

  By: Jeff Moden

• Generating Test Data: Part 1 - Generating Random Integers and Floats

  Comments posted to this topic are about the item Generating Test Data: Part 1 - Generating Random I…

  Jeff Moden

  60 replies

  10 years, 6 months ago

  By: Jeff Moden

• Generating Test Data: Part 2 - Generating Sequential and Random Dates

  Comments posted to this topic are about the item Generating Test Data: Part 2 - Generating Sequenti…

  Jeff Moden

  40 replies

  10 years, 8 months ago

  By: ChrisM@Work

• Formatting Dates with 3 Character Months (SQL Spackle)

  Comments posted to this topic are about the item Formatting Dates with 3 Character Months (SQL Spac…

  Jeff Moden

  108 replies

  10 years, 9 months ago

  By: Bruce W Cassidy

• Testing other functions of splitting strings

  Hi, Can you please test your new functions' performance against the following function : CREATE FUN…

  Dirk vd Watt

  2 replies

  11 years, 3 months ago

  By: Lynn Pettis

• Triggers Execution

  I HAVE HAVING 2 DATABASES 1 IS HAVING MORE THAN 25 TRIGGERS.I HAVE TO TAKE ALL 25 TRIGGERS AT A TIM…

  skgudi2009

  4 replies

  11 years, 4 months ago

  By: nigelrivett

• need a urgent help

  CREATE TABLE STUDENTLOGIN(username varchar(30), password varchar(30), …

  ch.omkarreddy

  4 replies

  11 years, 5 months ago

  By: ch.omkarreddy

• can't attach adventurework database 2012

  I am trying to attach aventurework database 2012, but I am getting an Operating system error 5: "5(…

  seyoumblen

  1 replies

  11 years, 6 months ago

  By: Lowell

• And the LINQ version looks like...

  After coding the RBAR logic to populate a complex TreeView, I come across this article and say "Whe…

  rhj4

  2 replies

  13 years, 1 month ago

  By: rhj4