T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Extracting a specific number of words from a string in sql

  I'm currently trying to write a query that will extract the first two words from a string. I'm usin…

  Griffster

  16 replies

  7 years, 6 months ago

  By: Jeff Moden

• GREATEST and LEAST function

  Hi, I'm looking for a function in T-SQL for getting the biggest or the smallest value between two o…

  corallo.d

  16 replies

  7 years, 6 months ago

  By: alansoft_br

• parsing variable into @query using sp_send_dbmail

  Hi, I have a stored procedure that users sp_send_dbmail and i'm trying to pass through a variable t…

  Warwick Francis

  9 replies

  7 years, 7 months ago

  By: harinath6nataraJan

• Cursor variable losing data

  Hi, I have an SQL Server agent job which essentially fetches the names of databases to be backed up…

  DBANewbie

  6 replies

  7 years, 7 months ago

  By: 3rd Normal Form

• Inserting rows into remote server with identity column

  I am having troubles trying to copy some rows from a table on my local computer to a table on a rem…

  vgehtsrick

  9 replies

  7 years, 8 months ago

  By: Jack Corbett

• how to convert seconds to time in sql

  hi, Could you please give any formula for that to convert seconds to time... Thanks, Giri

  dastagiri16

  14 replies

  7 years, 9 months ago

  By: dreamcodelife

• Conditional Search

  Its been a while since I have worked with SQL. So much that I am struggling to ask this appropriate…

  CaseyP 58642

  12 replies

  7 years, 9 months ago

  By: Phil Parkin

• Join with Same table

  Hi All, I have below scenario There are Two tables: CREATE TABLE DBO.TBLORDERTYPE(ID INT IDENT…

  sam 55243

  2 replies

  7 years, 9 months ago

  By: sam 55243

• Full text search with Contains function

  Hello All, I have one field in the database table having the value for eg as "Wilson,Gregory T". In…

  shivanee.chikhalikar

  2 replies

  7 years, 9 months ago

  By: Sue_H

• Bulk Insert Multiple html files data in table

  Hi All, I want to insert multiple html files data (contents) to my existing table. I already have t…

  nuhassan786

  2 replies

  7 years, 10 months ago

  By: saeed_savalan

• is it a good practice to return multiple datasets in a stored procedure

  Is it a good practice to return multiple datasets in a stored procedure?

  Aparna-1

  5 replies

  7 years, 10 months ago

  By: g.lacey

• Deleting records based on Item matching and Drill Level

  Would like to write query which will delete all the reocrds at that TreeLevel where the item and ma…

  skb 44459

  1 replies

  7 years, 10 months ago

  By: bonggaspar

• How can I ignore 'not for replication' constraints like the merge agent does?

  Please forgive me for cross-posting this. I had originally posted this question 5 days ago in the S…

  R.P.Rozema

  1 replies

  7 years, 11 months ago

  By: R.P.Rozema

• How to identify the position of the nth occurance of character in a string

  Hi Folks, I would like to know the best way to identify the nth occurrance of a specified character…

  Morris Logan

  7 replies

  7 years, 11 months ago

  By: awais_487

• SQL Days until Christmas

  I was asked to calculate the days until christmas Select DateDiff(dd,getdate(),'12-25-' + convert(n…

  mfink

  8 replies

  8 years ago

  By: webburada