T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Debugging T-SQL

  Ho do I step through or debug my T-SQL code. I'm trying to use a cursor to compare 5 fields from o…

  markjrouse

  6 replies

  15 years, 9 months ago

  By: Jeff Moden

• Need rows where a date is between start and end dates OR before a start date

  I have this table of dates: mark_per start_date end_date -------- ---------- ---------- M1 0…

  DakotaPaul

  14 replies

  15 years, 9 months ago

  By: SwePeso

• How to get last 10 characters in all rows of a single(same) column?

  Hi, Can anybody suggest me "How to get last 10 characters in all rows of a single(same) column?". T…

  elchuru

  6 replies

  15 years, 9 months ago

  By: Garadin

• msdb.dbo.sp_send_dbmail HTML formatting issue

  Not too sure, If this forum fits here but here it goes. I send out the following email everyday.Wha…

  LOOKUP_BI-756009

  4 replies

  15 years, 9 months ago

  By: LOOKUP_BI-756009

• Round currency values

  I'm looking for a way to identify all round currency amounts in a given fileld. So if I have a tab…

  markjrouse

  10 replies

  15 years, 9 months ago

  By: Paul White

• Need help with conditional column

  I've found several examples of how to use the CASE statement to do this but for some reason I canno…

  tesker

  7 replies

  15 years, 9 months ago

  By: The Dixie Flatline

• Can this CTE based query be written more efficiently?

  Hi there, I am trying to get data in the format of table ##Temp1 into the format of table ##Temp2 …

  Wobble Chops

  12 replies

  15 years, 9 months ago

  By: Wobble Chops

• Row transpose

  Hi. I have id , vlaue pairs data in rows...what i need is to transpose them into columns without us…

  Jus

  6 replies

  15 years, 9 months ago

  By: Nabha

• How to search exact word using LIKE operator?

  CREATE TABLE mytbl2 ( c1 sysname ); GO INSERT mytbl2 VALUES ('Discount is 10-15% off'); INSERT myt…

  Shamshad Ali

  18 replies

  15 years, 9 months ago

  By: Paul White

• Maximum Date that exists for two or three parties and also another table

  Hey guys, feel like this one should be obvious to me but it's just not working. I'm trying to get t…

  Nugby

  22 replies

  15 years, 9 months ago

  By: Paul White

• how to return an XML query as one field

  Hi, i have a query using FOR XML AUTO that i need to retrieve in only one big text field (one row, …

  zukko

  3 replies

  15 years, 9 months ago

  By: The Dixie Flatline

• error when deleting user account after Restore DB

  After Restoring DB i'm not able to drop a user in the database, i checked if the user owns any obje…

  mrsenthil

  1 replies

  15 years, 9 months ago

  By: Greg Charles

• T-SQL CASE Problem

  Hi, I'm trying to build an sp that will return a list of companies where the company first lett…

  dec_obrien

  11 replies

  15 years, 9 months ago

  By: BrainDonor

• Convert Row values to Columns

  Hi, Hi, I have a Microsoft access table that looks like this: Field1|Field2|Field3 1|0|1 1|10|…

  jplittle

  3 replies

  15 years, 9 months ago

  By: vijay.s

• How to create task in order to get one instead 3 column?

  Hi, I am beginner.Just an example. If I have table with 3 rows and 3 columns: customer number n…

  Jagger-784276

  10 replies

  15 years, 9 months ago

  By: Arjun Sivadasan