T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago

  By: VSP

• Types of UDF

  I'm currently using 2005 and hope to move to 2008 R2 soon. Having used UDFs (maybe inappropriately)…

  kuopaz

  3 replies

  14 years, 5 months ago

  By: okbangas

• USE statement with TRY / CATCH

  I'm executing some TSQL code in a job step. I need to specify the master database in the Database d…

  hindle.steve

  2 replies

  14 years, 5 months ago

  By: ghanshyam.kundu

• index curruption

  hey guys pl ztell me wat is the cause of index to b currupted ????

  faruk.arshad

  2 replies

  14 years, 5 months ago

  By: Arjun Sivadasan

• How do I consolidate multiple rows into 1 row of output

  The database I have stores notes on a 1 record per row basis. So if I see 3 lines of notes in the …

  gbankos

  6 replies

  14 years, 5 months ago

  By: Jeff Moden