T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  2 months, 3 weeks 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

  4 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

  5 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

  7 months, 1 week 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

  10 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

  11 months, 3 weeks 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

  1 year, 3 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

  1 year, 4 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

  1 year, 7 months 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

  1 year, 10 months ago

  By: Jeff Moden

• using DOS START command inside of xp_cmdshell

  What I want to do is to issue a START command inside the xp_cmdshell.  This should start a new…

  Will1922

  13 replies

  1 year, 11 months ago

  By: murthykalyani

• Determine Start/End date of given (ISO)week and year

  How can I determine the startdate and enddate of a given ISOweek number and a year?? Can …

  Frank Peters

  9 replies

  1 year, 11 months ago

  By: Jeff Moden

• Calculate Percentage using GROUP BY

  I have a table that contains data in 2 columns that I need to calculate percentages on. An example…

  Jody Chancey

  6 replies

  2 years ago

  By: Staalbaard

• Reverse DNS lookup using T-SQL

  Hello, I have a stored procedure that is passed an IP address that I would like to do a reverse DNS…

  dcnorman

  7 replies

  2 years, 7 months ago

  By: Jeff Moden

• Netflix Style Queue Priority

  I am trying to figure something out and hitting a brick wall. If I had some code I would post it, …

  Skip

  8 replies

  2 years, 8 months ago

  By: HollyRoy