T-SQL

• Topics

  Started by

  Posts

  Last post

• T-SQL - except - add date column

  . This topic was modified 2 weeks, 6 days ago by mtz676.

  mtz676

  1 replies

  2 weeks, 5 days ago

  By: Site Owners

• T-SQL - except - add date column

  SELECT         [A]       --,[Date]       ,       ,[C]       ,[D]       ,[E]          FROM [Database…

  mtz676

  6 replies

  2 weeks, 5 days ago

  By: DesNorton

• T-SQL - except - add date column

  SELECT [A] --,[Date] , ,[C] ,[D] ,[E] FROM [Database].[dbo].[Table] where B < 1000 AND   (CheckD…

  mtz676

  0 replies

  2 weeks, 6 days ago

  By: mtz676

• Count of Total Appointments within 30 days of each Appointment Date

  Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2) Has a field Appo…

  Reh23

  5 replies

  5 months, 1 week ago

  By: Jeff Moden

• Significant Digits

  I'm trying to create a function dealing with "Significant Digits" for use in an application for our…

  DMinard

  7 replies

  5 months, 4 weeks ago

  By: Jeff Moden

• Banker''s rounding in T-SQL (like Math.Round in .NET)

  Hi! I'm in extreme need of T-SQL function wich will round to the nearest even number, called banker…

  Andrew Vasylevskyy

  53 replies

  1 year, 9 months ago

  By: Jeff Moden

• Round to Even (aka Banker''s Rounding) - The final function

  Since the other thread was trainwrecked, but since there is indeed a problem with the function as c…

  David McFarland

  378 replies

  1 year, 10 months ago

  By: angularsen

• Use BCP and a format file to export data to a text file

  I would like to use BCP and a format file to export data to a text file in a fixed length format. F…

  Randy Powell-473969

  9 replies

  1 year, 11 months ago

  By: wbailey

• Lookup table without modifying database

  I have a production database that I will be running queries against. I am not allowed to modify tha…

  Göran Roseen

  13 replies

  2 years, 1 month ago

  By: Phil Parkin

• Nesting Cursors

  I'm developing a complex T-SQL procedure which uses nested cursors; or at least tries. Using the d…

  scking

  6 replies

  2 years, 4 months ago

  By: Jeff Moden

• Converting from Gregorian to Julian Dates For JDE

  Because JD Edward uses Julian Dates from 01/01/1900, you can use this code for converting CONVERT(V…

  paeast

  12 replies

  2 years, 6 months ago

  By: Jeff Moden

• Random Assignment of Groups for Simulation

  I am working on a simulation which takes 120-300 records, randomly assigns them to 10 arbitrary gro…

  Andrew Geppert

  4 replies

  2 years, 9 months ago

  By: Ed B

• Best way to learn T-SQL for MS SQL Server?

  Hello Everyone, At work, I've been getting more involved with hosting and database stuff. I current…

  natsu30

  4 replies

  2 years, 10 months ago

  By: Jeff Moden

• OPENROWSET linked server "(null)" error

  Hi, I'm trying to execute a script that uses OPENROWSET to execute a procedure which intern has ano…

  ash_m

  12 replies

  3 years, 1 month ago

  By: susejzepol

• Query records in last 12 months

  Hi, In my query it needs to return records which were created in past 12 months. I'm not familiar w…

  Tuan H. Le

  8 replies

  3 years, 5 months ago

  By: Jeff Moden