T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Comment in update statement causes it to skip second part of update

  I have an update statement. Update Table1 Set field1 = 'Value1', --This updates field one …

  Alan Naylor

  1 replies

  14 years, 8 months ago

  By: Evil Kraig F

• rows into columns

  I'm tring to get results that has first name and last name in a single row rather than column, any…

  mnicholas

  1 replies

  14 years, 8 months ago

  By: Jeff Moden

• Best book to learn t-sql between........

  What is the book to learn T-SQL between: The Guru's Guide To Transact SQL and Microsoft® SQL Server…

  YankeesSQL

  10 replies

  14 years, 8 months ago

  By: SQLRNNR

• Enriching duplicate records (not deleting)

  I need to enrich records which are duplicates before I remove them. So no records will be deleted, …

  petervdkerk

  14 replies

  14 years, 8 months ago

  By: petervdkerk

• Getting values from multiple rows into single row

  I have a table A that contains a ID and value column, the primary key is set on this 2 columns. Tab…

  Ronvy

  2 replies

  14 years, 8 months ago

  By: LutzM

• Delete extraneous similar rows

  I have a problem where i need to delete extraneous similar rows from a database. For example assume…

  BobMcC

  4 replies

  14 years, 8 months ago

  By: BobMcC

• How to generate all Possible Alphabit pattern in a sequence?

  Hi, In one query, starting either at "Select" OR ";With", how can we generate all possible patterns…

  iBar

  21 replies

  14 years, 8 months ago

  By: Jeff Moden

• Need to pivot with a customer table and a phoneContact table

  If I have a customer table with 2 columns: Cust_ID, CustomerName And a PhoneContact table with the …

  dndaughtery

  1 replies

  14 years, 8 months ago

  By: Jeff Moden

• Capturing the actual SQL in script

  Hello, I would like to know if it is possible to capture the actual SQL executed against the databa…

  Zagyg

  4 replies

  14 years, 8 months ago

  By: webtomte

• Works in MySql but not in Ms Access ODBC bug. I need a work around

  Hello All, My database is in MySql and I am developing a reporting tool in Ms Access. So I link to …

  marishasingh82

  5 replies

  14 years, 8 months ago

  By: marishasingh82

• Updating Guid Field by Converting CharacterString to UniqueIdentifier - Which row is bad?

  Hi All, I am needing to update a field in a table and pull a substring from another field. The fie…

  JimiJett

  5 replies

  14 years, 8 months ago

  By: JimiJett

• bcp problem

  Can I bcp the records from flat file in unix to sql server 2008 ?

  sqlnaive

  2 replies

  14 years, 8 months ago

  By: Ron McCullough

• Generate MS project like plan using TSQL

  Hi All, I am currently working on a POC to generate a plan on already existing data. let me explain…

  avistyx

  3 replies

  14 years, 8 months ago

  By: David Moutray

• select unique record

  I've created a SSRS report that retrieves a summary of customer sales for a period of time. The pa…

  Linked999

  1 replies

  14 years, 8 months ago

  By: Sean Lange

• How to only return one row per key with a LEFT JOIN

  I have a join on our work orders database between Work Orders and Service orders. Very rarely there…

  Sean Grebey-262535

  11 replies

  14 years, 8 months ago

  By: VSP