T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Capitalizing only first letter of each Word in a Column using Query

  Hi , I am Having a Column full of Capital Letter words like "ABC DEF GHI " , i want to convert t…

  Guitar_player

  7 replies

  12 years, 5 months ago

  By: Jeff Moden

• column values don't get updated

  I need help please on the following: I have a query that updates a column of a table A. When I run …

  comfortzone0

  3 replies

  12 years, 5 months ago

  By: Gail Shaw

• Need to pull the data out of a row and into a comma separated string referencing the columnID

  I am a bit rusty on my SQL Server T-Sql due to work pushing me into MySQL and DB2. I am trying to c…

  dcesharkman

  15 replies

  12 years, 5 months ago

  By: Luis Cazares

• search text within for string

  Hi, I have the following query I want a new field to be added that will just pick the character in …

  SQL_Kills

  3 replies

  12 years, 5 months ago

  By: Alan Burstein

• Comparing two tables

  Hey guys, I have two tables that I need to compare and grab all the matching records that are in bo…

  asm1212

  5 replies

  12 years, 5 months ago

  By: spaghettidba

• Using a derived table to exludes ID's in it

  I am trying to exclude ID's that appear in the derived table SELECT Maxdate.Date,db1.CASEID FROM db…

  jon pill

  3 replies

  12 years, 5 months ago

  By: Luis Cazares

• Matching Column Data in Rows

  Something I thought would be so simple has me scratching my head. How do we return only those table…

  bpowers

  3 replies

  12 years, 5 months ago

  By: Sean Lange

• Modify XML in a field

  Hi Hi Guys, The following is a Sample OF an XML field I want TO Modify: DECLARE @TestTAb AS TABLE(…

  sharky

  2 replies

  12 years, 5 months ago

  By: sharky

• Altering procedures while being executed

  Hi gurus have a question: what happens if we alter a procedure when it is being executed? I used th…

  koustav_1982

  3 replies

  12 years, 5 months ago

  By: Keith Tate

• update columns dynamically

  i am trying to setup a process to update table and associated columns specified in admin tables. ad…

  mxy

  13 replies

  12 years, 5 months ago

  By: mxy

• Can a multistatement table-valued function return a user-defined table type TABLE?

  I've simplified the code as much as possible below. It works but I want to use a "user-defined tab…

  Bill Talada

  4 replies

  12 years, 5 months ago

  By: Grant Fritchey

• BIG Execution plan from DELETE !!

  Hi, I have a table with almost 1M records and whenever I deleted a record from it it took a lot of …

  PiMané

  7 replies

  12 years, 5 months ago

  By: PiMané

• UNABLE TO EXECUTE TO SP USING OPEN ROW SET

  Hi All, I have Stored Procedure as below. I am unable to execute that SP using open row set que…

  syamala.popuri

  4 replies

  12 years, 5 months ago

  By: vermontloghome

• Concatenate Fields, But Evenly Space

  I know how to concatenate two fields, but having issues spacing the two fields evening. If you look…

  Tek

  4 replies

  12 years, 5 months ago

  By: Ed Wagner

• query to get the size of all indexes in a database

  Hi Friends, Is there any query to get the size of all indexes in a database? Let us assume a databa…

  sundar329

  4 replies

  12 years, 5 months ago

  By: Bodhisatya