T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  3 years, 12 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

  4 years ago

  By: HollyRoy

• Urgent! - How to extract number from a string

  Hi, I try to extract number from a string, is there a SQL Server function to do that? If not, how t…

  zxmgh

  32 replies

  4 years, 1 month ago

  By: sudishnch

• Truncate variable table

  Is there any way to Truncate a Variable table i.e. declare @t table ( f1 int ) insert into @t sele…

  Mark F-428640

  3 replies

  4 years, 4 months ago

  By: khaledhusseinie

• Calculate pmt in t-sql (like excel)

  Please anyone! I like to calculate payment for loan monthly In excel it should look like this: =PMT…

  Stefan Bengtsson

  34 replies

  4 years, 6 months ago

  By: nsalat

• Generating a SP Dependency Tree

  Hi, Does anyone in here know how to generate a stored procedure dependency tree?   For example…

  Brian Ferguson

  15 replies

  4 years, 7 months ago

  By: g4b0_88

• pulling multiple numbers out of a string

  I need help pulling multiple number values out of a string field name is Details and here are some …

  tpd1989

  11 replies

  5 years ago

  By: Jeff Moden

• BCP error -Unable to open BCP host data-file

  SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Unable to open BCP hos…

  Sapna Ranka

  45 replies

  5 years, 2 months ago

  By: herbert.tobisch 95615

• Multiple row issue

  Hello I have a query where I join a table to another table that stores email addresses. So a query…

  faulknerwilliam2

  4 replies

  5 years, 4 months ago

  By: Brahmanand Shukla

• Active Directory Query

  Is it possible to query Active Directory for user account information?   I thought I hear…

  JuanBob

  29 replies

  5 years, 4 months ago

  By: dlechman

• Set variable =NULL

  In my stored proc, I'm trying to set/pass a datetime variable to NULL. Then I want to check if…

  Sam-170626

  6 replies

  5 years, 4 months ago

  By: Jeff Moden

• store output of sp_helptext to local variable

  Hi, I have a stored procedure mySP and I'd like to use a local variable to store the ouput from sp_…

  johnsql-193053

  9 replies

  5 years, 5 months ago

  By: Jonathan AC Roberts

• Need Split delimiter string into columns Solution

  Hi All, I need help with a string with delimiter that needs to be split into column names. I have b…

  smunshi

  26 replies

  5 years, 5 months ago

  By: Jonathan AC Roberts

• Passing GetDate() as a parameter to a UDF datetime parameter

  Hi, I know you can't use GetDate() in a UDF, but does anyone know a way of passing the output from …

  David le Quesne

  8 replies

  5 years, 5 months ago

  By: Chris Harshman

• How To Check if Job is Running?

  Does anyone know how to write the T-SQL that checks if a job is still running?  I need to make…

  johna1

  20 replies

  5 years, 6 months ago

  By: Nathan