T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Trying to modify a colum based upon the content already there

  Hello folks, I don't bump into this so often, and after extensive googling I haven't been able to p…

  colyte

  5 replies

  15 years, 1 months ago

  By: colyte

• String Manipulation/Character Removal

  Hi, I need manipulating strings and removing patterns in those strings. I have 3 examples of strin…

  Jody Claggett-376930

  10 replies

  15 years, 1 months ago

  By: TheSQLGuru

• need to format sql query output in physical xml output file

  Hi, This is what I have written in query editor(sql server 2008): select wmwhse1.SKU.SKU from wmwhs…

  ninad.kubal

  1 replies

  15 years, 1 months ago

  By: Victor Dvoryaninov

• 3 part naming in the query

  I was able to run the folowwing query on sql 2005 server(OBBEAVER1) select top 1* from obbeaver1.Em…

  Tara-1044200

  6 replies

  15 years, 1 months ago

  By: Mike John

• How to code this

  How can I turn the following code into a set operation: declare @pk INT select CAST( 0 as int) as …

  mike 57299

  3 replies

  15 years, 1 months ago

  By: mike 57299

• The Theta Joins

  Hi, Please consider the following code CREATE TABLE Table1( Id TINYINT,Description VARCHAR(5), Ind…

  Rjch

  3 replies

  15 years, 1 months ago

  By: Rjch

• generating sequential number in sql 2000

  I have one requirement where i need to generate the sequential numbers for group of data in Single …

  Abhijit More

  1 replies

  15 years, 1 months ago

  By: spaghettidba

• AVG function on varchars

  So I have a table called satisfaction with 5 columns •sati_satiid •sati_quickly •sati_informed •…

  dave 92282

  3 replies

  15 years, 1 months ago

  By: dave 92282

• Replace NULL values created by left outer join

  I am trying to replace the NULL values that are created by a left outer join but having a little tr…

  Triality

  5 replies

  15 years, 1 months ago

  By: Triality

• From master, can you CREATE USER on a different database?

  I have been asked to write a single stored procedure which restores a db, then drops some users and…

  steal

  3 replies

  15 years, 1 months ago

  By: Johan Bijnens

• Limit to first row of table, and then...

  Sorry, don't quite know what to search on for this. SELECT _TOPICS.ID, _TOPICS.TITLE, _THREAD.TITLE…

  bhsmither

  6 replies

  15 years, 1 months ago

  By: Dima-99208

• Multiple UNION ALL queries cause SSMS to hang/freeze up/ slow down?

  Has anyone noticed this? I have a relatively straight forward set of UNION ALL queries. I have a CT…

  Maxer

  7 replies

  15 years, 1 months ago

  By: UMG Developer

• populate a temp table with a variable number of copies of a row

  I need to create a demo database. I have some SME's entering sample data. I will need to create n…

  maroon-78

  3 replies

  15 years, 1 months ago

  By: UMG Developer

• Trigger - Access to filepath?

  I need to create a trigger event (on create) that will, based on values in the new row, open a mat…

  scampbell301

  2 replies

  15 years, 1 months ago

  By: scampbell301

• SQL Query Performance Issue when using a IntegerListType

  I have a query which is using a IntegerListType, havng implemented the integerlisttype it nows runs…

  shanewiso

  3 replies

  15 years, 1 months ago

  By: shanewiso