T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Lookup values similar to VLookUp in Excel

  Hi,I am struggling to write a procedure which looks up a value in a lookup table.See desired result…

  JJR333

  14 replies

  3 years, 9 months ago

  By: Haibanh

• How to remove Decimal point

  Hi i have column with data type as Varchar.The coloumns contains the numbers with decimal point in …

  dheer

  4 replies

  3 years, 9 months ago

  By: kaj

• Calling an XIRR function from a stored procedure...

  Hi Gang, I need to create a stored procedure that queries a SQL database, calculates an XIRR (consi…

  Don McPherson

  4 replies

  3 years, 9 months ago

  By: yuvaraj.palani

• Inserting error data into a table from CATCH statement within a TRY CATCH

  I've been researching for past two days and hitting my head against wall, but I can't figure this o…

  //Ravi

  11 replies

  3 years, 11 months ago

  By: lwe@xtra.co.nz

• Broadcast calender generator

  Hi guys, Did anyone ever have to create a function/stored procedure that would take a date as an in…

  sql_er

  11 replies

  4 years, 1 month ago

  By: rk_burkhart

• Where can I download a Thesaurus file?

  So we're looking at implementing FTS for a few term type lookup things in one of ours apps. Of cour…

  mtassin

  14 replies

  4 years, 2 months ago

  By: red-teapot

• Count consecutive number of years of orders

  Hi I like to get the number of consecutive years a customer have placed ordres starting from curren…

  cg 23106

  2 replies

  4 years, 3 months ago

  By: cg 23106

• Get local server's alias in T-SQL

  Hello, I'm trying to determine if there's a way to get a server's alias programmatically? Scenario:…

  schleep

  3 replies

  4 years, 4 months ago

  By: Steve Jones - SSC Editor

• Get local server's alias in T-SQL

  Hello, I'm trying to get the server name programmatically. Even after I do this: exec dbo.sp_dropse…

  schleep

  1 replies

  4 years, 4 months ago

  By: schleep

• SQL Agent Job Error - String or binary data would be truncated. [SQLSTATE 22001] (Error 8152)

  I'm running into the following message, "String or binary data would be truncated. [SQLSTATE 22001]…

  joshdbguy

  12 replies

  4 years, 4 months ago

  By: amolpatilasp

• merge data

  hi there i have 5 database with same table schema in my branches i want to have one data base in my…

  hossein141

  7 replies

  4 years, 6 months ago

  By: hossein141

• Only return first matches per Id and calculate difference of dates in minutes

  Hi,   I have a the below table, from the result set I only want to see records where the Statu…

  SQL_Kills

  2 replies

  4 years, 8 months ago

  By: Steve Collins

• how to change new schema name from existing schema - Table

  Hi, I want change schema name on Table. hwdata.DesktopSoft_Master to change dbo.DesktopSoft_Master …

  SQL Galaxy

  3 replies

  4 years, 8 months ago

  By: ScottPletcher

• query to calculated based on the value of previous month

  Dear SQL Expert, I want to make a query to calculate the amount for budget purposes. Here's the for…

  gentong.bocor

  14 replies

  4 years, 8 months ago

  By: Jeff Moden

• How to read list of files in folder using T-SQL?

  Does anyone know how to read files from spesific folder/path using T-SQL? Regards, Eko Indriyawan

  eko indriyawan

  27 replies

  4 years, 9 months ago

  By: Tomys